Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

My website is hosted in shared hosting service and is working fine with updated news stored in MySQL database. To manage the database of website, I install phpMyAdmin in a sub-folder with the same username and password used in website.

When I login to phpMyAdmin, I don't see my database. phpMyAdmin is showing "No databases" in left pane.

Is there any thing I need to configure in phpMyAdmin?

Edited: This is the settings in config.inc.php. I can login to phpMyAdmin successfully.

$cfg['Servers'][$i]['host'] = 'hostname';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'dbuser';
$cfg['Servers'][$i]['password'] = 'password';
share|improve this question
    
How did you install phpMyAdmin? Was this via cPanel? –  CraigM Nov 15 '11 at 14:00
1  
phpmyadmin should be in your c-panel you don't need to u phpmyadmin –  Qchmqs Nov 15 '11 at 14:00
    
Usually your hosting provider provides support for phpmyadmin. Please check with them. You don't need to install separately. –  Sai Krishna Nov 15 '11 at 14:01
1  
From the top of my head: Your phpMyAdmin install probably needs to have higher privileged access to mysql than you gave with your user, maybe even db root. Usually, when you're on shared hostings, the hosting provider needs to take care of the phpMyAdmin install and give you partial access for your databases. –  markus Nov 15 '11 at 14:01
1  
Make sure you have configured the $cfg['Servers'][$i]['user'], $cfg['Servers'][$i]['password'] and $cfg['Servers'][$i]['auth_type'] in your phpMyAdmin config. Also check which permissions phpMyAdmin needs (SHOW DATABASES for example) and if they're applied to your db user. –  CodeCaster Nov 15 '11 at 14:02
show 1 more comment

migrated from stackoverflow.com Nov 15 '11 at 22:16

This question came from our site for professional and enthusiast programmers.

2 Answers

I believe you would have to setup the config file

http://wiki.phpmyadmin.net/pma/Config

share|improve this answer
    
Yes. I've already setup in config.inc.php. I will update the settings in my question. –  Thein Hla Maw Nov 15 '11 at 14:33
add comment

The problem is that db user does not have "SHOW DATABASES" privilege. That's why no database is showing in phpMyAdmin.

I have to query "USE mydatabase" in SQL tab first. After that, I can see and manage my database.

Thank you very much all.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.