MySQL 5.6 interface installation-Windows (video at the end)

MySQL 5.6 interface installation-Windows (video at the end)

Written in the front: The blogger is a "little pig" who has devoted himself to training after actual combat development experience. The nickname is taken from "Peng Peng" in the cartoon "The Lion King". He always treats his surroundings with an optimistic and positive attitude. thing. My technical route has gone from a Java full-stack engineer all the way to the field of big data development and data mining, and now I have a small success. I would like to share what I have gained in the past with you, and I hope it will be helpful to you on the road of learning. At the same time, the blogger also wants to build a complete technical library through this attempt. Any abnormalities, errors, and precautions related to the technical points of the article will be listed at the end, and everyone is welcome to provide materials in various ways.

  • Please criticize and point out any errors in the article and make sure to correct them in time.
  • If you have any questions you want to discuss and learn, please contact me: zhuyc@vip.163.com .
  • The style of publishing articles varies from column to column, and they are all self-contained. Please correct me for deficiencies.

MySQL 5.6 interface installation-Windows (video at the end)

Keywords in this article: MySQL, database, version 5.6, Windows system, installation and configuration/

Article Directory

1. Introduction to MySQL

MySQL is a typical relational database. It is currently one of Oracle's products and one of the current mainstream relational databases. Using MySQL can perform the most basic data storage, management, query and other operations, and can also easily form a database cluster and configure read-write separation.

The MySQL database also uses SQL (Structured Query Language) for operations. At the same time, the MySQL database itself has many built-in functions that can be used directly, and there are differences in the syntax of some operations from other databases.

2. version selection

1. Application Scenario

  • Community Edition

In the learning phase, you can use the free community version, which is also a version that small and medium-sized enterprises will choose, and can be downloaded directly from the official website. In the community version, in addition to providing the database server, it also provides related components of the community version, such as official visualization tools, MySQL clusters, and database drivers for various development languages, which can be downloaded directly as needed.

  • Enterprise Edition

MySQL Enterprise Edition provides commercial solutions. In addition to database services, related products also include: MySQL cloud service, enterprise-level data backup, enterprise-level firewall, and enterprise-level data encryption.

2. MySQL version

At present, the MySQL official website provides three major versions of support, 5.6.x, 5.7.x, and 8.0.x. As for why I jumped directly from 5.x to 8.x, I don t know, but the information revealed from the official website shows that the 8.x version has made major improvements and optimizations in terms of performance compared to the 5.7 version: 2x Faster than MySQL5.7!

But what I want to remind you here is that in the 8.0 MySQL database, some common syntax details have also been adjusted. If you plan to upgrade, you must pay attention to compatibility issues .
Compared with version 5.6, version 5.7 is mainly optimized for performance and provides richer settings. For example: Added optimizer, native JSON support, GIS extension, etc.
For interface-based installation, there is almost no difference between the installation steps of 5.6 and 5.7. This article will choose 5.6 for installation demonstration. The reason is that version 5.7 will have incompatibility issues with some old systems or machines, but the fresh systems are not There will be problems, you can safely install the higher version.

3. Digit selection

It can be seen from the development trend of the entire software and system that support for 32-bit systems and 32-bit programs will be gradually abandoned. With the reduction of hardware costs, the use of 32-bit systems will obviously only limit system performance. Everyone prefers 64-bit programs when installing. Fortunately, MySQL directly provides an interface-based installation program: MySQL Installer for Windows, we just download it directly .

3. download address

1. Official website address

1. go to the official website of MySQL database, search MySQL directly on Baidu, you can find: www.mysql.com/ , after opening, click the DOWNLOADS button directly.

2. Community Edition Download

After entering the download page, click on the MySQL Community (GPL) Downloads button to enter download interface:

select MySQL Community Community Server :

Watch Links : dev.mysql.com/downloads/m...

3. Select the version

After entering the interface, click the " Looking for previous GA versions" link:

select the version, the platform, and then click to enter the download page. Go

straight to the link : dev.mysql.com/downloads/w...

4. Download MySQL Installer

Select the mysql-install-community installation package and click the Download button.

After entering the download interface, directly click the No thanks, just start my download. link to download directly

4. installation steps

Because it is installed in an interface-based way, it is necessary to install the environment of .NET Framework 4.5 and above in the system. If the installer can be opened normally, it will prove normal.

1. Run as administrator

Choose a custom installation, so you can clearly know which components you have installed, and you can ignore unnecessary components.

