WampServer
Apache, PHP, MySQL
on Windows
mysql password and phpmyadmin
Posted by:
jevans
(---.cpe.net.cable.rogers.com)
Date: July 16, 2012 02:12PM
Me again!
I was doing some MYSQL tutorials in which I was using command line sql. I changed my MYSQL password and now PHPMYADMIN does not work... #1045 error re access denied.
Would someone please point me to the config/ini file I need to update to get PHPMYADMIN up and runninig again?
Thanks
jevans
I was doing some MYSQL tutorials in which I was using command line sql. I changed my MYSQL password and now PHPMYADMIN does not work... #1045 error re access denied.
Would someone please point me to the config/ini file I need to update to get PHPMYADMIN up and runninig again?
Thanks
jevans
Re: mysql password and phpmyadmin
Posted by:
RiggsFolly
(---.ppp.as43234.net)
Date: July 16, 2012 02:21PM
Look for
C:\wamp\apps\phpmyadmin3.x.y\config.inc.php
In there is
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Add in your password to the obvious place
Then change AllowNoPassword to false.
If you created another admin user you can also change the user[root] to something else.
C:\wamp\apps\phpmyadmin3.x.y\config.inc.php
In there is
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Add in your password to the obvious place
Then change AllowNoPassword to false.
If you created another admin user you can also change the user[root] to something else.
Sorry, only registered users may post in this forum.
