MySQL5.6.31 winx64.zip installation tutorial, mysql5.6winx64.zip
#1. Download
#
#2. decompress the package to the local machine to modify the necessary configuration my *. ini
#3. mysql install
Start the cmdcd mysql directory/bin in admin mode
Execute the installation: mysqld-install
Start mysql service: net start mysql
Disable mysql service: net stop mysql
#4. mysql encoding configuration <decompressed MySQL-5.6.31-winx64 encoding configuration>
There is an INI file starting with "my-" already written under the root directory, such as: my-default.ini. Copy one copy, change the file name to my. ini, and add the following content:
[Mysqld] # set character set to utf8loose-default-character-set = utf8character-set-server = utf8basedir = Your mysql path datadir = Your mysql path/data [client] # set client character set default-character-set = utf8
PS: [client ].
#5. Change the Root password
1. Use mysql-u username-p to specify the root user to log on to MySQL. Enter the password and press Enter.
2. Modify the MySQL root User password. Format: mysql> set password for username @ localhost = password ('new password ');
Example: mysql> set password for root @ localhost = password ('shapolang ');
In the preceding example, the User root Password is changed to shapolang;
Log on again and enter the new password shapolang;
The above is a detailed tutorial on MySQL5.6.31 winx64.zip installation and configuration. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!