Hello guys. I host some mySQL databases, which are administrated with phpMyAdmin. I want to hide a database in order not to be viewable from other mySQL users. How can I do this? Any special command? Thanx!

Get the latest version of phpMyAdmin and install it to use http authentication. This automatically restricts uses to viewing only thier own databases and those with GRANT all privs.

We also setup apache using the Alias directive to auto redirect the domains to phpMyAdmin -- which we install in a centralized location, eg. /home/phpMyAdmin

This way you only have one phpMyAdmin install and people can get to it from http://www.domain.com/phpMyAdmin

I try to install PHPMYadmin to my Raq3 (copied from http://www.solarspeed.net/freebies/RaQ34-phpMyAdmin-2.2.6.pkg) :

if I try visit www.mydomain.com/phpmyadmin
appear syntax error :

Forbidden
"You do not have permission to access the requested file on this server. "

What wrong on this? and what must I do?

I only get that message when I fail to type "index.php" at the end of mysite.com/phpadmin/
If you are not getting prompted for name and password, are you sure you install it to use http authentication?

Your httpd configuration is not set up to have index.php as a DirectoryIndex

You can add that into a .htaccess file...

Blazeman, if you are responding to me, Yes I know that. My current host doesn't allow htaccess editing (even though they say they do) I have tried everything. Thats why I am moving.
Anyway index.php does work as a default page elsewhere on my site, just not when I use phpmyadmin, which I had to install myself.

MySQL question too, I am trying to achieve exactlt what's described above, letting all users access MySQL but their tables and them only. I have CobaltWorld phpMyAdmin Release 2.2.3 installed, do I need to change anything (remove it ?) before installing the "standard" phpMyAdmin ? Any risk of conflict if not ?
Thanks,

Huck, could you illustrate how you instruct Apache for this alias and where in the conf file you put this ?
Thanks,