Detailed tutorial on installing MySQL 8.0.19 in zip version on win10

1. After downloading, unzip it to the directory you want to install

Download address: https://dev.mysql.com/downloads/mysql/

2. Add the configuration file my.ini in the installation directory

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:\DevTool\MySQL-8.0.19
# Set the storage directory of mysql database data datadir=D:\DevTool\MySQL-8.0.19\data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8mb4
[client]
# Set the default port and character set used by the mysql client to connect to the server port=3306
default-character-set=utf8mb4

You don't need to create a folder for datadir, it will be created automatically when the database is initialized.

3. Configure environment variables and add the mysql bin directory to the path

4. Initialize the database

Open a command window as administrator and execute mysqld --initialize --user=mysql --console

The red box contains the root user and password, which will be used when logging in later.

5. Install the database

• Execute mysqld -install in the command line window and Service successfully installed appears. This proves that the installation is successful!
• Start the service with net start mysql
• Use the mysql -u root -p command to log in to mysql. You need to enter the password used to initialize the database.

6. Change the root password

• Use alter user 'root'@'localhost' identified by 'password'; to modify the root password
• Where password is the password you want to use
• You can exit mysql with the exit command and log in again with the new password

7. Create a remote user and grant permissions

• Create user: create user 'username'@'%' identified by 'password';
• Grant permissions: grant all privileges on *.* to 'username'@'%' with grant option;
• Refresh privileges: flush privileges;

8. Delete the database

• net stop mysql shuts down the service,
• mysqld -remove or sc delete mysql to delete the mysql service
• Delete the mysql file directory

Summarize

The above is a detailed tutorial on how to install the zip version of MySQL8.0.19 on win10. I hope it will be helpful to everyone. Thank you very much for your support of the 123WORDPRESS.COM website!