- Unzip MySQL to D packing directory
- Copy the My-default.ini under the decompression path and modify the name to My.ini
- 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