MySQL Learning Note (1)-cmd login and exit

1. Open cmd, input, enter

Mysql-uroot-p-p3306-h127. 0.0. 1

1)-U: Specifies the user name, Root is the super-privileged user.

2)-P: Enter the password, enter the password when not specified, and hide it with the * number.

3)-P: port number, MySQL default port number is 3306, the port number is not changed, this item can not be written.

4)-H: Server name, mysql default server IP address is 127.0.0.1, do not write as default.

Enter the password to log in after entering the carriage.

2. Exit, three ways to

1 Exit 2 quit  mysql > \q

MySQL Learning Note (1)-cmd login and exit