Problem description: After I installed MySQL (I installed MySQL 5.5), I used MySQL5.5CommandLineClient. Every time I clicked it, it always flashed through. I checked it from the Internet and found that it was a temporary solution. The displayed mysql window appears after I click MySQL5.5CommandLineClient. The temporary method is as follows: 1,
Problem description: After I installed MySQL (I installed MySQL 5.5), I used the MySQL 5.5 Command Line Client. Every time I clicked it, it always flashed through. I checked it from the Internet and found a temporary solution. The displayed MySQL window appears after I click mysql 5.5 Command Line Client. The temporary method is as follows: i,
Problem description: After I installed MySQL (I installed MySQL 5.5), I used the MySQL 5.5 Command Line Client. Every time I clicked it, it always flashed through.
I checked it from the Internet and found a temporary solution. The displayed MySQL> window appears after I click mysql 5.5 Command Line Client. The temporary solution is as follows:
I,
First, go to cmd to switch to the MySQL installation directory, then enter the bin directory, and enter the mysqld-nt -- skip-grant-tables command.
Do not close this cmd window first. open another window to log on to MySQL or directly open MySQL Command Line Client and enter the correct password!
II,
On your WINDOWS Server, first press [start], then [run], Enter cmd, and then press Enter.
Then, in the DOS form, cd to the \ MySQL Server 5.1 \ bin directory (Press enter to press the Enter key), if you do not know where the Enter key is.
Then mysql-u root-p (Press ENTER ).
Later, I found a solution that I thought was permanent, and found that my was not in the installation directory. ini. Later, I found it in my user directory, copied it, and found the MySQL Command Line Client shortcut. Right-click it and view its attributes, as shown in figure
Then, change "-u root" "-p" to "-u root-p", where root is the user name. It can also be "C: \ Program Files \ MySQL Server 5.5 \ bin \ mysql.exe ". Of course, the modification methods vary for different systems and users.