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

This article mainly introduces the method of opening the mysql database from the terminal, the article is very detailed, has a certain reference value, interested friends must read it!

The method of opening the mysql database from the terminal: first, under the Windows operating system, click "start-run"; then enter cmd, and click "OK"; finally, enter the command to log in to the MySQL database [mysql-h 127.0.0.1-u root-p] in the DOS window.

How to open a mysql database from a terminal:

Under Windows operating system, start-run, open the "run" dialog box, enter cmd, and click "OK" to enter the DOS window.

DOS window enter the command to log in to the MySQL database

Mysql-h 127.0.0.1-u root-p

The command parameter description:

Mysql is a command to log in to the database

-h is followed by the IP of the server. Since the MySql server in this example is installed locally, the IP address is 127.0.0.1

-u is followed by a user name. In this example, the root user is used to log in.

-p is followed by a login password.

Enter the above command, enter the login password, and then log in to the MySQL database service. Then you can run a use databaseName statement to operate on a database.

The above is all the contents of the article "how to open the mysql database from the terminal". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.