mysql5.6.23winx64.zip installation details

This article mainly introduces mysql 5.6.23 winx64.zip installation detailed tutorial , very good, with reference value. Friends who need it can refer to

For detailed documentation on installing the compressed package version of MySQL on windows, please refer to

1. Unzip mysql-5.6.23-winx64. zip to any directory

Extract to the root directory of drive d, D:\mysql-5.6.23-winx64

2. Set the environment variables MYSQL_HOME and PATH

SET MYSQL_HOME=D:\mysql-5.6.23-winx64
SET PATH=%PATH%;%MYSQL_HOME%\bin

Please set the system environment variables through My Computer-〉Properties-〉Advanced

3. Create the configuration filemy.ini, the file content is as follows , please adjust according to the actual situation

[mysqld]
loose-default-character-set = utf8 
basedir = D:/mysql-5.6.23-winx64
datadir = D:/mysql-5.6.23-winx64/data
port = 13306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
character_set_server = utf8
[client]  
loose-default-character-set = utf8

4. Install the windows service, and the command to register the service is as follows

C:\> "D:\mysql-5.6.23-winx64\bin\mysqld" --install MySQL --defaults-file=C:\my-opts.cnf

If you use the default configuration file my.ini under MYSQL_HOME, you do not need to specify it. Execute the following command in cmd

C:\Users\tanw>"D:\mysql-5.6.23-winx64\bin\mysqld" --install MySQL56
Service successfully installed.

The service is successfully installed.

After that, we may use net start MySQL56 to start the service and net stop MySQL56 to stop the service.

5. The default account is root. If there is no password, you can set one

mysql -u root -P 13306
mysql>UPDATE mysql.user SET Password = password ( 'root' ) WHERE User = 'root' ;
mysql>FLUSH  PRIVILEGES;
mysql>exit

Log in with password

mysql -u root -p -P 13306
Enter Password: ****
mysql>

The above is the detailed content of mysql5.6.23winx64.zip installation details. For more information, please follow other related articles on the PHP Chinese website!