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

Mysql archive file

Go to the mysql official website to download the https://dev.mysql.com/downloads/mysql/ download installation package

For the corresponding system and version number, download the windows64 bit zip package here

Unzipped package installation

1. Unzip the zip package to the specified directory and install it on any system disk. I am used to installing it under D disk. The directory structure is as follows:\ Program Files\ mysql-5.7.19-winx64. So far, you have only downloaded the compressed package and unzipped it to the corresponding directory. Mysql service has not been installed yet.

Configure the my.ini file

In D:\ Program Files\ mysql-5.7.19-winx64 (pay attention to this directory and your own directory, I download here is version 5.7, if you download version 5.5, this directory is not the same) directory, create a new configuration file, file name my.ini, and then copy the following configuration code to my.ini (the path in the code should be changed to your own file storage path). As shown in the figure:

The my.ini file is as follows:

[mysql]

# set mysql client default character set

Default-character-set=utf8

[mysqld]

# set port 3306

Port = 3306

# set the installation directory of mysql

Basedir=D:\ Program Files\ mysql-5.7.19-winx64

# set the storage directory of the data in the mysql database

Datadir=D:\ Program Files\ mysql-5.7.19-winx64\ data

# maximum number of connections allowed

Max_connections=200

# the character set used by the server defaults to the 8-bit coded latin1 character set

Character-set-server=utf8

# default storage engine to be used when creating new tables

Default-storage-engine=INNODB

Install the mysql service:

Run as an administrator, right-click the cmd.exe in the start directory and run as an administrator. Be sure to run as an administrator, otherwise you will not be able to install successfully. After opening the cmd window as an administrator, change the directory to the bin directory where you extracted the files, and then type mysqld install to enter and run. As shown in the figure:

Will be prompted if the installation is successful

After the MySQL installation, there are very important steps, you need to run mysql_install_db to initialize the mysql system library in order to start normally.

When the run is complete, there will be an extra data folder under the mysql-5.7.19-winx64 folder, and a lot of data will be initialized into it. Remember that data folders must not be created manually. As shown in the figure:

Start the mysql service.

① Control Panel-"Administrative tools -" Services-"mysql-" launch.

At this point, you can use the mysql service. After installation, during the startup process, if there is a 1066 error, it is because of the my.ini configuration problem, focus on to see if the path inside the my.ini has been modified to your own path.

When you enter the command mysql-uroot-p to connect to the database, you will be prompted for a password. The password for root is empty by default. Just press enter.

Or use the management tool Navicat Premium to connect to the local library, as shown in the figure:

If a 10038 error occurs at this point, continue with the following

The 10038 error is that the remote port 3306 is not open to the public.

So the remote 3306 port opening operation is carried out below.

First connect to the server remotely, and click "start"-"Administrative tools"-"Advanced Security Windows Firewall"

In the open window, select "inbound Rule" on the left and click "New Rule" on the right to create a new inbound rule.

Select Port in Rule Type, and then next.

Select "specific local port", enter 3306, and then next.

Select allow connection, and then next.

This step is selected by default, and then the next step.

Finally, enter the name of the new inbound rule, fill in freely, and you can understand it.

After completion, you can see the new inbound rules in the list of inbound rules.

Now when you connect to the mysql remote database locally again, you will find that you have normal access. If it doesn't work, restart the service and reconnect.

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.