How to log in to %_MySQL with mysql?

This article will introduce to you the principles and methods of mysql login %_MySQL. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

1. Four principles of mysql login

1.TCP/IP

TCP/IP socket login method is a login method provided by MySQL on all service platforms, and it is also the most used method on the Internet. This method creates a login application based on the Internet on the TCP/IP login. Generally, the client is on one server and the MySQL instance is on another server. The two devices are logged in through the TCP/IP protocol.

2.Unix Socket

In Linux and Unix environments, you can use Unix domain sockets to log in. However, Unix domain sockets are not actually a network layer protocol, so they can only be used when the MySQL client and database instance are on the same server.

This method must be specified in the server configuration document: socket=/tmp/mysql.sock.

3.named pipe

Only in This method can only be used to log in under the windows environment, and the performance is 30%-50% higher than the tcp/ip method.

4.shared memory

After version 4.1, mysql also provides a shared memory login method for Windows system software. Because this login method is basically impossible to describe in detail, the advantages and disadvantages of this method are not particularly clear.

2. Starting and terminating the mysql service

Starting the MySQL service is a prerequisite for successful MySQL login. Use the following statements to start or terminate the MySQL service.

mysql> net start mysql
mysql> net stop mysql

3. Mysql login method

1.CMD command line login

When the MySQL service is opened, you can Log in to the MySQL database through the client. Under the Windows operating system, you can use cmd to log in to MySQL.

The actual operation process of logging in to the MySQL database query is as follows:

1) Click "Start" → "Windows System" → "Command Prompt".

2) Open the cmd page, enter the following command, and press Enter to execute.

cd C:\Program Files\MySQL\MySQL Server8.0\bin\,

3) Enter the following login command on the command prompt page to log in to the MySQL database. The system will prompt you to enter the password (Enter password). Enter the login password set in the configuration. After passing the authentication, you can log in to the MySQL database.

mysql -h 127.0.0.1 -u root -p

-mysql is the login command; the main parameter after

-h is the host address of the network server, enter localhost or IP address;

-u is followed by login The user name of the database, here is root;

-p is followed by the user login password.

4) After successful login, go to the MySQL original page, and the welcome slogan "Welcome to the MySQL monitor" will appear. At the same time, when the content shown in the figure appears in the dialog box and the command prompt changes to "mysql>", it means that you have successfully logged in to the MySQL server and you can carry out actual operations on the database.

2.Mysql cmd login

Generally for newly installed mysql, if you check to enable mysql lineclient during configuration, you can directly use "Start-mysql" —mysql command lineclient", after clicking to enter, you will be prompted to enter the root login password. After passing the verification, you can successfully log in to the mysql server.

3. Third-party mysql login tool

The third-party database login tool will make the entire login process more intuitive and simple, just set the relevant parameters. After logging in, a more personalized user interface will also be presented. In terms of tools, Navicat is highly recommended. The page is simple and beautiful, as shown in the picture below.

Related recommendations: "mysql tutorial"

The above is the detailed content of How to log in to %_MySQL with mysql?. For more information, please follow other related articles on the PHP Chinese website!