How to use cmd to enter mysql

This article will explain in detail how to use cmd to enter mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Specific steps:

1. Open [start] "[run] enter [cmd] after clicking [OK] the black window of the CMD command appears, which is what we call the CMD command line, or use the shortcut key Windows (a key with a Windows logo on the keyboard) + R enter cmd and enter enter.

2. Enter the command in the CMD command window and press enter to enter the MySQL.

Mysql-hlocalhost-uroot-p

(note that "- h", "- u", "- p" cannot be omitted here) enter the mysql database, where "- h" represents the server name, localhost indicates the local; "- u" is the database user name, root is the default MySQL user name, and "- p" is the password.

If you set a password, you can enter it directly after-p, such as-p888888. The user does not set a password. When Enter password is displayed, enter directly.

Note that if your MySQL is not installed on disk C, use the DOS command to enter the bin directory under the installation directory of MySQL. The method is as follows: enter G: enter G disk), enter cd G:\ phpstudy\ mysql\ bin to enter the bin directory of MySQL, then enter mysql-hlocalhost-uroot-p and press enter.

On how to use cmd to enter mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.