Shulou(Shulou.com)06/01 Report--

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the Oracle company.

MySQL is the most popular relational database management system. MySQL is one of the best RDBMS (Relational Database Management System, relational database management system) applications in WEB applications.

It is characterized by small size, high speed, low cost, open source code and so on.

MySQL download address: http://dev.mysql.com/downloads/installer/

Double-click to enter the installation boot interface, click Next, check the relevant information read, and click Next

Then enter the type selection interface, where there are three types: Typical (typical), Complete (complete), and Custom (custom).

It is recommended to choose "Custom" installation, so that you can customize the installation directory of MySQL, and then click "Next". Next, a custom installation interface appears.

For the sake of data security, it is not recommended to install the C directory of the MySQL system disk.

Click Next to begin the installation

After the installation is complete, the boot interface for MySQL configuration will appear. Click Next.

There is an option to boot and configure MySQL (Luanch the MySQL Instance Configuration Wizard). It is recommended to check to configure your MySQL immediately.

Click Next to enter the configuration MySQL

You can choose two configuration types: Detailed Configuration (detailed configuration) and Standard Configuration (standard configuration), select Detailed Configuration, and click Next.

Configure the MySQL server type for MySQL

You can choose three server types

Developer Machine (development machine): this option represents a typical personal desktop workstation. Assume that there are multiple desktop applications running on the machine. Configure the MySQL server to use the least system resources.

Server Machine (server): this option represents the server, and the MySQL server can run with other applications, such as FTP, email, and web servers. The MySQL server is configured to use the appropriate proportion of system resources.

Dedicated MySQL Server Machine (dedicated MySQL server): this option represents a server that runs only the MySQL service. Assume that no other applications are running. The MySQL server is configured to use all available system resources.

Here I choose Developer Machine, mainly for peacetime development needs.

Next, select the database usage.

Multifunctional Database (Multi-function Database): select this option to use both the InnoDB and MyISAM storage engines and distribute resources equally between the two engines. It is recommended that users who often use two storage engines choose this option.

Transactional Database Only (just transaction databases): this option uses both the InnoDB and MyISAM storage engines, but allocates most server resources to the InnoDB storage engine. It is recommended that users who mainly use InnoDB and only occasionally use MyISAM to choose this option.

Non-Transactional Database Only (only non-transactional databases): this option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. It is recommended that users who do not use InnoDB choose this option.

I chose Multifunctional Database.

The following is the choice of data storage location, the default.

Select the maximum number of connections allowed by mysql. The first is a maximum of 20 concurrent connections, the second is a maximum of 500concurrent connections, and the last one is custom. You can choose according to your own needs.

The following is the port for database listening. The default is 3306. If you change it to another port, you should remember the modified port when you connect to the database in the future, otherwise you cannot connect to the mysql database. It is troublesome and will not be modified here.

Use the default port of mysq: 3306.

To configure the character set of MySQL, click Next

Configure the service options for MySQL to install the MySQL server as a service. Installed as a service, the MySQL server can be started automatically when the system starts

Configure security options for MySQL

Set and remember the password of the superuser. New root password (enter password) Confirm (confirm password) is recommended

There is a check box below to select whether to allow remote machines to connect to your mysql server with root users, and check it if necessary.

Click Excute to complete the installation and open the command line window

Enter the password, enter the key

Database information

Enter, see the database information, you can operate the database here, add and change the check, not to mention the details.

Next, desktop tools operate the database without writing code.

Client tool: Navicat for MySQL

Download address of green version: http://www.cr173.com/soft/38153.html

Download address on the official website: https://www.navicat.com

After the registration is completed, open the interface, click the link, and enter the relevant information.

Connection successful, OK

So you can operate the database, you can operate manually, you can import SQL files for execution, and you can also write code, which is very convenient.

Summary

The above is the tutorial on the installation of MySQL database and the use of Navicat for MySQL introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message. The editor will reply you in time!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.