• Register
0 votes
68 views

Problem :

I am new to MySql. The problem started when I was unable to login to Mysql using my Mysql console. It is repeatedly asking me the password and now I am unable to remember my password. Can I change my password ? And now when I am trying to open my PhpMyAdmin I am facing below error:

#1045 - access denied for user 'root'@'localhost' (using password: no)

I have also tried to properly uninstall the WAMP and after that deleted all my related files and then reinstalled it .But it did not fix my issue. How can I fix the issue ?

8 4 2
2,300 points

1 Answer

0 votes

Solution :

It is very straight forward to fix this issue. I can tell you the simle process to fix your error. You are facing the failure to connect to phpMyAdmin. To solve your problem you just need to give your correct password to a system phpMyAdmin configuration file which is located in apps\phpMyadmin\config.ini.php Points to remember your root should already be set as the user And you need to insert your preferred password between ' ' and your issue will be fixed.

If you still face the same problems then your user name or your password need to be added to your DB. To complete this simple task you can use a command line tool and do an update as shown below :

UPDATE mysql.user SET Password=PASSWORD('mphil’ or your preferred password) WHERE User='root';

5 2 1
4,980 points

Related questions

0 votes
1 answer 1K views
1K views
Problem : I am new to NodeJS and trying to connect to mySQL through the NodeJS file, however I am facing the below error : { Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES) at Handshake.Sequence._packetToError (/home/alecxe/Node ... bar" AS second_field', function(err, results, fields) { console.log(err); console.log(results); myconnection.end(); } );
asked Dec 6, 2019 alecxe 7.5k points
0 votes
2 answers 2.5K views
2.5K views
Problem : I keep getting a below error with mysql connection through a XAMPP and I really don't know what to do: “Mysqli_real_connect(): (hy000/1045): access denied for user 'pma'@'localhost' (using password: no)” I have already reset my password from a MySql from a ... a changes to my code and to my php.ini file, but at each time it goes back to a error. Any help on this issue?
asked Jan 31 jwilliam 3.9k points
0 votes
1 answer 16 views
0 votes
1 answer 60 views