WEB HOSTING SUPPORT NETWORK
     
 

Enabling remote access to a MySQL database

By default, all created MySQL users are allowed to access the MySQL server locally through a script that runs on the server. In case you need to access your database using an application installed on your computer (e.g. NaviCat, MySQL Front, MySQL Control Center, or Query Browser), you need to allow remote connections for the respective MySQL user.

On our servers, remote access is enabled per MySQL user, so when you enable remote connections for a MySQL user, this MySQL user will be able to connect remotely to all databases it is associated with.

Enabling remote access for a MySQL user

To enable remote connections for a MySQL user on our servers, you need to follow these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the MySQL users tab.
  4. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. Click on the Edit (button_edit_hover.gif) button next to the MySQL user for which you would like to enable remote connections.
  6. Select the Enable option from the Remote connections section.
  7. Click on the Submit button.

Once remote connections are enabled, the MySQL user will be able to connect from remote locations (e.g. from your local computer using MySQL Control Center or MySQL Front) to all databases it is associated with.

Note: The MySQL 5 and MySQL 8 servers are separate and do not share databases or users, so if you have two users for MySQL 5 and MySQL 8 with the same name and enable remote connections for one of these users, the remote connections setting will not be changed for the other user.

MySQL settings for remote connections

You can find the MySQL host and port that you need to use in your MySQL client in the MySQL Connection Settings information box from the hosting Control Panel > MySQL Databases section.

Remote access and MySQL views

If you are using views in your MySQL databases, enabling/disabling remote connections for your master MySQL user may lead to problems with these views, due to the change of the type of access. Therefore, in case you have MySQL views in any of your databases, it is strongly recommended that you use a separate MySQL user for remote connections.