How To Give Remote Access To A Single MySQL Database

When it comes to granting someone access to MySQL databases then there arise several concerns.

Allowing complete access to the hosting account in order to change one database is neither easy nor safe.

This article will guide you how to give remote access to a single MySQL database that is located on our shared server without revealing complete access of hosting account.

To allow remote access of hosting account, follow the steps given below:

1. First of all Log into your cPanel account of ae hosting

2. Go to Softaculous Apps Installer option

3. Use the search bar on your left to discover the script you need i.e phpMyAdmin. Click on it and switch to the tab install to proceed:

4. Select Protocol stands for the kind of protocol you probably like to use. If you do not have an SSL certificate installed, select http:// or http://www. In case you have an SSL certificate installed then proceed with a safe connection - https:// or https://www.

The Chosen Domain field permits you to install phpMyAdmin for one of the add-on domains you might have in the cPanel account.

Keep in mind that it does not matter which ae domain the phpMyAdmin installation is associated with. One will still be able to access any of the existing databases.

The In Directory field stands for the directory phpMyAdmin is going to be installed in. You can modify it to any folder for your ease.

You need to remember that if you left it empty, by default phpMyAdmin will be installed in the domain web root directory.

Database Host is the place where your databases are stored. By default, it is localhost.

Once it is ready, click on install button:

5. Proceed further and access the installation URL in the browser

You will be shown phpMyAdmin login window where you are required to enter the database username and password:

NOTE: The database user should be added to the database in question first through the MySQL Databases section in your cPanel.

If you need further help, do not hesitate to contact Sky Host support anytime you want.