my phpmyadmin show all dbs to all users with access to there dbs only...


i try

/scripts/updatenow
/scrripts/fixmysql


try /usr/bin/fix_mysql_t

and restart mysql many times ... every thing was running great before the cpanel update to this phpmyadmin version


php myadmin 2.6.0

mysql 3.23.56


WHM 9.9.0 cPanel 9.9.2-S8
RedHat 8.0 i686 - WHM X v3.1.0

Its pretty simple. All you need to do is download the latest copy from www.phpmyadmin.net - and then extract it, upload it all onto your website or server in a folder named phpmyadmin, edit the file named config.inc.php and then edit this line which is on line no 39

$cfg['PmaAbsoluteUri'] = '';

and put in your absolute url address to the phpmyadmin folder. for example mine is

$cfg['PmaAbsoluteUri'] = 'http://your_domain.com/phpmyadmin/';

then go to line 60 and edit this line

$cfg['blowfish_secret'] = '';

change that to

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

then go to line 69

and enter your settings. Put in your server ip, or localhost if the files are on the server you wish to use. Put in your port if you use one,but leave it blank as default.

Mine looks like this:-

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection


Then on line 75 and 77 enter your controluser and controlpass if you know what they are, if you don't know simple leave these blank. It will work just aswell without them, as they are for http secure logins.So i leave mine blank.

Then on line 82 of the confic.inc.php edit that line by doing this:

change

$cfg['Servers'][$i]['auth_type'] = 'config';

to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

leave the user and password below that as they are... mine looks like this

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

That is all you have to do now for it to work on your server. Any databases created will work, and anyone with a username and password for mysql on the server you installed this on will be able to login. I have been using this for many months and it works brilliant. When you cahgen the auth type to cookie it automatically makes sure the user enters their username and password, however make sure they have cookies enabled, and not on the high setting. Medium-high will let them login and below. If you want to use the http login type simply do the following:-

replace

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?

which is on line 82 with

$cfg['Servers'][$i]['auth_type'] = 'HTTP'; // Authentication method (config, http or cookie based)?

I recommend you use the cookie one though as it works better, alot more user friend and means you do not need your super user and password.

"Andrew Johnston"