Multi-users mysql

[gyrbo]

I got my own mysql server running on a windows machine, now my question is: how can I add multi-user support? I can't just give everyone the root password! Also I don't have the resources to run a copy od the server for every user. Any ideas?

[atlas]

Read the mysql manual.... mysql.com

You need to add entries in the 'mysql' db and set the permissions for a user + db permissions.

-mk

[Woofcat]

You don't have to do anything to the mysql database manually... Just read up on the GRANT command...

http://www.mysql.com/doc/A/d/Adding_users.html

[Epgs]

wow thats very cool i never knew that thank you

[atlas]

Originally posted by Woofcat
You don't have to do anything to the mysql database manually... Just read up on the GRANT command...

http://www.mysql.com/doc/A/d/Adding_users.html



I'm well aware of that. I use grant to setup accounts and then edit the tables directly to update/change information. GRANT just updates the tables anyway.

-mk