MySQL Decompression version configuration step detailed tutorial

1. Unzip MySQL to D packing directory
2. Copy the My-default.ini under the decompression path and modify the name to My.ini
3. The contents of the My.ini are as follows

         

[Client]
Default-character-set=utf8

[mysqld]
#skip-name-resolve
Character_set_server=utf8
#character_set_client =utf8
collation-server=utf8_general_ci
init_connect= ' SET NAMES UTF8 '
Span style= "Background-color: #ff6600" > max_connections=1000

[Mysqld]
Basedir=e:\mysql
Datadir=e:\mysql\data
port=3306

Sql_mode=no_engine_substitution,strict_trans_tables
Skip-grant-tables

• Basedir: Is the above MySQL decompression path
• DataDir: Subsequent initialization and other data will be saved in this directory, the file directory under the new Data folder
• Run the Windows command line as an administrator
• Go to MySQL's Unpacked bin directory
• Execute MySQL--initialize--user=mysql--console
• Run command: mysqld--install [install MySQL service]
• If there is already---execute mysqld--remove
• Reinstall the MySQL service, run the command mysqld--install
• Command line Input mysql-u root-p, error description: Error 1045 (28000)
• Add a line in the My.ini file after [mysqld] Skip-grant-tables
• At this point, turn off the MySQL service and restart
• net stop MySQL
• net start MySQL
• No need to enter a password, enter directly
• Select MySQL database: Execute use MySQL
• Perform an update operation on table User: Update user set authentication_string = ' root ' where user= ' root '
• The operation was successful. Quit MySQL
• Restart MySQL Service

MySQL Decompression version configuration step detailed tutorial