RE: adding users (reference from O'reilly book)

2002-01-08 Thread Matthew Darcy
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 th

RE: adding users (reference from O'reilly book)

2002-01-08 Thread Simon Green
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 ne

Re: adding users (reference from O'reilly book)

2002-01-08 Thread Zu Zhihui
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