Log on to MySQL using the command line

1. Win + R-> Enter cmd to enter the command line,

2. Go to the bin directory under the MySQL installation directory) G: \ Program Files \ mysql server 5.6 \ bin

3. Enter

Mysql-u root-pyoupassword

Press enter and you will be prompted to enter the password. note that there can be spaces or spaces before the user name, but if-P is followed by the user password, there must be no space between-P and the password; otherwise, you will be asked to re-enter the password. for example, the following are valid logon attempts: (account: Root Password: 123456)
Mysql-u root-P
Mysql-uroot-P
Mysql-uroot-p123456

-P cannot be followed by a space. If the root password of the new database is not set, it is null. You can skip it directly when entering the password.