Re: options file /root/.my.cnf ignored ???
Michael D Schleif [EMAIL PROTECTED] wrote: I have inherited several mysql v4x servers. All but one of them works as expected with /root/.my.cnf files. That last server is driving me nuts ; I have RTFM, and I do not find this particular problem anywhere. Pointers to TFM are welcome. # mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) # sudo cat /root/.my.cnf [client] user = root password = This works OK: # mysql -h localhost -u root -p Enter password: Yes, I do know that password, and the one in /root/.my.cnf is the same, and I have changed the password for root with the same results. My own user, mds, works as expected via options file ~/.my.cnf . What am I missing? Check value of HOME environment variable. Does HOME environment variable point to the /root directory? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: options file /root/.my.cnf ignored ???
Michael D Schleif wrote: I have inherited several mysql v4x servers. All but one of them works as expected with /root/.my.cnf files. Make sure /root/.my.cnf is owned by root, and mode 600. That last server is driving me nuts ; I have RTFM, and I do not find this particular problem anywhere. Pointers to TFM are welcome. # mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) # sudo cat /root/.my.cnf [client] user = root password = This works OK: # mysql -h localhost -u root -p Enter password: Yes, I do know that password, and the one in /root/.my.cnf is the same, and I have changed the password for root with the same results. My own user, mds, works as expected via options file ~/.my.cnf . What am I missing? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
options file /root/.my.cnf ignored ???
I have inherited several mysql v4x servers. All but one of them works as expected with /root/.my.cnf files. That last server is driving me nuts ; I have RTFM, and I do not find this particular problem anywhere. Pointers to TFM are welcome. # mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) # sudo cat /root/.my.cnf [client] user = root password = This works OK: # mysql -h localhost -u root -p Enter password: Yes, I do know that password, and the one in /root/.my.cnf is the same, and I have changed the password for root with the same results. My own user, mds, works as expected via options file ~/.my.cnf . What am I missing? -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- signature.asc Description: Digital signature