How to quickly access mysql using cmd

To access the mysql database using cmd, you must first enter the mysql directory to execute the MYSQL command, the following describes how to directly execute mysql commands in cmd!

To access the mysql database using cmd, you must first enter the mysql directory to execute the MYSQL command, the following describes how to directly execute mysql commands in cmd!

Take window7 as an example. Right-click "computer"-click "properties"-click "Advanced System settings"-click "environment variables". The following figure is displayed:

<> "Environment variables" in the lower right corner ".

<> Select "PATH" and edit.

<> The variable value is the address of the mysql command directory in the installation and development environment. OK.

OK. Now the configuration is complete. After Entering cmd, you can easily use the mysql command:

Mysql-u user-p password (Press ENTER)