First section of MySQL database connection

Section I.       connection to the database

1. Start the database service

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/50/C8/wKiom1RitYHxoGBgAADQf9E_mvg729.jpg "title=" 1.png " alt= "Wkiom1rityhxogbgaadqf9e_mvg729.jpg"/>

which MySQL is the name of the service, different MySQL installation methods, there will be different names. You can find the name of your MySQL service from "Computer"-- right ---" Manage "-" services " .

2. Close the database service

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/50/CA/wKiom1RitibAdd35AABEbwFSxUA640.jpg "title=" 2.png " alt= "Wkiom1ritibadd35aabebwfsxua640.jpg"/>

3. Login Database

Way One:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/50/C8/wKioL1Ritq3wnD47AACvVnlXsi8916.jpg "title=" 3.png " alt= "Wkiol1ritq3wnd47aacvvnlxsi8916.jpg"/>

use -- line to log in,host,user,password must write all, if the host does not write, the default is native.

Way two:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/50/C8/wKioL1Ritrvj4UQ3AAF1H0YEuE8895.jpg "title=" 4.png " alt= "Wkiol1ritrvj4uq3aaf1h0yeue8895.jpg"/>

this is- u, which represents shorthand

Note:- do not write the password directly after P or -P , because it is followed by a clear text password, please enter the ciphertext password after the line is changed.

4. Connect to MYSQL on the remote host

assume that the remote host IP is:110.110.110.110 Type the following command:

Mysql-h110.110.110.110-u root-p

5. quit MYSQL command

Way One:exit;

Mode two: Quit;

Note: Do not forget the end of the ";" .

This article is from "Cloud Ice xia Kiss" blog, make sure to keep this source http://sz1409024.blog.51cto.com/7007696/1575567

First section of MySQL database connection