Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: JeffC on January 10, 2003, 06:17:27 PM

Title: mysql access denied
Post by: JeffC on January 10, 2003, 06:17:27 PM

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

Title: Re: mysql access denied
Post by: Achim on January 10, 2003, 06:44:55 PM

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

Title: Re: mysql access denied
Post by: JeffC on January 10, 2003, 06:54:32 PM

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

Title: Re: mysql access denied
Post by: Dan Brown on January 10, 2003, 07:02:08 PM

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.

Title: Re: mysql access denied
Post by: JeffC on January 10, 2003, 07:10:56 PM

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

Title: Re: mysql access denied
Post by: Looney Tunes on February 19, 2003, 08:28:25 PM

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?

Title: Re: mysql access denied
Post by: Pedro on February 26, 2003, 03:35:13 PM

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

Title: Re: mysql access denied
Post by: mike mattos on February 27, 2003, 11:57:51 PM

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