Install Mysql 5.7.1 and mysql5.7.1

Install Mysql 5.7.1 and mysql5.7.1

Now installing MySQL is a very user-friendly task, because with the MySQL-installer tool, it can help us install MySQL throughout the process.

Next I will briefly introduce how to use it for beginners to learn:

1. First download MySQL-installer. Go to the MySQL official website and click MySQL installer in Windows under downloads:

Then perform the download operation:

We can see that there are two options: 1 and 2. The option 1 is relatively small, which requires a networked environment during the download and installation process. The option 2 is relatively large, so you do not need to connect to the Internet directly. (I downloaded 2 directly at the time, because the connection to the network did not consider that much)

2. After downloading the file, double-click it and choose no path (because it is installed in the MySQL directory under Program Files on drive C or Program Files (x86) by default ). Finally, run the MySQL installer (if you cannot find your MySQL installer, you can search by the shortcut key Windows + S ):

After opening, the interface is shown as follows: (ignore the items written on the above panel automatically. Those are the items I have installed. If they are not installed, they will be almost empty)

It is easy to understand that this installer is useful. It is used to help us install various MySQL components, such as notifier, workbench, connector-J ...... Therefore, this software is really useful.

3. Let's demonstrate how to Add a component. connector-J: click Add:

Then click filter, then click Category, and then click Filter:

Then we can find connector-J and install the plug-in (note that the second step is to move the plug-in to install it ):

After moving it over, click next to install it:

I will not talk about the installation process. Wait for the download and installation. This is the time to connect to the Internet.

Tip: now we have taken this step. We can see that this tool makes it easy for us to manage the above. download and install the above things and you don't have to go to the official website. You only need one thing, you can access these resources and download them conveniently. The disadvantage is that the path cannot be selected. By default, it is in the MySQL directory under Program Files under drive C or under Program Files (x86. You can find it by yourself.

4. After the introduction, the core installation of MySQL is the installation of MySQL Servers. Unfortunately, I have installed MySQL, so there is no basic diagram. Let's talk about it:

Find the MySQL Server in the same steps as above, and then download the MySQL Server. The key is to install the MySQL Server (when it is difficult to choose, let's take a look at it. If there are no major options, let's just force next ):

A. On the "configuration" Panel, click "Next ".

B. On page 1 (1/3) of "MySQL server configuration", set the following options:

Server configuration type. Select "computer development.

Enable TCP/IP networking. Make sure to select this check box and specify the following options:

The port number. Specify the connection port. The default value is 3306-if there is no special reason to change this setting, keep it unchanged.

Open the firewall port for network access. Select this option to add firewall exceptions for the specified port.

Advanced Configuration. Select the "show advanced options" check box to display other configuration pages to set advanced options for the server instance as needed.

Note: You must select this option to go to the panel where network options are set. You will disable the firewall on the port used by the MySQL server.

Click "Next ".

C. On page 2 (2/3) of "MySQL server configuration", set the following options:

Superuser account password.

MySQL superuser password. Enter the superuser password.

Repeat the password. Retype the superuser password.

Note: a Super User has full access permissions (such as creating, updating, and deleting users) to the MySQL database server. Remember the superuser password-this password will be required when you create a sample database later.

MySQL user account. Click "Add User" to create a user account. In the "MySQL user details" dialog box, enter the user name, database role, and password (for example! Phpuser ). Click OK ".

Click "Next ".

C. On page 3 (3/3) of "MySQL server configuration", set the following options:

Windows Service name. The name of the Windows service to be used for the MySQL server instance.

Start the MySQL server when the system starts. If the MySQL server needs to be automatically started when the system starts, leave this check box selected.

Windows Service Running identity. Select one of the following options:

Standard System Account. It is recommended in most cases.

Custom Users. In advanced cases, we recommend that you use an existing user account.

Click "Next ".

D. When the configuration is completed successfully, the information message is displayed on the "finish" panel. Click Finish ".

Note: to check whether the installation is successful, Run "Task Manager ". If MySQLd.exe is in the Process List, the database server is running.

Now, complete the installation.

It is also worth mentioning that it is best to add the bin directory under the mysql server installation directory to the environment variable so that you can directly use mysql in cmd.

5. mysql installer on my computer has these things. You can check the following:

Click the place pointed by the Red Arrow to re-set the mysql server.