phpMyAdmin is certainly a handy tool you can use to view and manage your databases. You can use it to perform almost all needed operations like import, export or SQL queries on the database.
You can also perform a variety of admin tasks such as adding or deleting databases, adding or deleting users, running SQL queries, editing data within tables, and of course, exporting databases and restoring databases.
Fortunately phpMyAdmin comes pre-installed with many web hosting accounts and can be accessed through cPanel interface. But there is a way to reach phpMyAdmin directly without logging into your hosting cPanel.
In this tutorial, I’m going to walk you through the steps in installing PhpMyAdmin on your web hosting account.
Installing phpMyAdmin on your domain
If you want to access phpMyAdmin directly from your domain, you need to install phpMyAdmin on your hosting account. This method will create you a link to access phpmyadmin directly from your domain (e.g. http://www.yourdomainname.com/PhpMyAdmin).
Follow the steps below to install phpMyAdmin on your domain:
Step 1:
Download the latest stable version of the PhpMyAdmin software here.
Step 2:
Extract the archive file on your computer.
Step 3:
Rename the extracted phpMyAdmin-4.2.5-english folder to phpMyAdmin so that your URL will look something like this: http://www.yourdomainname.com/PhpMyAdmin.
Step 4:
Upload the phpMyAdmin folder into public_html directory of your hosting account and place it at the exact location where you would like to access the software. For example, if you want to access it from http://www.yourdomainname.com/PhpMyAdmin you should place the content of the extracted directory straight under the public_html/PhpMyAdmin folder of your hosting account.
Note: To upload files to your web server, you can either use FTP client like FileZilla or use the File Manager interface provided in your hosting cPanel.
You should now be able to access phpMyAdmin directly from your domain.
Step 5:
Visit http://yourdomainname.com/phpMyAdmin in your web browser. (Replace www.yourdomainname.com with your actual domain name.) You will be prompted to enter your cPanel user name and password.
Once you have entered your credentials, it should take you straight to phpMyAdmin interface.
Another way: Direct link/URL to access phpMyAdmin without installing software
If you’re on shared hosting server, you should be able to access it by visiting the following link in your browser:
Make sure you substitute yourdomainname.com with your actual domain name.
You will be prompted to enter your login credentials.You can login to phpMyAdmin with the same credentials you use for cPanel. Once entered it should take you straight to phpMyAdmin interface.