How to grant remote access to a single MySQL database
When it comes to granting someone (e.g. to a friend or a website developer) an access to MySQL databases, several concerns arise.
Granting full access to the hosting account in order to modify one database is neither comfortable, nor secure.
This article will guide you how to grant a remote access to a single MySQL database that is located on our shared server *without revealing full hosting account access*.
To set up this kind of access, follow the steps below:
1. Log in to your cPanel account.
2. Go to section Software/Services > Softaculous
3. Use the search bar on your left to find the script you need - phpMyAdmin.
Click on it and switch to the tab Install to proceed
4. Choose Protocol stands for the kind of protocol you would like to use. If you do not have an SSL certificate installed, please select http:// or http://www. If you have it, go with an encrypted connection - https:// or https://www.
Choose Domain field allows you to install phpMyAdmin for one of the addon domains you might have in the cPanel account.
Mind that it does not matter with domain the phpMyAdmin installation is associated with - one will still be able to access any of the existing databases.
In Directory field stands for the directory phpMyAdmin is going to be installed in. You can change it to any folder for your convenience.
Note, if it is left empty, phpMyAdmin will be installed in the domain web root directory.
Database Host is for the place where your databases are stored. By default, it is ‘localhost’.
Once ready, click on Install.
5. Go ahead and access the installation URL in the browser.
You will be prompted with the phpMyAdmin login window, where you need to enter database username and password.
NOTE: database user should be added to the database in question first through MySQL Databases section in your cPanel.
This is it!
Need any help? Contact our HelpDesk