List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 21 2002 1:34pm
Subject:Re: Privileges and Access Control
View as plain text  
You seem to havew a leading space in your newuser account.

Juri Nysschen wrote:

>I have a problem with privileges on MySql NT 3.23.52. I hope that someone
>can provide me with a solution.
>If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
>another db (CUSTOMDB) in the system, that user can't login nor can they
>access the CUSTOMDB. The error reported is: "you have no access to database
>CUSTOMDB". Yet, according to the documentation, this user setup is valid.
>The Sql Statements are:
>GRANT USAGE  on *.* to newuser identified by password 'mypassword'
>GRANT ALL on CUSTOMDB to newuser
>SHOW GRANTS for newuser
>GRANT USAGE ON *.* TO ' newuser'@'%'
>The purpose of this user setup is to prevent access to the mysql.user table,
>should the login be compromised.
>Juri Nysschen
>The Digital Message Network (Pty) Ltd
>Tel. +27.(0)11.4750300
>Fax. +27.(0)11.4056300
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread117727@stripped>
>To unsubscribe, e-mail
> <>
>Trouble unsubscribing? Try:

Privileges and Access ControlJuri Nysschen21 Aug
  • Re: Privileges and Access ControlGerald Clark21 Aug