Topic awaiting preservation: phpMyAdmin cloak (Page 1 of 1)

phpMyAdmin listing all databases on the server?
If you have experienced this phenomenon, this will fix it.

/usr/bin/mysql_fix_privilege_tables

Make sure to login as root and run this command. After running the command stop and start MySQL. You might need to logout of your phpMyAdmin, and then log back in order to see the changes.

__________________

Kriek says '[SYSTEMWIDE_MESSAGE] PHP Meetup'
What we do is never understood; only praised and blamed

There are simpler solutions like changing the config file - I think this line does it:

quote:

---

$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible

---

___________________
Emps

FAQs: Emperor

How odd - I have been having this very problem starting just this evening.

However, I am confused - where do I do these things?

The only way I have ever accessed my DB is through phpMyAdmin, and I log on via a system dialogue box.

I have about 300 DB's listed to choose from, and only 3 of them are mine.

So...can you dumb it down perhaps? Where would I go to solve this problem, and how would I get there?

DL-44: My solution was through the config.inc.php file but I suspect that is a problem with your host and if phpMyAdmin is being provided centrally then the simplest thing is to contact them and let them know.

___________________
Emps

FAQs: Emperor

And just in case export out copies of your databases...just in case.

Yeah, I've backed things up already...was holding out on contacting them in case you guys had an answere I could implement myself.

I'll go send an email I guess =)

Thanks.

DL-44, you can run this command from any telnet/ssh client. I personally recommend using PuTTY for this type of method. You might need to match your MySQL root pass with the server pass. Hope this helps.

__________________

Kriek says '[SYSTEMWIDE_MESSAGE] PHP Meetup'
What we do is never understood; only praised and blamed