Closed Thread Icon

Topic awaiting preservation: phpMyAdmin cloak (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=12684" title="Pages that link to Topic awaiting preservation: phpMyAdmin cloak (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: phpMyAdmin cloak <span class="small">(Page 1 of 1)</span>\

 
Kriek
Maniac (V) Inmate

From: Florida
Insane since: Jul 2001

posted posted 04-06-2003 23:37

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

code:
/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

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 04-07-2003 00:58

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

DL-44
Maniac (V) Inmate

From: under the bed
Insane since: Feb 2000

posted posted 04-07-2003 01:32

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?



Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 04-07-2003 01:46

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

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 04-07-2003 02:12

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

DL-44
Maniac (V) Inmate

From: under the bed
Insane since: Feb 2000

posted posted 04-07-2003 02:34

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.

Kriek
Maniac (V) Inmate

From: Florida
Insane since: Jul 2001

posted posted 04-08-2003 20:01

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

« BackwardsOnwards »

Show Forum Drop Down Menu