How to resolve log rotation error?

sdebiasio · 09-07-2004, 10:36 AM

Hi,

My log file rotation function is not working, I keep getting the following error emailed to me from Cron:

Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Anyone know how I can resolve this? The root account is set up with a password in the MySQL user table. Do I need to set up a new account with no password required?

Thanks!

bathory · 09-07-2004, 10:40 AM

One solution is this, i.e. create a new full priviledged user with to password and the other is to supply the root password in mysqladmin. If I remember well you can run it with -u root -p password to do your job.
Regards

sdebiasio · 09-07-2004, 11:42 AM

Thanks for your help!

When I try to edit mysqladmin, I get a bunch of weird characters. How can I edit this file to supply the password? (I assume that's what I need to do?)

Also, if instead, I create a new full-privileged user with no password, do I simply need to set up the cron job under that username?

scuzzman · 09-07-2004, 12:06 PM

If you get a bunch of wierd characters, I think it's probably a binary. Personally, I don't use SQL, but i think you may actually want to run it like this:

Code:

[user@host ~]$ mysqladmin -u root -p PASSWORD

bathory · 09-08-2004, 03:48 AM

You don't edit mysqladmin. You just have to run it as scuzzman said. Or if you can create a full priviledged user with no password you can run it like this:

Code:

mysqladmin -u full-user

so it does not ask for a password
Perhaps you can provide us with the script or the crontab entry to help you more.