Topic: Unable to access mysql with phpmyadmin

[beast]

Hi

For some strange reason I am now unable to access mysql with phpmyadmin - do not know what I have made of changes!

I have tried to reset the password with the following sequence of commands:

cd /var/service/mysqld
sv d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
sv u .

But I am still unable to access mysql. BTW it looks to me that the above commands reset a user named mysql and not root/admin user but I may be wrong?

In any case I get the following error when I log into mysql with phpmyadmin:

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Please give me a hint 

Regards
Benny

[cactus]

Moving this topic to SME 7.x Contribs as it is more appropriate there.

[cactus]

I have tried to reset the password with the following sequence of commands:

Never start by that. First try and properly diagnose what you are doing is correct.

But I am still unable to access mysql.

How are you accessing MySQL you never showed us, it should be enough to login as root user on the SME Server shell and type just

Code: [Select]

mysqlCan you verify that that still works?

BTW it looks to me that the above commands reset a user named mysql and not root/admin user but I may be wrong?

Yes you are It uses a user mysql to execute the queries in the file, it can do so as it uses the skip-grant-tables option as to temporarily disable credential checking (a special routine to regain access when locked out).

In any case I get the following error when I log into mysql with phpmyadmin:

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Please give me a hint 

You did read and follow http://wiki.contribs.org/PHPMyAdmin#Additional_information as well as http://wiki.contribs.org/PHPMyAdmin#Bugs ?

[beast]

How are you accessing MySQL you never showed us, it should be enough to login as root user on the SME Server shell and type just

Code: [Select]

mysqlCan you verify that that still works?

Yes that works ok!

You did read and follow http://wiki.contribs.org/PHPMyAdmin#Additional_information as well as http://wiki.contribs.org/PHPMyAdmin#Bugs ?

Yes I have read it - did not give me any new information?

[cactus]

Yes that works ok!Yes I have read it - did not give me any new information?

Yes it should have, it tells you to report problems in the bugtracker and not here (it even provides you a direct link). Every time you post a message the same advice is given to you as well:

Don't report problems here - Please report bugs and potential bugs in the bug tracker