Connect to mysql via the cmd command

admin · Posted on 6/2/2015 9:24:29 PM

To connect mysql through the cmd command window, just type mysql -uroot -p123456 in the command line. 解决办法是在环境变量的path路径下加入 C:Program FilesMySQLMySQL Server 5.6in。
As shown below:

After configuring mysql to the environment variable, enter "mysql -uroot -p123456" in the command window of cmd. As shown below:

At this point, you can connect to mysql through the cmd commanddatabase. Note that -u is followed by the username connecting to the database, without spaces. -p is followed by the connection password, and there is no space either.
The command is:mysql -uroot -p123456
If you add a semicolon after the command, the following will appear:
C:UsersAdministrator>mysql -uroot -p123456;
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
The solution is not to add semicolons.

Little scum · Posted on 6/18/2015 6:06:56 PM

learned.

[Source] Connect to mysql via the cmd command

Related Posts

Sections viewed