How to grant a remote access to a single MySQL database

In previous article we talked about how to backup your MySQL database with phpMyAdmin. When it comes to granting someone (e.g anothe developer) an access to MySQL databases, some security issues and misunderstandings may occur. Granting full access to the hosting account in order to modify one database is neither comfortable nor secure. This article will guide you on how to grant a remote access to a single MySQL database that is located on our shared server, without revealing hosting account password.

First you need to download phpMyAdmin (PMA) package from this page. (.tar.gz extension is recommended)

phpmyadmin packages

Then you need to:

  1. Log in to your cPanel account.
  2. Select FileManager
  3. Upload phpMyAdmin archive to your /public_html/ folder, select it and extract
  4. Rename phpMyAdmin folder if necessary

cpanel

It should be possible to access phpMyAdmin at domain.tld/PMA/ link now. Please note that cPanel is case sensitive, so if your PMA folder is called “phpMyAdmin-3.4.8-english”, then “http: // yourdomain.tld /phpMyAdmin-3.4.8-english/” link should be opened.

Now, if someone tries to access your phpMyAdmin, then authentication page will appear:

phpmyadmin login form

Then Database username and password should be filled there in order to access to the single database. This information can be provided to those people who should have access to the database, but should not have access to the whole cPanel account.

phpmyadmin

Or cPanel username and password can be filled there in order to access to all databases that were created for this cPanel account.

cpanel user in phpmyadmin

It is highly recommended to follow this step-by-step guide in order to avoid any issues.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>