Detailed MySQL decompression configuration steps, mysql decompression steps

Detailed MySQL decompression configuration steps, mysql decompression steps

1. Mysql-5.7.14-winx64 \ bin configuration to Path
2. Copy the my-default.ini in the extract path and change the name to my. ini
3. Add the following in my. ini:

[mysqld]basedir=C:\\software\Mysql\mysql-5.7.14-winx64datadir=C:\\software\Mysql\mysql-5.7.14-winx64\dataport=3306

• Basedir: the decompression path of mysql.
• Datadir: data such as subsequent initialization will be stored in this directory, and a new data folder will be created under this directory.
• Run windows command line as an administrator
• Enter the mysql decompress bin directory
• Run mysql -- initialize -- user = mysql -- console
• Run the command: mysqld -- install [install mysql Service]
• If Yes --- execute mysqld -- remove
• Reinstall the mysql service and run the command mysqld -- install
• Enter mysql-u root-p in the command line. error 1045 (28000)
• In the my. ini file, add skip-grant-tables to the last line after [mysqld ].
• Close the mysql service and restart it.
• Net stop mysql
• Net start mysql
• Enter directly without a password
• Select mysql database: Execute use mysql
• Update table user: update user set authentication_string = 'root' where user = 'root'
• Operation successful. Exit mysql
• Restart mysql Service

The above is a detailed tutorial on MySQL decompression configuration steps. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!