mysql grant problem
scott at guppylog.com
Thu Sep 27 20:29:58 UTC 2007
Does the user have grant priv's?
On Fri, 2007-09-28 at 02:29 +0900, Tomoki Taniguchi wrote:
> i have a feisty server that i have installed apache2, php5 and mysql-server.
> I am following the instuctions
> to create a new database and grant privileges to a new mysql user.
> but i can't get the grant statement to work properly
> the grant statement i am using is this
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
> CREATE TEMPORARY TABLES, LOCK TABLES ON zendtest.* TO
> 'zendtest'@'localhost' IDENTIFIED BY 'zendtest';
> when i enter it i get
> Query OK, 0 rows affected (0.00 sec)
> in return.
> the statement created a new user but all the privileges are set to N.
> i cant get the grant statement to work as it should
> what am i doing wrong?
More information about the ubuntu-users