• Register
0 votes
80 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 1.4K views
1.4K 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
1 answer 79 views
0 votes
1 answer 23 views
0 votes
1 answer 71 views
0 votes
1 answer 41 views
41 views
Problem: I had installed MySQL on my linux server sometimes back now I forgot the password so I tried to change it using the ways I found online. What I did was as shown below: /etc/init.d/mysql stop mysqld_safe --skip-grant-tables & mysql --user root mysql SELECT * ... it still shows me below errors  "Access denied for user 'root'@'localhost' (using password: Yes)". How to fix above MYSql error?
asked Jul 14, 2020 Raphael Pacheco 4.9k points
1 vote
1 answer 487 views
487 views
Problem : I am naïve to mysql. Currently I am continuously facing below error. “Mysql access denied for user 'root'@'localhost' (using password yes)”. I have recently started using mySQL Workbench and after doing research on above error I found that my root's ... of no us. I want to get my root access back as soon as possible. Can somebody help me in getting my root access back?
asked Apr 7, 2020 morrisBson 3.2k points
0 votes
2 answers 3.6K views
3.6K 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
2 answers 761 views
761 views
Problem : Whenever I want to open a mysql in my windows cmd by simply typing mysql. I am facing below error : “ERROR 1045 (28000): Access denied for user ODBC@localhost (using password: NO)” After that by looking at similar queries I somehow got the ... password=root ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:NO) Any pointers will be the great help.
asked Dec 18, 2019 alecxe 7.5k points
0 votes
1 answer 591 views
591 views
Problem : I have recently installed Ubuntu 16.04 and installed web server on it. Everything works well, but I am unable to access database. Even if I create new user and grant all privileges, I can't create database In PHP I am getting below error: SQLSTATE[HY000] [1698] ... ", $this->myname, $this->mypass, self::$mysettings);     } catch (PDOException $e) {         echo $e->getMessage();     } }
asked Jan 17, 2020 jwilliam 3.9k points
0 votes
1 answer 350 views
350 views
Problem : I am currently using the Mac OS Yosemite and Laravel 5.0. I am new to Laravel 5.0. In the local environment whenever I run the below command php artisan migrate I always encounter below error : “Access denied for user 'homestead'@'localhost' (using password: YES)” I am unable to fix above error. Any clue to fix the above error?
asked Feb 13, 2020 mphil 2.3k points