Install and configure MySQL Databases in Windows

Install and configure MySQL Databases in Windows
Butler has long been interested in connecting software to the database and wants to know about it. In the past, because of its limited strength, he felt that ACCESS was quite convenient and he did not go over other advanced databases. Recently, because the company wants to set up a database and allocate tasks to itself, it can only start to launch MySQL. As to why oracle or SQL server is not used, it is only because it is said that MySQL is the easiest to use...

Let's write about the installation and configuration of the MySQL database. In fact, there are a lot on the Internet, and the process is relatively dumb. I just want to summarize it.

OK. First, download MySQL and go to the official website. It is very painful for me to speed up my network ", download the package from the Baidu Software Center (of course, if your website is on the official website, it is the most reliable), as shown in:

After the installation is completed, double-click the installation program. The following dialog box is displayed:

Because I only want to build a MySQL server, some other tools do not need to be installed, so select Custom and click Next. The following dialog box is displayed:

Expand MySql Servers, then expand MySQL Server, and then expand MySql Server 5.6. Check that there are X64 and X86 MySQL versions online, the general idea is that if the computer is 64-bit, it is recommended to install X64, so I chose X64 (after practice, I found that if I chose this, the C API provided by MySQL is also 64-bit, which means that the compiling environment is X64, although most of the computers are now X64, it is better to install X86 to take care of customers who have not come and upgrade it ...), Click the right arrow between the two boxes on the screen, as shown in:

The subsequent things will be very simple. Basically, we will click Next. To be clear, let's talk about it step by step. Click Next on the interface to go to the following interface:

I don't know why. I can directly click "MySQL Server 5.6.21" on the desktop to change the installation path, but it won't work on the notebook. The program is directly installed in "C: \ Program Files \ MySQL "is below the route, of course, it can be changed later, but it seems a little more troublesome, so ignore it, the default is the default, in the future, if you need to change to Baidu or Google, I will add some useful information.

Click Execute to automatically install the program, as shown in:

After the installation is complete, we need to configure the server and click Next twice to reach the following interface:

This interface is used to set Network Ports and so on. Because it is a beginner, do not modify it. Therefore, click Next directly to reach the following interface:

Enter the password, and then click Next twice in a row to go to the following page:

Configure MySQL. Click Execute. After the installation is completed, the MySQL database server is installed, and the server runs on the background each time it is started. If you do not turn it off, the program can connect to the database in the server operation.

After MySQL is installed, if you do not use other tools, you can only use the command line to manage the database, which is inconvenient. Therefore, we recommend that you use graphic interface software to manage the database. This will get twice the result with half the effort. I recommend navicat for mysql, which is easier to use than the graphic interface software included in the installation package. You can download it from Baidu and upload it yourself (because you often need to download something, so I scored 10 points for all the uploaded resources ..).

After installing the graphic interface management software mentioned above, you can see the following interface:

Click "Connect,

After the installation is completed, double-click the installation program. The following page is displayed:

Enter the connection name and the password you just set during installation to connect to the database, as shown below:

Database tables and other operations. In addition, the default path for database creation in win8.1 is C: \ ProgramData \ MySQL Server 5.5 \ data!