MYSQL8.0.13 free installation version configuration tutorial example detailed explanation

1. Download, I take 8.0 as an example

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

2. Unzip to a directory, for example: D:/mysql/mysql-8.0.13-winx64

3. Configure environment variables

1. Create a new variable: MYSQL_HOME

Variable value: D:/mysql/mysql-8.0.13-winx64

2. Modify the path variable

Add a record: %MYSQL_HOME%/bin

4. Create the my.ini file in the D:/mysql/mysql-8.0.13-winx64 directory

[mysqld]
# Set the installation directory of mysql, that is, the location where you unzip the installation package basedir = D:/mysql/mysql-8.0.13-winx64
# Set the storage directory of mysql database data datadir = D:/mysql/mysql-8.0.13-winx64/data
# Set the port number port = 3306
# 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 = 20

5. Register MySQL as a Windows system service

1. Use the administrator's privileges to open CMD (note the administrator's privileges), and enter the mysql decompression directory in CMD

2. Run the service installation command

mysqld install MySQL --defaults-file="%MYSQL_HOME%\my.ini"

After the installation is successful, it will prompt

Tip: If you want to remove the service, use the command: mysqld -remove

6. Enter the bin directory of mysql and enter the command to initialize the data folder (very important)

mysqld --initialize-insecure --user=mysql

7. Start the service

net start mysql

8. Modify the root account password

When the installation is just completed, the default password of the root account is empty. At this time, you can change the password to the specified password. For example: 123456

Open the database: mysql -uroot -p (When prompted to enter password, just press Enter. The default password is blank)

use mysql;
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
  FLUSH PRIVILEGES;
  exit

Summarize

The above is a detailed example of the MYSQL8.0.13 free installation version configuration tutorial introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!