MySQL database server logon practices

This article mainly tells you about the actual operation steps for logging on to the MySQL database server, and what issues are worth your attention, if you are interested in the actual operations, you can click the following article.

To log on to MySQL (the best combination with PHP), switch to the bin directory of MySQL (the best combination with PHP) under dos and perform the following operations:

Syntax format: MySQL (the best combination with PHP)-h host_name-u user_name-p password local-h and host_name can save)

My Experience:

C: program filesMySQL (the best combination with PHP) MySQL (the best combination with PHP) server 4.1bin> MySQL (the best combination with PHP)-u root-p

Enter password :******

First Enter the user name and password login requirements plus-p), press Enter, and then "Enter password:" appears, then Enter the password and press Enter, so that you can

Log on to MySQL (the best combination with PHP). Otherwise, the logon fails.

After successful login, the following information is displayed:

 
 

  
  
Welcome to the MySQL (the best combination with PHP) monitor. Commands end with; or g.
  
  
Your MySQL (best combination with PHP) connection id is 1 to server version: 4.1.10-nt
  
  
Type 'help; 'or 'H' for help. Type 'C' to clear the buffer.
  
  
MySQL (the best combination with PHP)>
 
 

Mark "MySQL database>". When you see the top cell on the far left of the window, you can enter the command to perform the operation.

MySQL (best combination with PHP)> s view version information

MySQL (the best combination with PHP)> q or MySQL (the best combination with PHP)> quit exit MySQL (the best combination with PHP) Database Server

MySQL (the best combination with PHP)> h or MySQL (the best combination with PHP)> help to view other MySQL database server commands)

The above content is an introduction to MySQL Database Server login. I hope you will get some benefits.