thanks for your help on this, I would like to use the grant sql command as I am using the latest version 3 of mysql, however I am find problems finding good usage guide for grants. I will update the oreilly mysql book. I need to do this with my bind and apache book too.
Matt. -----Original Message----- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:50 To: '[EMAIL PROTECTED]'; MySql List Subject: RE: adding users (reference from O'reilly book) Hi If you have a new copy of MySQL use GRANT. If you have an old copy update it. If you can not do this then.... Yes % is a wild card. Yes bob can use any host at "user" table is global. Yes you can use clear text passwords. Hope this helps. Simon PS I like using "desc tablename" PPS Get the new O'reilly book the old one is not so good! -----Original Message----- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:38 To: MySql List 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
