CODEWITHSUNDEEP
mysqlphpmyadminmysql-error-1045
ka_lin
ka_lin

Reputation: 9432

PhpMyAdmin password

I get the error #1045 - Access denied for user 'root'@'localhost' (using password: NO) after I accidentaly changed the password in phpmyadmin for root and 127.0.0.1 . the problem is i cannot change common.lib.php. I want to revert these changes in mysql somehow... Doe to the security of the server i cannot change much

Upvotes: 2

Views: 7558

Answers (3)

krishnazden
krishnazden

Reputation: 1177

Go to /etc/phpmyadmin folder. Open config-db.php

Here you will find your default username and password

Upvotes: 0

ace
ace

Reputation: 6825

I hope you can access the mysql server administration. As I know the root is the main user in MySQL it'll be a problem if you cannot access it. If you have a user with the same level, try to change the password there if possible.

Here's the step on how to reset the root password in MySQL

I was also dependent in phpmyadmin before until I know sqlyog and MySQL Query Browser and WorkBench. Have a look on this as an alternative on phpmyadmin.

Upvotes: 3

DIJ
DIJ

Reputation: 387

It's been a while since I've used phpMyAdmin, but if I'm not mistaken, it stores it's passwords in the mysql database it self. So, if you are able to get access to the command-line of the server, you are able to change the password using simple SQL statements.

Upvotes: 1

Related Questions