MySQL is original Based on the doscommand line logon operation instance (graphic description), mysqlfont

MySQL is original Based on the doscommand line logon operation instance (graphic description), mysqlfont

This document describes how to log on to MySQL using the doscommand line. We will share this with you for your reference. The details are as follows:

Common MySQL command line logon statements are as follows:
Copy codeThe Code is as follows: mysql-h localhost-u root-p123456

Where:

-H indicates the server address, which can be omitted. The default value is the local server.
-U indicates the login user. (required) It can be written together with the user name, for example,-uroot.
-P indicates the Database Password, Which is required. However, do not enter the password here (Note: there must be no space between-p and the password in the command line)

Therefore, the preceding statements can be written in the following forms:

Mysql-u root-p123456mysql-uroot-p123456mysql-u root-pmysql-uroot-p

Shows the effect after Logon:

Run the following SQL statement:

Here we show you how to enter the database emcs72 and print the data table of the database.

For more MySQL commands and applications, refer to the previous MySql Command instance summary article.

I hope this article will help you design your MySQL database.

Articles you may be interested in:

• Doscommand line window mysql Chinese display garbled Problem Solution
• Solve the technical notes that PHP cannot connect to MySQL under the doscommand line
• How to log on to MYSQL using the doscommand in Windows
• How to change the mysql password under dos or wamp
• Simple sorting of MySQL Log operation commands
• Detailed instructions on MySQL cache query and clearing commands
• Summary of MySQL backup tool mysqldump's basic usage commands