Shulou(Shulou.com)06/01 Report--

Editor to share with you to solve the problem that cmd can not log on to mysql. I hope you will gain a lot after reading this article. Let's discuss it together.

Reason and solution: the system cannot find the path to mysql and needs to log in to mysql again under the bin folder under the installed mysql directory, or by configuring the installation path of mysql to the environment variable of path, you can directly enter the command to log in.

Problem description:

Enter mysql-uroot-p to show it is not an internal command

The cause of the problem:

The system can not find the path to mysql, so you need to log in to mysql in the bin folder under the installed mysql directory, or you can log in directly by configuring the installation path of mysql to the environment variable of path.

Resolution steps:

1. Copy the installation path of mysql, the bin directory

two。 Right-click my computer-> Properties-> Advanced system Settings

Make sure to save all the way, open cmd again and enter mysql-uroot-p

Problem solving:)

Ps: after configuring the environment variables, you need to reopen cmd to log in successfully.

After reading this article, I believe you have a certain understanding of solving the problem that cmd can not log on to mysql. Want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.