How to open MySQL in Win and Linux systems

MySQL is a popular relational database management system that can provide data storage, query, update and management functions for applications. After installing MySQL, we need to start the MySQL service in order to use and manage it. This article will introduce how to open MySQL in Windows and Linux operating systems.

1. Open MySQL in the Windows system

1. Open the command line window

In the Windows operating system, we need to run the command with administrator privileges row window. Open "Start Menu" -> "Windows System" -> "Command Prompt (Administrator)".

2. Connect to the MySQL server

Enter the following command in the command line window to connect to the MySQL server:

mysql -u root -p

Where, "-u" is the user name, "root" is the username to log in to MySQL. "-p" means requiring the user to enter a password.

3. Start the MySQL service

After connecting to the MySQL server, you can start the MySQL service. Enter the following command in the command line window:

net start mysql

This command will start the MySQL service on the Windows system.

2. Open MySQL in the Linux system

1. Connect to the Linux system

In the Linux system, we need to use the command line or SSH to connect to Linux server. Enter the following command in the command line window to connect to the Linux server:

ssh username@ip_address

where "username" is the username of the Linux server, and "ip_address" is the IP address of the Linux server.

2. Switch to root user

In Linux system, we need to use root user permissions to start the MySQL service. Switch to the root user and enter the following command:

su -

Enter the password of the root user.

3. Start the MySQL service

After switching to the root user, enter the following command to start the MySQL service:

service mysqld start

This command will start in the Linux system MySQL service.

3. Open the MySQL service in the MySQL configuration file

In addition to the above methods, we can also open the MySQL service by editing the MySQL configuration file. As shown below:

1. Open the MySQL configuration file

In Windows systems, the MySQL configuration file is located at "C:\Program Files\MySQL\MySQL Server 5.7\my. cnf"; in Linux systems, the MySQL configuration file is located in "/etc/my.cnf". Open the file using a text editor.

2. Find the following line

In the MySQL configuration file, find the following line:

#skip-networking

If there is a "#" sign in front of the line, then its deleted.

3. Save the file

After saving the MySQL configuration file, restart the MySQL service to apply the changes.

Summary

This article introduces three methods to start the MySQL service in Windows and Linux operating systems. You can choose the appropriate method based on your needs. No matter which method is used, we need to operate with caution to ensure the security and reliability of the MySQL service.

The above is the detailed content of How to open MySQL in Win and Linux systems. For more information, please follow other related articles on the PHP Chinese website!