phpMyAdmin says "No databases" -- WRONG! 1

[bluecrush]

Hey all,

I've been trying to track down an answer to this for a couple of days now without success. I'm hoping someone here can point me in the right direction.

I have a website hosted by netINS.net which has MySQL but no database admin interface. So, I checked with them to make sure it was okay if I installed phpMyAdmin...no problem, they said.

So I unzipped the package (ver. 2.9.1.1) and ftp'ed everything up to my website under phpMyAdmin. After some tweaking of the config.inc.php file, I was able to connect to their MySQL server (ver. 4.0.27-standard) .

However, in the left bar where it should show the database I know I have (db1_mydomain_com) it says "No databases" . So, I try to recreate the database that should already exist and I get the error that states "Database already exists" - no kidding .

So, obviously, phpMyAdmin can figure out that the database exists, so why can't it display in the left column? Any thoughts? I'd like to be able to select the database and view/edit it! How do I get my database(s) to show up in the left column??????

I contacted my hosting company to ask them and they said

We cannot find an issue on the server side at this moment, and were able to connect to the mysql database using the command line.

Not helpful.


Any help would be greatly appreciated!



P.S. Here's my config.inc.php file:

<?php


$cfg['blowfish_secret'] = 'my_super_secret_string';

/* 
 * Servers configuration
 */
$i = 0;

/* 
 * First server
 */
$i++;

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'mysql.myhostedserver.com';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['PmaAbsoluteUri'] = '[URL unfurl="true"]http://www.mydomain.com/phpMyAdmin/';[/URL]

/* 
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '/tmp/';
$cfg['SaveDir'] = '/tmp/';

?>

 

[bluecrush]

UPDATE:

I downloaded and installed MySQL Administrator. As with phpMyAdmin I'm still unable to view my databases, but now I get an error message that says "Access denied: Must have SHOW DATABASES privilege to perform this action" or something to that effect.

Am I correct in assuming that this is a privilege that my hoster is going to have to give me? It appears that the privilege is/can be restricted by DB so I don't see any security issues with me being able to see/access other people's db's...correct?

 

[jpadie]

typically in hosted configurations, i specify my username and password in the config file (i note that you're using cookie auth which i dont think will work). phpmyadmin will then give you access to those databases to which you are entitled given the grant tables on the host server.

 

[bluecrush]

Ah...interesting...

So, would that be these 2 lines...

$cfgServers[1]["user"] = 'my_user_id'; 
$cfgServers[1]["password"] = 'my_super_secret_password';

...in the config.inc.php file?

Thanks for your reply!

 

[jpadie]

yup!

 

[bluecrush]

Okay...gave it a shot and got this message:

#1045 - Access denied for user: 'root@web.mywebserver.com' (Using password: NO)

I got the same message using the "stduser" and "stdpass" properties.

I then tried the "controluser" and "controlpass" properties and got:

#1045 - Access denied for user: 'myuserid@web.mywebserver.com' (Using password: YES)

Am I missing something?

 

[jpadie]

it may be that you have not got permissions with those usernames and pwds etc. could they be just root@%? i.e. no domain suffix? it sounds like this is not a php question anyway. you might get a much faster answer in the mysql forum!

 

[bluecrush]

Alrighty, thanks for your time. I thought it was a PMA config issue but, like you say, it looks more and more like a MySQL issue. I'll move this question to the MySQL forum.