Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Mike on March 03, 2003, 05:25:58 AM

Title: PHPMyAdmin and purge users
Post by: Mike on March 03, 2003, 05:25:58 AM

Some person told me to use phpmyadmin. In my opinion, it is some kind of destructive. Ok it was STUPID of me to click on the PURGE USERS. What the heck, it's late [03:00 PM] or early in the morning.

How kan it be fixed without reinstalling everything?

Is it possible to fix? If not, i'm dead meat.

HELP ME!!

Title: Re: PHPMyAdmin and revoke users
Post by: Mike on March 03, 2003, 06:54:08 AM

PHPMyAdmin are dangerous! No warning at all when i fiddle with the REVOKE link.

What the heck have i done with my company's production database?

I can still login with the command mysql but it seems to be emty fields the database.

Didn't find any fields in table 'columns_priv'
Didn't find any fields in table 'db'
Didn't find any fields in table 'func'
Didn't find any fields in table 'host'
Didn't find any fields in table 'tables_priv'
Didn't find any fields in table 'user'

5:00 PM

3 hours left to commit suiside :-(

Oohh No!! What have i done!!

Title: Re: PHPMyAdmin and revoke users
Post by: Andrew on March 03, 2003, 07:22:11 AM

I'm not nearly a pro at things, but with my little eperience with PHPMyAdmin and linux, it looks like your screwed. I've used PHPMyAdmin very little--done everything basically by command line. I hope some one has a solution for your problem, but as far as i can tell it looks like there is no hope--sorry

Title: Re: PHPMyAdmin and revoke users
Post by: eric on March 03, 2003, 08:11:24 AM

If this is a production database, you should at least have a backup from Friday...right?

Title: Re: PHPMyAdmin and revoke users
Post by: Dan Brown on March 03, 2003, 05:49:42 PM

You're right, it is dangerous, if you don't know what you're doing.  If you didn't know what you were doing, why were you messing with it in the first place?  In any case, I'm not sure if this will do what you need, but it might:

mysql> grant all on *.* to root@localhost identified by '' with grant option;
mysql> grant all on horde.* to horde@localhost identified by 'hordemgr';

These are the only users that I know of that your system needs in order to run properly.  If you've installed other packages, you may need to create users for them as well.

Title: Re: PHPMyAdmin and revoke users
Post by: Mike on March 04, 2003, 12:11:09 AM

Thank you all for the help!

It works now, and thank you Dan for the final solution.

It seems stupid of me to messing with such dangerous things. In a matter of fact, it was an accident.

Touchpad are also dangerous. It is almoust impossible to move the pointer without click on something.

That's what happening in PHPMyadmin when moving the pointer. Click on the link PURGE USERS.

By the way!

Anyone interested in a brand new Compaq Evo N800W P4 2.2 Ghz notebook without touchpad?