How to access PhpMyAdmin without cPanel password?

Access your database without cPanel password.

 

Step.1) Create a mysql database and a mysql user

  • Log into your cPanel
  • Click the MySQL Database Wizard under the Databases heading
  • Next to New Database enter a name for your database and click Next Step
  • Next to Username enter a username.
  • Enter a password next to Password, enter it again for Password (Again) and then click Create User
  • On the next page, you'll assign privileges for the user to the database. Check the box next to All Privileges and then click Next Step.

Step.2) Download phyMyAdmin Latest version and upload under 'www' root or 'public_html' directory

http://www.phpmyadmin.net/home_page/downloads.php
  • Download the stable release phpMyAdmin-4.0.8-english.tar.gz
  • Upload the downloaded tar file (ex: phpMyAdmin-4.0.8-english.tar.gz) into public_html folder of the shared account and then extract it. Rename the folder so that you can call the phpmyadmin control panel with that name.
If your phpmyadmin download folder is named phpMyAdmin-4.0.8-english then your url will be

http://yourdomain.com/phpMyAdmin-4.2.5-english
 
So rename to something you find easy to use. I will go with the name phpmyadmin for now and thus my url will be

http://yourdomain.com/phpMyAdmin
 

Step.3) Access the phpMyAdmin panel

http://yourdomain.com/phpMyAdmin
 
Login to phpMyAdmin with your database username and password.

This feature is useful for those using shared hosting.

Thats it. Thank you.

ITS Team

Post a Comment

0 Comments

Close Menu