Installation and configuration of MySQL database under Windows

for the software connection database, from a very early interest to understand, previously because of limited strength, think access is quite convenient, there is no other high-level database to toss. Recently, because the company to build a database, the task assigned to their own head, so only the hard scalp started to start MySQL. As for why not oralce or SQL Server, the reason is simply to see someone say that MySQL is easiest to use ...

The following to write MySQL database Installation and configuration, this is actually a lot of online, and the process is relatively more stupid, I do is only a summary of the next.

OK, first download MySQL, go to the official website to my internet connection is very egg pain, is I direct Baidu "MySQL", and then download from the Baidu Software Center (of course, if your network under the first Officer network is OK, or the official website under the most reliable), as shown:

After the end is directly double-click the installation program, wait a moment will pop up the following dialog box:

Because I just want to build MySQL server, some of the other tools do not need to install, so choose Custom, and then click Next, the following dialog box appears:

Expand MySQL Servers, then expand MySQL server, then expand MySQL server 5.6, see there are X64 and X86 two MySQL versions, on-line check the next, the general view is that if the computer is 64-bit, it is recommended to install X64, So I chose the X64, click on the screen on the right arrow between the two boxes, as shown:

After the thing is very simple, basically to point to the next, in order to clear, or step by step, in the above interface click Next after entering the following interface:

I do not know what is the reason, I can directly click on the desktop in the "MySQL Server 5.6.21" To change the installation path, but not on the notebook, the program is installed directly by default in the "C:\Program Files\mysql" under the route, Of course, the back can be changed, but it seems to be more troublesome, so still ignore it, the default is the default, after the need to change Baidu Google what, I can also add to the useful.

Click Execute, the program will be installed automatically, as shown in:

After the installation is complete we need to do some configuration to the server, two consecutive clicks next to the following interface:

This interface is used to set the network port and so on, as a beginner, or not to change, so directly click Next, to the following interface:

Enter the password, then directly click Next two times to reach the following interface:

Here is the configuration for MySQL, click on execute to execute the line. After the completion of the installation program, MySQL database server is installed, and the server will be running in the background each time you boot, as long as you do not turn it off, the program can be connected to the server operation inside the database.

Since MySQL is installed, it is inconvenient to use the command line to manage the database without borrowing other tools, so it is recommended that you manage the databases using GUI software. I recommend the use of Navicat for MySQL, feel more than the installation package inside the GUI software to be easy to use, can Baidu to download, I also uploaded (because often to download things, so the uploaded resources have been made into 10 points. )。

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

Click the "Connect" button,

After the end is directly double-click the installation program, the following screen popup:

You can connect to the database by filling in the connection name and the password that you just set at the time of installation, as follows:

If connected, it also proves that the installation and configuration of the server have been completed. This article is basically here, the following is the design of database tables and so on a variety of things operation.

Installation and configuration of MySQL database under Windows