Set MySQL password, can't login to PHPMYADMIN, HELP!

rmb · 09-28-2009, 07:14 PM

Hi Everyone,

I am new to PHP, MySql and Apache (WAMP), busy learning all the code. I've come accross my first problem and can't seem to figure this out, and it is probably so simple and right under my nose...

I set a MySQL password and I can successfully login to MySQL, but when I try go to phpmyadmin I now get:

"Access Denied

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

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

I obviously know what is happening here, but I don't know where to go to fix this (where is the configuration exactly). I tried looking up the MySQL error #1045, but it just tells me what the error is, not how/where to fix it.

Can anybody help me here please? Thanks!

Forged · 09-29-2009, 04:47 AM

If you open up your phpmyadmin folder you should see a file called config.inc.php.
Open config.inc.php in notepad or any other text editor/html editor.

In that file you should have a line that looks like this

Code:

$cfg['Servers'][$i]['password'] = '';

Simply insert your password you set between the " '' " and save the file.

For example:

Code:

$cfg['Servers'][$i]['password'] = 'Donkey123';

rmb · 09-29-2009, 09:20 AM

Excellent! Thank You, I don't think I would have found that easily :)

Forged · 09-29-2009, 09:29 AM

Hehe, I've made the same mistake myself ;)

09-28-2009, 07:14 PM	#1 (permalink)
rmb Registered User Join Date: Jul 2008 Posts: 43 OS: Windows XP Pro Service Pack 2	Set MySQL password, can't login to PHPMYADMIN, HELP! Hi Everyone, I am new to PHP, MySql and Apache (WAMP), busy learning all the code. I've come accross my first problem and can't seem to figure this out, and it is probably so simple and right under my nose... I set a MySQL password and I can successfully login to MySQL, but when I try go to phpmyadmin I now get: "Access Denied MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server." I obviously know what is happening here, but I don't know where to go to fix this (where is the configuration exactly). I tried looking up the MySQL error #1045, but it just tells me what the error is, not how/where to fix it. Can anybody help me here please? Thanks!

09-29-2009, 04:47 AM	#2 (permalink)
Forged Registered User Join Date: Aug 2009 Location: Sweden Posts: 20 OS: Vista Home Premium, Linux (Sabayon 4.2)	Re: Set MySQL password, can't login to PHPMYADMIN, HELP! If you open up your phpmyadmin folder you should see a file called config.inc.php. Open config.inc.php in notepad or any other text editor/html editor. In that file you should have a line that looks like this Code: $cfg['Servers'][$i]['password'] = ''; Simply insert your password you set between the " '' " and save the file. For example: Code: $cfg['Servers'][$i]['password'] = 'Donkey123';

09-29-2009, 09:20 AM	#3 (permalink)
rmb Registered User Join Date: Jul 2008 Posts: 43 OS: Windows XP Pro Service Pack 2	Re: Set MySQL password, can't login to PHPMYADMIN, HELP! Excellent! Thank You, I don't think I would have found that easily :)

09-29-2009, 09:29 AM	#4 (permalink)
Forged Registered User Join Date: Aug 2009 Location: Sweden Posts: 20 OS: Vista Home Premium, Linux (Sabayon 4.2)	Re: Set MySQL password, can't login to PHPMYADMIN, HELP! Hehe, I've made the same mistake myself ;)