命令行远程访问mysql数据库_从命令行访问mysql远程数据库

I have a server with Rackspace. I want to access the database from my local machine command line.

I tried like:

mysql -u username -h my.application.com -ppassword

But it gives an error:

ERROR 2003 (HY000):

Can't connect to MySQL server on 'my.application.com' (10061)

What causes this error and how can I connect to the remote database?

解决方案

To directly login to a remote mysql console, use the below command:

mysql -u {username} -p'{password}' \

-h {remote server ip or name} -P {port} \

-D {DB name}

For example

mysql -u root -p'root' \

-h 127.0.0.1 -P 3306 \

-D local

no space after -p as specified in the documentation

It will take you to the mysql console directly by switching to the mentioned database.

31-07-2019 - edited syntax