Hello - I'm only moderately familiar with mysql; the following issue has me
I just noticed that some scripts on one of my client's servers suddenly
started failing due to being no longer able to log into the mysql db.
I have not touched the mysql config on that machine in months.
The problem is as follows:
The scripts need to login to mysql as user 'scripts'.
Suddenly, user 'scripts' can only log into the mysql console _without_
a password (or using an empty/null password):
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
ERROR 1045 (28000): Access denied for user 'scripts'@'localhost' (using
However, the following works just fine (without the '-p' option):
/usr/local/mysql/bin/mysql -u scripts
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 4.1.14-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
I've checked the mysql.user table, and ensured that user 'scripts'
indeed still has a password. I also went ahead and reset it:
mysql> update user set password=PASSWORD("mypwd") where User='scripts';
Query OK, 1 row affected (0.03 sec)
Then I flushed the privileges, restarted mysql and tried again - same issue:
I can _only_ log into mysql with user 'scripts' _without_ a password.
I have no clue what might be causing this behavior (or why in the world this
suddenly started occurring, in the first place).
I could really use some advice and help - because I've tried everything I
can think of, and the problem seems unshakable.