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

This article mainly introduces how the mysql service should be installed and configured. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone's reference. Let's work with the author to understand how to install and configure the mysql service.

First, make sure that your computer has the mysql service installed:

Method 1: "start" menu-run-cmd open a command window, enter "services.msc", press "enter key" to see if there is MySQL, if so, prove that your computer has installed mysql service, if not, you need to install mysql service before connecting to the database.

Method 2: directly open the command, enter mysql to view, if the version information appears, it is proved that it has been installed, otherwise it is not.

Mysql service installation and configuration:

1. Download mysql service

Official website address: https://dev.mysql.com/downloads/mysql/5.6.html#downloads

2. After downloading, extract it. For example, I downloaded mysql-5.6.38-winx64, and the directory structure is as follows:

3. Copy the my-default.ini file and rename it to my.ini. Then open the my.ini file with a text editor and add two lines under [mysqld]:

Basedir = mysql decompress directory path

Datadir = mysql extract directory\ data

For example, my configuration is as follows:

4. Add environment variables. Computer right-click Properties-Advanced system Settings-Environment variables

System variable-New

Variable name: MYSQL_HOME

Variable value: mysql path (for example: F:\ mysql\ mysql-5.6.38-winx64)

Then find the system variable path and add% MYSQL_HOME%\ bin to the value of the path variable

5. Then open a command window to the specified directory: cd F:\ mysql\ mysql-5.6.38-winx64\ bin

Enter the command mysqld-install installation service

If service successfully installed appears, it proves that the installation is successful.

6. Start the service command: net start mysql

After the mysql service is successfully installed, the database management software is installed. Here I provide Navicat for MySQL installation tutorial https://blog.51cto.com/13082457/2351247, friends in need can follow.

After reading the above about how to install and configure mysql services, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information section.

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.