List:General Discussion« Previous MessageNext Message »
From:Corey Date:July 31 2010 11:27pm
Subject:strange authentication issue
View as plain text  
Hello - I'm only moderately familiar with mysql; the following issue has me 
stumped.

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
Enter password: 
ERROR 1045 (28000): Access denied for user 'scripts'@'localhost' (using 
password: YES)

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.

mysql> 


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. 


Thankyou!
Thread
strange authentication issueCorey1 Aug
Re: strange authentication issuechaim rieger1 Aug
Re: strange authentication issueCorey1 Aug
Re: strange authentication issuechaim rieger1 Aug
Re: strange authentication issueCorey1 Aug
  • Re: strange authentication issueClaudio Nanni1 Aug
    • Re: strange authentication issueCorey1 Aug
      • Re: strange authentication issueClaudio Nanni1 Aug
        • Re: strange authentication issueCorey1 Aug
          • Re: strange authentication issueClaudio Nanni1 Aug
          • Re: strange authentication issueClaudio Nanni1 Aug