Hello, I would be happy to solve the following problem :
I get every week the following message on my Linux root mail account : ------------------------------------------------ /etc/cron.daily/logrotate: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' ------------------------------------------------ I looked many times on Internet for this kind of problem, and I found many pages and suggestions about it, but none of them seem to work. Most suggest to add lines to the files $HOME/.my.cnf or /etc/my.cnf So I have now : $HOME/.my.cnf = ------------ [client] # The following password will be sent to all standard MySQL clients password=myrootpassword # of course you will not know the actual password.... :-) ------------ After spending some time on it, I finished by gaving up, as this mail file is not as much annoying than the time needed for finding the information, and the database seems to work otherwise. This was at least one year ago. But now I get the same message when trying to install another product (i.e. the perl script DBD::mysql), so I am unable to install it. The log file for mysqld doesn't give better information, it tells the same thing : "Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)" If I just type "mysql" at command line (as root), it works without error, and without asking me any password. So I suppose that .my.cnf is correctly read : if I remove the password from it, this last command no longer works without password. I have one user 'root' in the table 'mysql.user' with a password and all permissions. My Linux's process list shows me two processes running about it : "safe_mysqld" running as "root", and "mysqld-max" running as "mysql". (changing the latter one to "root" doesn't solve the problem) I use MySQL version 4.0.13-Max on Linux RedHat 9.0 Please, could someone tell me how to make MySQL handling my root password correctly ? Thank you very much for any advice. Gingko. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
