Shulou(Shulou.com)06/01 Report--

one。 Download, I take 8.0 as an example

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

two。 Extract to a directory, for example: D:/mysql/mysql-8.0.13-winx64

Third, 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

Create a 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 unzipped the installation package basedir = D:/mysql/mysql-8.0.13-winx64# set the data storage directory of the mysql database datadir = D:/mysql/mysql-8.0.13-winx64/data# set the port number port = 330 maximum number of connections max_connections = 20 times the number of connections allowed to fail. This is to prevent someone from trying to attack the database system max_connect_errors=20 from the host.

Register mysql as a Windows system service

1. Use the permission of the plumber to open CMD (pay attention to the rights of administrator), and enter the decompressed directory of mysql in CMD

2. Run the service installation command

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

When the installation is successful, it will prompt you to install successfully.

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

Go to 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

Change the password of the root account

The default password for the root account is empty when the installation is completed. At this time, you can change the password to the specified password. Such as: 123456

Open the database: mysql-uroot-p (prompt Enter password, enter directly, default password is empty)

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

Summary

The above is the detailed explanation of the installation-free version of MYSQL8.0.13 configuration tutorial introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.