Teach you how to install and configure the MySQL 5.7.19 database on a win10 system

About the database this thing, there may be a lot of small partners have not contacted, here briefly, the database is the data structure to organize, store, manage the warehouse, it can efficiently store and manage data, use and wide, such as Web site development, software application development and other fields, Our common database has access, SQL Server, Mysql, Oracle, and so on, today is also the United States network small to introduce you to the Mysql database, because more than 80% of the Web site using a combination of php+mysql, want to learn web site development, Do not understand the MySQL database is not justified Oh!

First download the latest version of MySQL database installation package, official website: https://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community-5.7.19.0.msi

When the download is complete, double-click the installation package to start the installation, as shown in

Tick "I Accept License Terms" in front of the tick to agree to the agreement, and then click "Next" Next,

This step selects the installation type, we select "Server only", continue to click "Next",

Click "Execute" to start the installation,

After the installation is complete, the status will display "completed", as shown, continue with "Next",

This step is the product configuration, click "Next" to enter the configuration, such as,

This step is maintained, "Standalone MySQL server/classic mysql Replication", continue "Next",

This step configures the server configuration type and network, at the "Config type" can choose development machine, you can also choose Server only, we keep the default development machine, the following is the network communication, The default TCP/IP protocol, 3306 port, "open Firewall port for network access", to access the open firewall port for networks, continue "Next",

This step sets the account role, the default is the root user, the highest-privileged database administrator account, we set a password to it, continue "Next",

Next is the configuration of the Windows service interface, the above default, of course, if you do not need to boot, you can "start the MySQL at System startup" before the tick off, continue to "Next",

This step is the plugin and extension interface, keep the default, continue "Next",

This step is to make the application configuration effective interface, directly click on "Execute",

OK, the application is in effect set, click "Finish",

Here again to the product configuration interface, we directly click "Next",

In this step, we are prompted to install the configuration, click "Finish".

After the installation and configuration is complete, we need to verify that MySQL is working properly.

We click on the Windows10 Start menu, find MySQL, expand, click "MySQL 5.7 CommandLine Client" to open the MySQL command Line window, as shown in

Enter the root user password that you just set after "Enter password", and enter it to count into the database.

Re-enter the command line show databases; Enter, note that there is a semicolon after the command ";", do not forget oh.

If displayed as shown, our installation is successful.

Well, today's MySQL installation tutorial is complete, follow-up we will continue to launch Php+mysql Station tutorial, please pay attention to Oh!

This article starts with: teach you to install, configure MySQL 5.7.19 database on win10 system

Original address: http://www.yishimei.cn/network/694.html

Teach you how to install and configure the MySQL 5.7.19 database on a win10 system