Topic: phpmyadmin -Access denied for user

[kruhm]

I'm starting to fool around with mysql for the first time. I can access https://www.domainname.com/phpmyadmin/ but I get:

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

sme v6.0.1-01
mysql -v 4.0.22-standard
phpMyAdmin 2.6.0-pl3

[kruhm]

i did some more searching and found the answer.

you have to take the password for root and put it in to the /opt/administration/phpmyadmin/config.inc.php file. the top section of this file has a spot for password.

you can find the password in the /root/.my.cnf file.

[mrjhb3]

i did some more searching and found the answer.

you have to take the password for root and put it in to the /opt/administration/phpmyadmin/config.inc.php file. the top section of this file has a spot for password.

you can find the password in the /root/.my.cnf file.

You really don't have to do that.  You could create another user that has full rights as well.  Something like:

grant all privileges on *.* to youruser@localhost identified by 'yourpassword' with grant option;

flush privileges;

You may not have to use the grant option, but that's what I use.

Then you put the appropriate entries into the config.inc.php file.

JB

[kruhm]

learn something new everyday.

i wonder if any of this (or the mysql connectivity from another pc) can make it into the FAQ?

[Rosey]

I have the problem; I have accidentaly changes the root password in phpmyadmin. Now I get error 1845 acess denied for user ...... I have followed the recommendation above, But this did not fix the problem i am still locked out. I can use the admin log in like usaral.

[mrjhb3]

I have the problem; I have accidentaly changes the root password in phpmyadmin. Now I get error 1845 acess denied for user ...... I have followed the recommendation above, But this did not fix the problem i am still locked out. I can use the admin log in like usaral.

What did you do?  Did you create a new user via mysql?  If so, did you change your entries in config.inc.php?

JB

[Rosey]

All I did is change password for root

[mrjhb3]

All I did is change password for root

I'm not sure I can be of much help.  If you changed the root password, then you have to change the info that is/was being used in config.inc.php for phpmyadmin.

You may also need to search these forums on phpmyadmin and root password.  IIRC it was highly stressed not to change it via phpmyadmin.  I think you will find instructions on how to reset the root password via SME so that other things won't break.  It's been a while, but I think that is correct.

That is why I create another user that has the rights to mysql and use it.

Sorry, I can't help more.

JB