Gossamer Forum
Home : General : Perl Programming :

Looking for a simple mySQL-User-manager - hints?

Quote Reply
Looking for a simple mySQL-User-manager - hints?
Hi,

does anyone knows a simple script, where i could add/delete users to/from mySQL?

I'd like to have a simple script, where i could edit users, grant rights to hosts/databases etc.

I'm using phpmyadmin, but it's ugly to edit the users-database manually there ...

Thanks

Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
Uh how about MySQLMan ???

Its right infront of your nose Smile

Paul Wilson.
http://www.wiredon.net/gt/
http://www.perlmad.com/
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
MySQLMan doesn't do what Chef is requesting....

He is looking for an actual MySQL administrator emulerator program, not simply managing tables....

Regards,

Eliot Lee
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
But you can add users/db's using mysqlman can't you?

Have I misunderstood?

Paul Wilson.
http://www.wiredon.net/gt/
http://www.perlmad.com/
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
You can add them into a TABLE (to be used in a database application), but you cannot add users to access MySQL server or set their permissions.

Regards,

Eliot Lee
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
Oh I understand now.......duh.

Paul Wilson.
http://www.wiredon.net/gt/
http://www.perlmad.com/
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
In Reply To:
does anyone knows a simple script, where i could add/delete users to/from mySQL? I'd like to have a simple script, where i could edit users, grant rights to hosts/databases etc.
Try here :
http://dajoba.com/projects/mysqltool/

It will do what you require.


easy does it
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
Thanks for the link - but this one must be installed on the server - does anyone knows a script (perl/php) for this?


Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
In Reply To:
Thanks for the link - but this one must be installed on the server - does anyone knows a script (perl/php) for this?
Okay, try here :
http://www.itlab.musc.edu/...ql_users_readme.html


easy does it
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
Huh?.......The link Bearwithme provided was a perl script!

How were you planning to administer MySQL without *installing* something on the server?


Paul Wilson.
http://www.wiredon.net/gt/
http://www.perlmad.com/
Quote Reply
Re: Looking for a simple mySQL-User-manager - hints? In reply to
Bearwithme - thanks for the second one ... works!

Paul - i know but i do not have telnet access - so the first one isn't usable for me.