Generic Port Issue for wamp:
After installing wamp in windows many of a time we face a common problem like it doesn’t turn on. It just remain orange not turn into green.
- It generally happen when the desire port is engaged by any other running application (i.e skype often use port 80 or 443). In that case we need to find out the specific program and change the port number then restart wamp.
Hope that would work!
Now let’s set the mysql password:
- Click on wamp icon from system tray.
- Click MySQL > MySQL console
- Now press enter(if it is the first time there should not be any password)
- After the console is ready just type :
SET PASSWORD FOR root@localhost=PASSWORD('yourpassword');
Here ‘yourpassword’ is the sting you want to set as password.
A successful password change will result in the following message (time consumed may differ per case).
Query OK, 0 rows affected (0.03 sec) mysql>
- It’s almost done!! Now let’s restart the wamp and try your password it will take to the console.
- Now you can’t access ‘http://localhost/phpmyadmin/’ cause you just change the password but not set in ‘config.inc.php’ file. So all you need to go ‘C:\wamp\apps\phpmyadmin3.5.1’. Now open ‘config.inc.php’ file with a text editor. Scroll down and type your new password into ”.
- It’s fully done!! Now go to browser and open ‘http://localhost/phpmyadmin/’ [recommended to clear the cache and cookie of browser.]
Update MySQL password:
- The password should be renewed periodically. If the MySQL database service is running, you can update a new password as follows:
mysql> use mysql Database changed mysql> UPDATE user SET Password = PASSWORD('dba') WHERE User = 'root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0
- If you attempting to set new root password while MySQL database service is running and just plain use the “set password” command, you will encounter an error:
mysql> set password for root @localhost=PASSWORD('dba'); ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement mysql>
- You would need to first shut down the MySQL database service from WAMP menu (left-click on the desktop icon, select “MySQL”, “Service”, “Stop service”).