How to Connect to a Remote MySQL Database from the Command Line?

Navigating Remote MySQL Databases from the Command Line

When faced with the task of accessing a distant MySQL database from a local machine, some may encounter the frustration of experiencing a "Can't connect" error, accompanied by a numeric code. This perplexing issue can be attributed to a combination of factors.

To address this problem, a multifaceted solution is necessary. Firstly, it is essential to employ the correct syntax when constructing the command. The following format should be meticulously observed:

mysql -u {username} -p'{password}' \
-h {remote server ip or name} -P {port} \
-D {DB name}

For instance, if one were attempting to establish a connection with a remote server at "127.0.0.1" through port "3306" while targeting the database named "local," the command would resemble this:

mysql -u root -p'root' \
-h 127.0.0.1 -P 3306 \
-D local

It is imperative to adhere to the exact spacing as outlined above, as stray spaces may further exacerbate the connection issue. Upon successful execution of this command, the user will be seamlessly transported to the designated MySQL console, granting access to the targeted database.

The above is the detailed content of How to Connect to a Remote MySQL Database from the Command Line?. For more information, please follow other related articles on the PHP Chinese website!