MySQL database connection command

The commands described below are used for MySQL database connection. For your reference, if you are interested in MySQL server connection, take a look.

1. MySQL connects to the local database. The user name is "root" and the password is "123". Note: No space is allowed between "-p" and "123)

C: \> mysql-h localhost-u root-p123 note-p follows the password)
2. Connect MySQL to the remote database 192.168.0.201), Port "3306", username "root", password "123"

C: \> mysql-h 172.16.16.45-P 3306-u root-p123
3. MySQL connects to the local database. The user name is "root" and the password is hidden.

C: \> mysql-h localhost-u root-pEnter password:
4. MySQL connects to the local database. The user name is "root" and the database to be connected is "test"

C: \> mysql-h localhost-u root-p123-D testmysql> select database (); + ------------ + | database () | + ------------ + | test | + ------------ +
 

MySql connection string description

Three statuses of mysql triggers

How to use mysql triggers

Three examples of mysql triggers

Mysql Aggregate functions