CODEWITHSUNDEEP
phpmysqlphpmyadminwamp
Samdrew Young-Moss
Samdrew Young-Moss

Reputation: 11

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

Yes, I know there are already a billion threads opened for this issue but so far, none of the solutions has worked for me. I'm having so much trouble trying to get phpmyadmin to work. My error:

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

I've tried:

The MySQL portion on wamp isn't lighting up, and when I tried starting the service I'm getting the error:

    Windows could not start the Mysql service on Local Computer.
    Error 1067: The process terminated unexpectedly.

My MySQL is version 5.6.17. Please help! I have a project due soon and this is giving me so much grief.

Upvotes: 0

Views: 3217

Answers (3)

Tarinder Singh Ghotra
Tarinder Singh Ghotra

Reputation: 1

you can use root as username and leave password field as empty. It worked for me.Hope it helps someone !!

Upvotes: 0

Isaac Bennetch
Isaac Bennetch

Reputation: 12422

As @RiggsFolly has stated, it appears you have problems with your MySQL server. Something is answering phpMyAdmin, but but the WAMP MySQL server is not running and is in an error state. The first step is to solve what's going on there. Look in the WAMP and MySQL error logs to determine why the WAMP MySQL server didn't start (it's probably because of the other MySQL server already running on port 3306).

Furthermore, it appears as if some of the troubleshooting steps you've taken have come from bad sources. For example, $cfg['Servers'][$i]['host'] refers to the hostname or IP address of the MySQL server, not the URL you use to load phpMyAdmin. 127.0.0.1 would be correct here, and the port number (which is 3306, the port MySQL is listening on, not your web server) would be set through $cfg['Servers'][$i]['port'] but again, port 8888 is the webserver port, not the MySQL server port so you shouldn't modify the port at all. You'll have to have a correct settings in config.inc.php for phpMyAdmin to connect to your MySQL server.

Upvotes: 0

RiggsFolly
RiggsFolly

Reputation: 94662

Actually what you say does not add up. You say you are getting this error

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

Which means that MYSQL is up and accepting connections.

Then you say that you get errors trying to start MYSQL???

The only possible reason for this is that you have 2 MYSQL Server instances running on this PC.

I suggest you uninstall the one that was there before you installed WAMPServer, after backing up any databases you may have created on it, so you can restore them to WAMPServers MYSQL

Also by default the MYSQL with WAMPServer comes with a single userid called root of course, and that account has NO PASSWORD.

Upvotes: 1

Related Questions