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

This article mainly explains "how to log in to MySQL in Linux system". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to log in to MySQL in the Linux system.

Format: mysql-h host address-u user name-p user password

1. Connect to the MYSQL on this machine

Generally, you can type commands directly.

Mysql-uroot-p1 prompts you to enter your password after you enter. If you have just installed MYSQL, the superuser root does not have a password, so you can enter MYSQL directly by pressing enter. The prompt for MYSQL is: mysql >

2. Connect to the MySQL on the remote host

Suppose the IP of the remote host is 10.0.0.1, the user name is root, and the password is 123. Type the following command:

Mysql-h20.0.0.1-uroot-p1231 (Note: U and root do not have to add spaces, and so do others)

3. Exit the MySQL command

Exit (enter) ng1949/article/details/70634758

At this point, I believe you have a deeper understanding of "how to log in to MySQL in the Linux system". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.