Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the fleeting problem of MySQL X.X Command Line Client in MySQL. The content of the article is of high quality, so the editor shares it for you to do a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Fleeting problems of MySQL X.X Command Line Client in MySQL

Problem description: after I installed MySQL (I installed it is 5. 5), I used MySQL 5. 5 Command Line Client. Every click, it always flashed by.

I checked from the Internet, all are temporary solutions, can not solve the problem that after clicking MySQL 5.5 Command Line Client, the > window appears. The temporary methods are as follows:

First, enter cmd and cut into the installation directory of MySQL, then cut into the bin directory and enter the mysqld-nt-- skip-grant-tables command. Do not close this cmd window, open another window to log in to MySQL or directly click MySQL Command Line Client to enter the correct password, it will be OK! Www.2cto.com

2. On your WINDOWS, press "start", then "run", type cmd, and then enter enter.

Then in the DOS form, cd to the\ MySQL Server 5.1\ bin directory (enter, that is, press enter), if you don't know where the enter key is.

Then mysql-u root-p (enter).

Later, I groped by myself and found what I thought was a permanent solution. In the process of groping, I found that there was no my.ini in the installation directory. Later, when I found it in my own user directory, I copied it over, then found the MySQL Command Line Client shortcut, right-clicked it, and checked its properties, as shown in the following figure.

Then modify the red selected part of the image above, you can change "- u root"- p" to "- u root-p", where root is the user name, so that's fine. Or just "C:\ Program Files\ MySQL\ MySQL Server 5.5\ bin\ mysql.exe". Of course, for different systems and different users, the modification methods are different.

On how to solve the flash of MySQL X.X Command Line Client in MySQL to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.