MySQL is a popular relational database management system that is widely used for data storage and management on websites, businesses and individuals. In this article, we will explain how to install MySQL server on Windows operating system.
Step one: Download the MySQL installation program
First, you need to download the MySQL installation program from the MySQL official website. On the download page, select the version appropriate for your operating system. Generally speaking, we will download the Windows x86 64-bit version. Once the download is complete, double-click to run the installer.
Step 2: Install MySQL server
Before running the MySQL installer, please make sure that Microsoft Visual C 2013 Redistributable Package is installed on your computer. If it is not installed, you can download the installer from Microsoft's official website.
After double-clicking to run the MySQL installer, you will see the main interface of MySQL Installer. Here you can choose to install MySQL Workbench and MySQL Server. Select the MySQL Server option and click the "Add" button on the right.
In the pop-up installation wizard interface, you can select the version and installation directory of the MySQL server. Generally speaking, you can choose the default version and complete the installation in the default directory.
In the next interface, you need to select some configuration options for the MySQL server. These options will affect the performance and security of the MySQL server. Generally speaking, you can select the default options and click "Next".
In the next interface, you need to set the password for the MySQL server. This password will be used to log in to the MySQL administrator account. Be sure to set a strong password to keep your database secure.
In the next interface, you can choose to install the MySQL server service. This service will automatically start and stop the MySQL server. Again, you can select the default options to complete the installation.
Step 3: Start the MySQL server
After the installation is complete, you can find the MySQL service in Windows Services. You can open the service list through "Start Menu" -> "Administrative Tools" -> "Services" and then look for the "MySQL" service. If the service has started, it means that the MySQL server has been successfully installed and is running.
If the service is not started, you need to start the MySQL service manually. In the service list, right-click the "MySQL" service and select "Start".
Step 4: Configure the MySQL server
The default listening port of the MySQL server is 3306. If you need to modify the port or modify other configuration options, you can use the MySQL configuration file to make modifications. By default, this configuration file is located in "C:ProgramDataMySQLMySQL Server 5.7my.ini".
You can use any text editor to open the file and modify the options that need to be modified. After the modification is completed, please restart the MySQL service to make it take effect.
Step 5: Connect to the MySQL server
On the MySQL client, you need to use the IP address and port number of the MySQL server to connect to the MySQL server. You can use any client that is compatible with the MySQL protocol, such as MySQL Workbench, Navicat, etc.
When connecting to the MySQL server, you need to provide the username and password of the administrator account. This account has the highest authority and can perform operations such as database management, user creation, and authorization.
After completing the connection, you can start using the MySQL server for data storage and management.
Summary
Through this article we learned that installing MySQL server on Windows operating system is very simple. You only need to download the installation program, run the installation program, set configuration options, and start the MySQL service to quickly and easily set up a MySQL database environment. At the same time, when using the MySQL server, you need to pay attention to the security of the database, set strong passwords, restrict access rights and other operations to ensure the security of your data.
The above is the detailed content of Installation of mysql server. For more information, please follow other related articles on the PHP Chinese website!