Changing SQL Password with WAMP
Posted by: rashmus (---.lightspeed.racnwi.sbcglobal.net)
Date: February 08, 2014 06:15PM

I used the WAMP Server 2.2 Admin utilities to change my SQL password and the SQL password changed, but now the PHPmyAdmin and Losthost selects don't work.

PHPmyAdmin, says Forbidden, You don't have permission to access/phpmyadmin/ on this server
LocalHost, Says same thing

I went to c:\wamp\bin\apache\apache2.2.22\bin\php.ini file and changed the following two fields to resolve this:
mysql.default_password = xxx
mysql.default_pw = xxx

Still doesn't work.

I also changed the c:\wamp\www\testmysql.php file changing password
$link=mysql_connect ("localhost","root","password"winking smiley;
That doesn't work either.

I would like to log this as a bug the WAMP 2.2 package as changing the SQL password should not be locking me out like this. Hope you fix it soon. In the mean time, I do need some help to get running again.

Options: ReplyQuote
Re: Changing SQL Password with WAMP
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: February 09, 2014 08:57PM

I have no idea what you mean by 'WAMP Server 2.2 Admin utilities'

But the 'Forbidden, You don't have permission to access/phpmyadmin/ on this server
LocalHost
' message is notmally fixed by checking and changing the following

Edit \wamp\alias\phpmyadmin.conf and change the Allow from as below:

<Directory "d:/wamp/apps/phpmyadmin3.5.1/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
    Order Deny,Allow
	Deny from all
	Allow from 127.0.0.1 localhost ::1
</Directory>


It would also be advisable to do the same to your httpd.conf file
Use the wampmanager menus to edit httpd.conf wampmanager -> Apache -> httpd.conf
Find this set of lines
#   onlineoffline tag - don't remove
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1
and change 'Allow from 127.0.0.1' to 'Allow from 127.0.0.1 localhost ::1'




Go back and remove these changes
I went to c:\wamp\bin\apache\apache2.2.22\bin\php.ini file and changed the following two fields to resolve this:
mysql.default_password = xxx
mysql.default_pw = xxx



If you actually changed the password on the mysql 'root' userid you will need to change this file.
Edit \wamp\apps\config.inc.php and change these 3 lines

HOWEVER Try running phpmyadmin first just in case you didnt actually make the password chane, if you did it will give a message telling you the password is wrong, then make this change.

$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
TO
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'You_new_password';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Changing SQL Password with WAMP
Posted by: rashmus (---.lightspeed.racnwi.sbcglobal.net)
Date: February 13, 2014 03:38AM

Thanks,

The 403 Forbidden Error cleared out after adjusting the Apache httpd.conf file.

Options: ReplyQuote


Sorry, only registered users may post in this forum.