First knowledge of MySQL

Always want to try MySQL, but has not been formally used it, perhaps because the first time the installation forgot the root password, toss too long left the Sequela bar, always a little afraid of. The first time today to use the command line to create a database and data table, although it is simple can no longer simple database and data table, still a little bit happy. Attach a picture to commemorate it. Ha ha.

Well, rejoice, a little summary.

The first step is to download the installation package.

First of all, to the official website (http://www.mysql.com/downloads/) download page to download the version of the installation package, generally we choose the Community edition that is MySQL Community Edition. This version of MySQL is free to use. There are also MySQL Enterprise Edition Business Edition and MySQL cluster, these two because beginners are not very well understood, for the time being not discussed.

Click the download link below the MySQL Community edition to select the MySQL Community server download after the corresponding download page, then select the appropriate platform that is the operating system.

(instead of starting the download after clicking it, skip to the page below and this is the real download page.)

Click Download to download.

At this point, the download is complete.

Step two, install.

First, double-click the MSI file you just downloaded and run it.

Click Agree Agreement, then next.

Select the type you want, and click Next when you are sure.

(When the above component is not installed, the system warns you to ignore it.) ）

Click Execute to start the installation.

At this point, the installation is complete.

The third step, configuration.

Click Next to start the configuration.

Click Execute to apply the configuration just now.

At this point, the configuration is complete.

Fourth step, use MySQL.

Connect to the server,

Application server configuration.

Finish, start using!

Click MySQL 5.7 command line client-unicode to enter a password.

Here, all the installation configuration has been completed, you can officially start using MySQL ~ ~ ~

First knowledge of MySQL