WampServer

I have installed WAMP 1.6.0 and I am having trouble setting the root password. I have tried the following solution posted by Tom:

1) Edit php.ini and populate 'mysql.default_password' with a password.
2) Open the MySQL console, for the 'Enter the password' prompt just hit enter.
Then execute:

SET PASSWORD FOR root@localhost=PASSWORD('whatever');
EXIT;

Replace 'whatever' with your password.

3) Edit C:\wamp\phpmyadmin\config.inc.php.

Enter the password in the '$cfg['Servers'][$i]['password']' field.

4) Restart everything.

HOWEVER, when i excute instruction (2) i get the following error:

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax"

can anyone help?????]

Many thanks

i just changed it in phpmyadmin it works and causes no errors. if you need further help just e-mail me.

Hi,
If go detail, it's a little long, but actually all you should do is make the change in 2 places:
* Set password in privilleges in phpMyAdmin.
* Set password in config.inc.php as you already did.
Hope this helps,
yfastud

Hi,

By the way, if you'd like to set the permission to access your PHPmyadmin and SQLitemanager, follows the tips below, which is credited to Joshua.

1. open httpd.conf

2. find the lines
# Controls who can get stuff from this server.
#
Order allow,deny
Allow from all
</Directory>

3. after the </directory> line above add the following:

<Directory "C:/Internet/wamp/www/phpmyadmin">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

<Directory "C:/Internet/wamp/www/sqlitemanager">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

4. change location of the directories as your might be different from "C:/Internet/wamp/www/phpmyadmin"

Also in Alias folder (/wamp/Apache2/conf/alias), replace these lines in phpmyadmin.conf and splitemanager.conf:

Order allow,deny
Allow from all

By these lines:

Order deny,allow
Deny from all
Allow from 127.0.0.1

Note: For some reason, I had to restart my system more than 1 time to see the effective.

Testing: From wamp icon in system tray, select Localhost, you can access phpmyadmin or sqlitemanager or even Alias easily. Now in the browser, type your domain name or ip address, when you try to access phpmyadmin or sqlitemanager, you will get the Forbidden page that states you don't have the permission.

Hope this helps,

yfastud