1.) the % IS a wildcard and the user bob CAN connect from any host.
2.) the string 'mypass' will be inserted into the table. but the user bob
can not logon because he doesnot know the unencrypted password of 'mypass'.
--
Zu Zhihui <[EMAIL PROTECTED]>
----- Original Message -----
From: "Matthew Darcy" <[EMAIL PROTECTED]>
To: "MySql List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 5:38 PM
Subject: adding users (reference from O'reilly book)
>
>
> I was reading about adding/managing users.
>
> I understand hat the user table holds user information.
>
> the example I will give is taken from the oreilly book.
>
>
> insert into user (host, user, password, select_priv, insert_priv,
> update_priv, delete_priv)
> values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y')
> ;
>
> questions
>
> 1.) is the % a wildcard, and if so does this mean the user bob can connect
> from any host ?
> 2.) the password function encrypts the password. If the password function
is
> missed out before the ('mypass') bit will it enter the password
un-encrypted
> ? or will it just not work ?
>
> thanks,
>
> Matt.
>
>
> ---------------------------------------------------------------------
> 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
