Here are some commands to add a new user. Do this from the MySQL prompt:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.tablename
-> TO username@localhost
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON samedatabasename.tablename
-> TO sameusername@hostname
-> IDENTIFIED BY 'samepassword';
Of course, you can modify the SELECT, INSERT, UPDATE, etc. to whatever you
want the permissions to be. Also, you can use wildcards in place of
hostname, db, and table incase you want to give global access.
Well, this is how I do it at least. I think it's right? :)
---
[EMAIL PROTECTED]
http://www.hatesville.com
On Wed, 12 Feb 2003, Elby Vaz wrote:
> Hello friends!
>
> How do I create a new user on MySQL? I want to create the respective
> password too.
>
> Thanks,
> e.
>
>
>
>
>
>
>
> _________________________________________________________________
> MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
