How to install your own phpMyAdmin and manage databases

If you have problems using the default phpMyAdmin in your cPanel, you can install your own phpMyAdmin and access it using your domain name by following these steps:

  1. Download latest version of phpMyAdmin from the official link: Download
  2. Upload it inside your public_html folder either through FileManager (recommended, since we’ll have to access FileManager in the next step) or using FTP client
  3. You can now find the zip file inside public_html directory. Select the file and then click on Extract
  4. At the time of writing this post, the latest available version of phpMyAdmin is 4.7.5, so the extracted folder name is phpMyAdmin-4.7.5-all-languages. Rename it to phpMyAdmin for ease of usage.
  5. You should now be able to access phpMyAdmin using the primary domain on the account / phpMyAdmin. For exmaple, errorlog.in/phpMyAdmin/
  6. Login with your database username and password
  7. phpMyAdmin

    cPusername is yur cPanel username and dbusername is your database username. Do not confuse the database name with the database username. An example for complete database username would be cpaneluser_wordpress

You should now have access to all the databases the user you logged in with has access to. The only downside of this method is that you cannot view all the databases from this page. A workaround would be to create a new database user and add it to all the databases. This way, you can manage all the databases with the user

/ / /

Report (Please include link to post while reporting)

Leave a Reply

Your email address will not be published. Required fields are marked *