Hi Jude, I think what you want to know is described very nicely in the MySQL documentation. look for GRANT and REVOKE.
There are also two reports on devshed which I believe are an excellent source. There is really nothing to add. Print them off read them carefully on your way home and tomorrrow you will be 2 steps further. http://www.devshed.com/Server_Side/MySQL/Access/page1.html http://www.devshed.com/Server_Side/MySQL/Grant_Tables/page1.html http://www.devshed.com/Server_Side/MySQL/Administration/page1.html They also offer printer friendly formats. I hope you dont think ... hmm just another document ;-). They are really worth the time. Best regards Nils Valentin Tokyo/Japan 2003年 6月 7日 土曜日 00:20、jude dashiell さんは書きました: > I got mysql working for root and got a password for mysql set by root as > well. I got into the tutorial and managed to populate the pet table with > the load command and the insert command. The my.cnf file only has > user=dashielljt in it and I'd like to know how to arrange things so that > users can access their own databases and test from their own accounts > rather than just using root. If I try anything from a user account I get > error 2002 and I thought I had set that up properly earlier too. It might > even be better to allow anonymous access on this system since this is a > home system and doesn't function as a server computer. -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]