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

Editor to share with you how to connect window to mysql. I hope you will learn a lot after reading this article. Let's discuss it together.

The way to connect mysql under window: first press the shortcut key [win+R] to enter the operation, and then enter cmd; and type the command [mysql-u root-p]. Enter directly and enter into MYSQL.

How to connect mysql under window:

1. Connect to the MYSQL on this machine:

1. Press the shortcut key win+R to enter the run, type cmd, and click OK

two。 Type the command mysql-u root-p, and press enter to prompt you for your password. Note that there can be spaces or no spaces before the user name, but there must be no spaces before the password, otherwise you will be asked to re-enter the password.

3. 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 110.110.110.110, the user name is root, and the password is 123. Type the following command: mysql-h210.110.110.110-u root-p 123; (note: there is no space between u and root, and so are the others.)

3. Exit MYSQL command: exit (enter)

After reading this article, I believe you have a certain understanding of the method of connecting window to mysql, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.