mysql 5.6.23 winx64Detailed installation tutorial for .zip

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

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

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

Unzip to the root directory of disk D, D:\mysql-5.6.23-winx64

2Set environment variables MYSQL_HOME and PATH

SET MYSQL_HOME=D:\mysql-5.6.23-winx64

SET PATH=%PATH%;%MYSQL_HOME%\bin

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

3Create the configuration file my.ini, the content of the file 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 Windows service, 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 the default configuration file uses my.ini under MYSQL_HOME, it can be specified. Execute the following command in cmd

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

Service installation successful.

After that, we may use net start MySQL56Start the service, net stop MySQL56Stop the service.

5.The default account root has 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

Login with password

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

The above is what the editor introduces to everyone about mysql 5.6.23 winx64.zip Installation Detailed Tutorial, hope it will be helpful to everyone. If you have any questions, please leave me a message, and the editor will reply to everyone in time. Thank you very much for your support of the Nahan tutorial website!

Statement: The content of this article is from the Internet, and the copyright belongs to the original author. The content is contributed and uploaded by Internet users spontaneously. This website does not own the copyright, has not been manually edited, and does not assume any relevant legal liability. If you find any content suspected of copyright infringement, please send an email to: notice#oldtoolbag.com (Please replace # with @ when sending an email to report violations, and provide relevant evidence. Once verified, this site will immediately delete the infringing content.)