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!