Jang wrote:
>
> Hello,
>
> I'm new in this MySQL list. I only want to know what are the default
> privileges that are required, so that a normal user (wihtout any special
> priv.) can acces only to his DB, create tables, manage, insert, ..., his
> tables.
> I have try some differents config, but never have reach the right privs.
> Please, detail me also how and where (/MySQL tables) to create this default
> user, and the strict needed privs...
> Thanks very much.
> (Sorry for my bad english, i'm french, and it's difficult to find GOOD
> french docum. about MySQL)
> Best regards
> Jang
create database user_database
grant all privileges on user_database.* to user@host identified by 'password'
See GRANT syntax in manual for more information. There should be no need
to directly modify the mysql tables.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php