All databases visible in phpMyAdmin

[Line Yoble]

Hello,

I'm far from an expert about mySql and phpMyAdmin rights (newbie would be a better name, I think).

My problem is the following :
Until now I worked only as the server admin.
Now, I have created a new reseller, then a new user under this reseller.
When I log on this user's panel and click on the 'phpMyAdmin' link, I see and can manage all databases available on my server.

So my easy question is :
What should I do to allow users to see and manage only their databases ?

Hope there is an easy answer... ;-)

Thanks.

 

[Dravu]

phpMyAdmin is a seperate application from Directadmin. When you clicked the phpMyAdmin link, it should've asked you for your username and password. If you enter the one for the admin account, it'll log in as you. You have to enter the username and password of the user's account to see what they have access to.

 

[Line Yoble]

phpMyAdmin is a seperate application from Directadmin.

Sure !
But it is installed with DirectAdmin.
And when I click the mphMyAdmin link in the user control panel, it doesn't ask for any user / password info.
May be the problem is here. If it is, how can I avoid this ?

 

[Dravu]

Are you sure you weren't in phpMyAdmin before hand and forgot to log out? I don't recall DirectAdmin being able to automatically log you into phpMyAdmin and know for a fact that it doesn't on my installation.

 

[Line Yoble]

I'm sure.
On a newly started windows, I log on directadmin as the reseller I have created.
Then go to the user panel then click on 'mySql management', then click on 'phpMyAdmin' and immediately enter the first phpMyAdmin screen (no login screen) as the root user, with all databases visible.

 

[DirectAdmin Support]

Hello,

That sounds like it's not our phpMyAdmin config at all.
Go and toast any trace of phpMyAdmin from your box in the /var/www/html directory, then reinstall it.

cd /var/www/html
rm -rf phpMyAdmin*
cd /usr/local/directadmin/custombuild
./build phpmyadmin

my guess is that some change to the config were made somewhere, and the root or da_admin users were added.

If that's not it, then another possibility is that mysqld is running with the --skip-grant-tables option. This is usually reserved for debugging and if you've lost your root mysql access. Type:

ps ax | grep mysql

to see what options are passed to mysqld and mysqld_safe.

Along the same lines, check your box for any my.cnf files that may have such a setting to skip grant tables (which is bad).
Our my.cnf files live at:
/etc/my.cnf
/usr/local/directadmin/conf/my.cnf

any other ones on your box, including /root/.my.cnf shoud be remove or renamed.

John

 

[Line Yoble]

Hello John,

I have followed your advice and reinstalled phpMyAdmin.
And it works !

Don't know what happened. My server don't seem to be hacked and as I'm a newbie in configuring mySql and phpMyAdmin, I didn't try anything which could break these softwares.

All is fine now.
Thanks a lot.

Line