MySQL user setup

pembo13 · 11-20-2003, 04:34 PM

Hello to all,

I've been using MySQL server for awhile but after setting up a user with full access, I never did any real work via the console again. I've been using MySql Control Center to manipulate my data.

The prob is I'm clumsy with the user setups for access to the databases/tables. Can you suggest any very good GUI with emphasis on user setups for MYSQL, or to be more specific, my probs lie in seting the password flields in the user table, how do I accomplis that with direct access to the table?

Thank you.

lynger · 11-20-2003, 06:33 PM

hi pembo13

You could use mysql front for accessing your mysql.

hav a nice day

rob19 · 11-20-2003, 07:22 PM

Try SQLyog. It has a nice GUI and allows you to simply select User Management from the Tools menu, including adding, editing and permissions, etc.

pembo13 · 11-23-2003, 07:52 PM

I jsut realised that SQLyog is shareware. Any freeware wich at lest does the use management? I can do everythign else.

Thank you.

Doomhammer · 11-23-2003, 09:53 PM

the best system id phpMyAdmin (sourceforge.net)

you can create, edit, drop, save, import,export,browse, insert into your database with a web interface.

pembo13 · 11-23-2003, 10:00 PM

Thanks to all,

I think I'll be investigating SQLyog for the time. I like their easy to use User Management system.

Thanks for the responses,