David, On Friday 28 Jan 2011 17:10:15 David C. Rankin wrote:
Bob,
Another trick in ~/.my.cnf (if your user and mysql install is secured) is to set your login info in the file (then set the appropriate file permission) to allow you to use mysql without having to provide the '-u user -p' string every time you want to do something. It is very handy. Just add the following to ~/.my.cnf:
[mysqladmin] password = yourMySQLUserPass user = yourMySQLUser
[mysql] password = yourMySQLUserPass user = yourMySQLUser
[mysqldump] password = yourMySQLUserPass user = yourMySQLUser
and, of course, replace the yourMySQL... data with the actual values. Then all you need to do is type:
mysql <whatever>
and you are good to go...
Many thanks, all useful stuff. Having fun INSERTING all the members of our sailing club. There's only 30 ATM, so once it's done, it's done :) Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3 Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org