Skip to content
TrySitePrice

MySQL: Connect From an Other System / Computer

Best/Tutorial

To connect to a MySQL database from a remote system or computer, you'll need to perform the following steps:

  1. Ensure that the remote system has access to the database server: The database server must be configured to allow connections from the remote system. The server's firewall and security rules must also be configured to allow connections from the remote system.
  2. Obtain the necessary connection information: You'll need the database server's hostname or IP address, port number, and the credentials for a user with sufficient privileges to access the database.
  3. Connect using the MySQL client: You can use the MySQL client command line tool to connect to the database. On the remote system, open a terminal window and enter the following command, replacing the placeholders with your specific connection information:

    mysql -u -p -h -P

  4. Enter the password for the user when prompted: The password is not displayed as you type it.
  5. Once connected, you can issue SQL commands to the database.
rnNote: Make sure the MySQL server is properly configured to listen for incoming connections, otherwise you won't be able to connect from a remote system. You can also use a GUI-based client such as MySQL Workbench to connect to the database.