Re: MySQL Privileges Question

2002-07-18 Thread Yat-Shing Tam
Hi Mihail, I have done the flushing before trying to connect and it didn't work. I try the show command and nothing unusal from what it reported. Regards, Michael - Original Message - From: <[EMAIL PROTECTED]> To: "Yat-Shing Tam" <[EMAIL PROTECTED]&

MySQL Privileges Question

2002-07-17 Thread Yat-Shing Tam
Hi fellows, I have a MySQL privileges question and hope someone can provide some input on it. I have setup a user who can access only one db, say 'DB1'. About the privileges, I set the account privilege like this: 1) In user table, this account has Host='%' User='user_name' Passw