HostSEO Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog


How to grant remote access to a single MySQL database

  • Category : MySQL Question
  • Posted on : Sep 18, 2021
  • Views : 1,189
  • By : HostSEO

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 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 into your cPanel account.
2. Go to Exclusive for Namecheap Customers section > Softaculous Apps Installer:



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, select http:// or http://www. If you have it, go with an encrypted connection - https:// or https://www.

The 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 which 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 change it to any folder for your convenience.
Note that 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 phpMyAdmin login window where you need 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.


That's it!

              
                      Need any help? Contact our HelpDesk

 

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar

SatSunMonTueWedThuFri
1234567
891011121314
15161718192021
22232425262728
2930 

Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional