In WAMP, after mysql is installed with the default empty password WAMP, the mysql password is blank. How can I modify it? In fact, it is very simple. Just run a few commands. Next I will perform the operations step by step. First, open the mysql console through WAMP. Prompt to enter the password. Because it is empty, press Enter. Enter "usemysql"
In WAMP, after mysql is installed with the default empty password WAMP, the mysql password is blank. How can I modify it? In fact, it is very simple. Just run a few commands. Next I will perform the operations step by step. First, open the mysql console through WAMP. Prompt to enter the password. Because it is empty, press Enter. Enter "use mysql"
Modify the default empty mysql password in WAMP
After WAMP is installed, the mysql password is empty. How can I modify it? In fact, it is very simple. Just run a few commands. Next I will perform the operations step by step.
First, open the mysql console through WAMP.
Prompt to enter the password. Because it is empty, press Enter.
Then enter"Use mysql", Which means to use the mysql Database and prompt" Database changed.
Then enter the SQL statement"Update user set password = PASSWORD ('hooray') whereuser = 'root ';", Note that the semicolon at the end of the SQL statement should not be less, and the prompt is OK.
Enter"Flush privileges;", If you do not enter this, the password change operation will not take effect.
Then enter"Quit.
To modify the phpmyadmin configuration.
To X: \ wamp \ apps \ phpmyadmin2.11.6 \ config. inc. open the PHP file and find $ cfg ['servers'] [$ I] ['Password'] = ''. Enter the modified password in the quotation marks.
You can directly change the root password in phpMyAdmin. However, you must modify the root password used to connect to the mysql database in the phpmyAdmin configuration file, because it is empty by default, this step is required. Otherwise, phpmyadmin cannot connect to the mysql database management interface. Please note !!!!