• Register
0 votes
102 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

Please log in or register to answer this question.

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 3 views
3 views
Problem: Any ideas on what I need to solve this problem?error: 'access denied for user 'root'@'localhost' (using password: no)'
asked Apr 4 ashik 10.6k points
0 votes
1 answer 3 views
3 views
Problem: Please assist me in resolving this issue: Access denied for user 'root'@'localhost' (using password no) mysql?
asked Mar 30 tuhin1 46.7k points
0 votes
1 answer 5 views
5 views
Problem: How to deal with this one : Er_access_denied_error: access denied for user 'root'@'localhost' (using password: no)
asked Mar 14 Wafa Abu Yousef 6.1k points
0 votes
1 answer 1.7K views
1.7K 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
1 vote
1 answer 4 views
4 views
Problem: What should I do for the soloution of this problem? Wamp # 1045 - access denied for user 'root'@'localhost'
asked Mar 29 PkGuy 13.1k points
0 votes
1 answer 48 views
48 views
Problem : Any help on this issue: Mysqli_real_connect(): (hy000/1045): access denied for user 'pma'@'localhost' (using password: no) .
asked Mar 6 Wafa Abu Yousef 6.1k points
0 votes
2 answers 4.7K views
4.7K 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, 2020 jwilliam 3.9k points
0 votes
1 answer 1 view
1 view
Problem: I need someone to understand this problem and find out the solution of access denied for user 'root'@'localhost' xampp.
asked 3 days ago ashik 10.6k points
0 votes
1 answer 2 views
2 views
Problem: As I mentioned in my previous query, I'm having difficulties with my learning; I've tried searching the web but haven't been able to find adequate information; could you assist me in continuing my project?
asked Apr 1 rakib1 50.4k points
0 votes
1 answer 5 views
5 views
Problem: I'm having trouble finding a solution; could you please assist me “Access denied for user 'root'@'localhost' (using password yes) mysql”?
asked Mar 30 tuhin1 46.7k points