How to open mysql console using CMD

CMD method to open the mysql console: first right-click "Computer" and click "Advanced System Settings"; then select "Environment Variables", find "path", and click Edit; then press "win D" to switch to the desktop , find the installation directory of mysql, copy its address; finally use English semicolons to separate the previous contents of path.

##More related free learning recommendations: mysql tutorial(Video)

CMD method to open mysql console:

First step: Right click "Computer" , select properties, and click "Advanced System Settings", as shown in the figure below:

Step 2: In the advanced system settings, select "Environment Variable", as shown in the figure below:

Step 3: Find "path" in the environment variable system variable, click Edit, as shown in the figure below Display:

Step 4: Press "win D" to switch to the desktop, find the installation directory of mysql, and copy its address, as shown in the figure below :

Step 5: Copy the installation directory address of mysql to path, separate the previous content of path with English semicolons, and then keep clicking Confirm, as shown in the figure below:

Step 6: Enter "mysql -uroot -p123456" in cmd, root is the mysql username, 123456 is the password, you can see that you can open it directly, as shown in the following figure:

The above is the detailed content of How to open mysql console using CMD. For more information, please follow other related articles on the PHP Chinese website!