How to connect to the database with mysql

Mysql method to connect to the database: 1. Execute the "net start mysql" command through computer management or through the command line to start the MySQL service; 2. In the cmd command line prompt interface, use the cd command to enter mysql In the bin directory of the installation directory; 3. Execute the "mysql -h 127.0.0.1 -u root -p" or "mysql -h localhost -u root -p" command and enter the password to log in to the database.

The operating environment of this tutorial: windows10 system, mysql8 version, Dell G3 computer.

Before operating the database, you need to connect to it.

Mysql connects to the database in two steps:

• Start the MySQL service

• Log in to the MySQL database

Let’s take a closer look.

Step 1: Start the MySQL service

The MySQL service is different from the MySQL database. The MySQL service is a series of background processes, while the MySQL database It is a series of data directories and data files. The MySQL database can only be accessed after the MySQL service is started.

There are two main ways to start and stop the MySQL service under Windows system:

• Through computer management

• Through Command line method

#1. Through computer management method

View the modification through Windows Service Manager, the steps are as follows:

Step 1): Right-click "This Computer" → "Manage" command on the desktop, as shown in the figure.

Step 2): Pop up the "Computer Management" dialog box, double-click "Services and Applications", the user can view the service status of the computer, the status of MySQL is "Running" ”, indicating that the service has been started, as shown in the figure.

As you can see in the picture, the service has been started and the startup type is automatic. If there is no "Running" word, the MySQL service is not started.

You can right-click here and select Properties to enter the "MySQL Properties" interface, as shown in the figure.

The service status can be set in the MySQL property interface. Service status can be set to Start, Stop, Pause, and Resume commands.

You can also set the startup type. In the drop-down menu of the startup type, you can choose "Automatic", "Manual" and "Disabled". The descriptions of these 3 startup types are as follows:

• Automatic: The MySQL service starts automatically, and the status can be manually changed to stop, pause, restart, etc.

• Manual: The MySQL service needs to be started manually. After starting, the service status can be changed, such as stopping, pausing, etc.

• Disabled: The MySQL service cannot be started, nor can the service status be changed.

If you need to practice the operation of the MySQL database frequently, you can set MySQL to start automatically, which can avoid manually starting the MySQL service every time. Of course, if the frequency of using the MySQL database is very low, you can consider setting the MySQL service to start manually. This can prevent the MySQL service from occupying system resources for a long time.

2. Through the command line method

You can start the MySQL service through the DOS command, click the "Start" menu, and enter "cmd" in the search box. Run as administrator and press Enter to bring up the command prompt interface. Then enter net start mysql and press Enter to start the MySQL service. The command to stop the MySQL service is net stop mysql, as shown in the figure.

Note: net start mysql57 and net stop mysql57 mysql57 in the commands is the MySQL server name, if your MySQL service If the name is DB or other name, you should enter net start DB or other name, otherwise it will prompt that the service name is invalid.

Step 2: Log in to the MySQL database

When the MySQL service is started, you can log in to the MySQL database through the client. You can use DOS commands to log in to the database under the Windows operating system.

The specific steps to log in to the MySQL database are as follows:

Step 1): Click "Start" → "Windows System" → "Command Prompt", as shown in the figure shown.

Step 2): Open the command line prompt interface, enter the command cd C:\Program Files\MySQL\MySQL Server 5.7\bin\, and press the Enter key, as shown in the figure.

Step 3): In the command prompt interface, you can connect to the MySQL database through the login command mysql -h 127.0.0.1 -u root -p.

Press the Enter key and the system will prompt you to enter the password (Enter password). Here, enter the password set in the configuration wizard. After verification is correct, you can log in to the MySQL database, as shown in the figure.

Tip: mysql is the login command, the parameter after -h is the host address of the server, here the client and the server are on the same machine, so enter localhost or IP address; -u is followed by the user name to log in to the database, in this case root; -p is followed by the user login password.

After running this command in the DOS window, the system will prompt you to enter the password. After entering the correct password, you can log in to the MySQL database.

You can add the password directly to the mysql command, which is mysql -h localhost -u root -proot. The root after -p here is the password. Pay special attention here that there is no space between -p and the password. If spaces appear, the system will not treat the following string as a password.

Step 4): After successful login, enter the MySQL initial interface. The welcome message "Welcome to the MySQL monitor" will appear, and then there are some explanatory sentences below, as shown in the figure.

These descriptive statements are introduced as follows:

• Commands end with; or\g: Explain that the command under the mysql command line is It ends with a semicolon (;) or "\g". When this terminator is encountered, the command starts to be executed.

• Your MySQL connection id is 3: id represents the number of connections to the MySQL database.

• Server version: 5. 7.29-log MySQL Community Server (GPL): Server version describes the database version later, this version is 5.7.29. Community means the version is a community version.

• Type 'help;' or '\h' for help: Indicates that you can see help information by typing "help;" or "\h".

• Type '\c' to clear the current input statement: means to clear the previous command when encountering "\c".

Tip: When the description message as shown in the figure above appears in the window and the command prompt changes to "mysql>", it indicates that you have successfully logged in to the MySQL server and you can start operating the database. .

【Related recommendations: mysql video tutorial】

The above is the detailed content of How to connect to the database with mysql. For more information, please follow other related articles on the PHP Chinese website!