2. Select installation components

  • MySQL Servers 5.6: The core component of the database service, the client program is also included by default, select x64 for installation
  • MySQL Notifier: The manager of MySQL service, it is easy to use, it is recommended to install
  • MySQL Connector/ODBC: If you need to use other database modeling tools, ODBC is usually used as the data source. From the perspective of compatibility, it is recommended to install x86
  • Samples and Examples: The beginner database can choose to install a test data set
  • MySQL Workbench: The interface management tool that comes with the official website, which can be installed if necessary. It is free software

3. Missing environment installation

If this interface appears, it means that there is no environment in the system, and clicking the Execute button will automatically download and install.

After the installation is successful, the interface is as follows, and the Execute button disappears at this time.

4. MySQL component installation

Click the Execute button to start installing the MySQL component.

After the installation is complete, the interface is as follows:

5. Initial configuration

At this point, the database has been installed and it is time to perform initial configuration.

6. Type configuration

  • Developer: Personal learning and use, it will take up less memory, we can choose this type
  • Server: Used on the server, it will take up medium memory
  • Dedicated machine: ready to be used as a dedicated database server, will use all available memory to ensure the performance of database services

7. Port configuration

Set the port to 3306. If there is no mandatory conflict, you do not need to modify it. At the same time, check the firewall to let it go.

8. Set password

Set a password for the highest authority user (root) of the database, enter it twice and confirm it.

9. Database service configuration

By default, it will be registered in the system service. You can modify the service name (default is MySQL 56). If the computer's memory is tight, you can uncheck the startup, but you need to manually open it when you need to use the database in the future (but not afraid, we have MySQL Notifier).

10. Application configuration

Perform the last step to make the configuration effective.

Congratulations, the installation and configuration of the database is now complete! Open a bottle of champagne and celebrate!

11. Installation is complete

If you checked: Samples and Examples during installation, you need to confirm with two final clicks. This is easy~

Enter the password to verify whether the database can be connected normally.

Click Next, you can see that the test data set has been successfully imported, and now we can exit satisfactorily.

5. use test

1. Start the database service

A database can be understood as a software that manages the database. It is different from other directly executed software. It exists as a system service. When you want to access the database, you must ensure that the database service is started. Because it is a Windows system, we are usually used to To manage the MySQL service in an interface-based way, the following introduces three ways to operate the MySQL database service.

  • MySQL Notifier

MySQL's own database service management tool, which runs automatically after startup, can be found in the tray in the lower right corner. The function is to control the MySQL database service. By default, if a MySQL service is installed in the system, it will automatically appear in the Notifier management list. We can view the current status of the database service, and can also start, stop, and restart operations.

  • System service list

The most conventional system service management method is to modify the status of a certain service in the system service list. First , right - click on the computer -> click Manage -> Services and Applications -> Services -> Find MySQL56 -> View or Modify service status

2. Configure environment variables

When using relational databases, interface-based management tools are usually used. The ones that support MySQL databases are: Navicat, DataGrip, Workbench, etc., which will be introduced in another article. Before that, we can use our own client program. Verify through the command line.
Because it is a way of using commands, usually for convenience, the path of the command is added to the PATH, so that we don't need to switch to the location of the executable program every time.

  • Confirm the installation location

The MySQL database will be installed in the system disk assembly: Program Files by default according to the number of bits , and the 32-bit MySQL will be installed in: Program Files (x86) .

  • Copy the path of the bin directory

The executable exe file is stored in the bin directory, and the mysql.exe client program we need is in it, so we copy the bin directory under the MySQL installation path for backup: C:\Program Files\MySQL\MySQL Server 5.6/bin .

  • Add to the system variable PATH

Right-click this computer -> Properties -> Advanced System Settings

Advanced Tab -> Search for Environment Variables

in System Variables -> Find Path -> Click Edit and

Click New -> Fill in the Bin Path -> Click OK and

click OK and exit all the way, you're done .

3. Login Verification

  • Confirm that the MySQL service has been started
  • Confirm that the environment variables are configured
  • The root user password is still kept in memory

After the above steps are completed, you can open the cmd command window and enter the command to log in to the MySQL database:

mysql -u root -p
, And enter the password. If the following interface appears, it means that the login is successful and the MySQL database service is working normally.

When connecting, the root user is specified to connect. The password used is the password specified during installation. The root user is the highest authority user in the MySQL database. We can use
show databases;
Command to view the database list:

5. direct video

Video address : www.bilibili.com/video/BV1kC... , your favorite friends must pay attention to three consecutive times~

MySQL 5.6 interface installation-Windows

Written at the end: The author strives to refine each knowledge point, and will use portal mount links for related knowledge points. The article is displayed in the form of "text + pictures + video", all of which are done by squeezing time. I hope that you can leave a comment here and give me a like, and I will support it slightly!