Topic: mysql access denied

[JeffC]

While trying to install snort-acid I found that mysql was not allowing command line access.  I have not changed the password in .my.cnf

[root@dev /root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

I can create the database with phpmyadmin, but can't build the tables.  Any ideas?

Thanks,

-jeff

[Achim]

Maybe this two liks give you some answers:
http://www.cyber-euskadi.com/howtos/contrib/postnuke-0.6-howto.html
and
http://www.familybrown.org/howtos/mysql-password-howto.html
but the solution is under:
http://www.redwood.com.ph/mitel/contrib/ and check for the phpMyAdmin rpm.
this shold work out of the box

Regards Achim

[JeffC]

Thanks Achim,

I already have phpMyadmin installed.

The problem is that no matter what I do, mysql will not allow access from the command line.  The downside of this is that any rpm install which uses mysql will fail.

I am running 5.1.2 with mysql-3.23.36-1

A command line of "mysql" or "mysqladmin" or "mysql -u root" all return the same error....

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

-jeff

[Dan Brown]

Looks like somehow the mysql root password has been changed.  If you know what the password has been changed to, you can specify it on the command line with the -p flag.  If not, there's a procedure in the Mysql manual at www.mysql.com to take care of this.

[JeffC]

Dan,

You handed me the answer.  I had done a restore from another SME machine for some root files and evidently the password got stepped on. (duh!)

A visit to your howto and resetting the password did the trick.

Thanks!!

-jeff

[Looney Tunes]

I can get to mysql from the command line, but I'm unable to log into phpMyAdmin. If I use the standard mysql password I get a 401 Authorization Required Error. When i use the admin/root password I get:

Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)
Back

I've been searching the forums, but no matter how much I search, the answer seems to alude me. Any suggestions?

[Pedro]

me too. can't find the answer to this one anywhere...

[mike mattos]

I had some similar problems, learned that MySQL cares where you are and adds @domain.com automatically, and searches passwords in a non intuitive manner.

Did you log in mysql -u root -p ??

Do other users work?  

If so, I suspect your root password has been changed as happened in the earlier case!

Mike