MySQL Password Problem
Posted by: capecodkid (208.188.90.---)
Date: March 08, 2010 05:27PM

I have a serious problem setting up the password for 'root' within MySQL. This is right after an initial setup of wamp server. I have attempted to change the password within PHPMyAdmin as well as changing the password within the MySQL console. As soon as I save the password and refresh the PHPMyAdmin webpage I receive the following error: My SQL said: #1045 – access denied four user ‘root’@’ local host’ (using password: NO)
I have made sure that the all of the environment variables have been set up properly, along with making sure that the required extensions are loaded within the PHP.INI file.
I am presently running:
Zen Cart Ver 1.3.8 Initial Install with no No Addons and installed Locally
OS - Windows 7 64-Bit, and tried VISTA virtual OS
Using Wamp 2.0
Php Ver 5.3.0
Mysql Ver. 5.1.36
Apache Ver. 2.2.11

An immediate response would be greatly appreciated.
Thanks
Rob

Options: ReplyQuote
Re: MySQL Password Problem
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: March 08, 2010 07:50PM

maybe u shud try actually adding your password from mysql to phpmyadmin


all you did was set a password for mysql


now phpmyadmin cant connect to mysql

so open

c:/wamp/apps/phpmyadmin/config.inc.php

add your password to the appropriate line and restart

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: MySQL Password Problem
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: March 08, 2010 07:50PM

phpMyAdmin needs to be configured to use the new password you setup. Go to C:/wamp/apps/phpmyadmin

Find a file called config.inc.php and find the following line
$cfg['Servers'][$i]['password'] = '';

Add your password between the quotes. Personally I prefer phpmyadmin to ask for username/password. If you wish phpmyadmin to ask for username/password simply find this line
$cfg['Servers'][$i]['auth_type'] = 'config';
And change config to http or set it to cookie

Save config.inc.php and phpmyadmin should return to function normally.

Options: ReplyQuote
Re: MySQL Password Problem
Posted by: capecodkid (208.188.90.---)
Date: March 08, 2010 08:28PM

My Goodness!!!!!!!
Steven THANK YOU!!!! I am nbew to this game and I must have aged 10 years over this.

I appreciate the quick response!

Be Blessed
Rob

Options: ReplyQuote


Sorry, only registered users may post in this forum.