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: email@example.com .
- The style of publishing articles varies from column to column, and they are all self-contained. Please correct me for deficiencies.
Keywords in this article: MySQL, database, version 5.6, Windows system, installation and configuration/
- MySQL 5.6 interface installation-Windows (video at the end)
- 1. Introduction to MySQL
- 2. version selection
- 3. download address
- 4. installation steps
- 1. Run as administrator
- 2. Select installation components
- 3. Missing environment installation
- 4. MySQL component installation
- 5. Initial configuration
- 6. Type configuration
- 7. Port configuration
- 8. Set password
- 9. Database service configuration
- 10. Application configuration
- 11. Installation is complete
- 5. use test
- 5. direct video
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.
- 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.
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.
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 .
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.
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...
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...
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
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.
Choose a custom installation, so you can clearly know which components you have installed, and you can ignore unnecessary 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
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.
Click the Execute button to start installing the MySQL component.
After the installation is complete, the interface is as follows:
At this point, the database has been installed and it is time to perform initial 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
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.
Set a password for the highest authority user (root) of the database, enter it twice and confirm it.
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).
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!
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.
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
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 .
- 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:
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
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!