Mysql 5.6.23 winx64.zipinstallation tutorial, 5.6.23winx64.zip

Mysql 5.6.23 winx64.zipinstallation tutorial, 5.6.23winx64.zip

For more information about how to install MySQL on windows, see

Http://dev.mysql.com/doc/refman/5.6/en/windows-install-archive.html

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

Unzip to the root directory of drive 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 use my computer-> properties-> advanced to set system environment variables

3. Create the configuration file my. ini. The file content is as follows. Please adjust it according to your actual situation.

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

4. Install the windows Service. The command for registering the service is as follows:

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

If the default configuration file my. ini under MYSQL_HOME is used, you do not need to specify it. Run the following command in cmd:

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

The service is successfully installed.

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

5. The default account root has no password. You can set

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

Log on with a password

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

The above is a detailed tutorial on mysql 5.6.23 winx64.zip installation. 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!