Wamp Environment Configuration-mysql Installation

1. Download and unzip the MySQL5.6.36 compressed package (by the way, rename all at once).

　　

2. Copy the My-default.ini file to the name My.ini, and then modify the following red box callout

　　

3. Install and start the service.

Run cmd as administrator (WIN10, do not have enough access to the administrator), go to the bin directory, execute the following command: Mysqld-install Displays the installation success, and then executes the net start MySQL command to start the MySQL service

　　

4. Configure Environment variables

　　

　　

5.PHP and MySQL link configuration

　　

　　

6. Modify the MySQL root account password (restart cmd)

① directly into MySQL, start without password

　　　　

② Change Password

　　　　

The operation commands are as follows:

C:\WINDOWS\system32>Mysql-u rootmysql>Show Databases;mysql>  UseMysql;mysql> Update User SetPassword= 'Lxjroot' where User='Root'; MySQL>FlushPrivileges; MySQL>Quit

③ re-login to MySQL and enter the modified password.

　　　　

7. Installation is complete.

Wamp Environment Configuration-mysql Installation