mysql grant problem
Njoku, George O.
njokug at winthrop.edu
Thu Sep 27 17:31:57 UTC 2007
Try install phpmyadmin.
It makes all the mysql management very easy.
Cheers
George
-----Original Message-----
From: ubuntu-users-bounces at lists.ubuntu.com
[mailto:ubuntu-users-bounces at lists.ubuntu.com] On Behalf Of Tomoki
Taniguchi
Sent: Thursday, September 27, 2007 1:30 PM
To: ubuntu-users
Subject: mysql grant problem
i have a feisty server that i have installed apache2, php5 and
mysql-server.
I am following the instuctions
https://help.ubuntu.com/community/Drupal
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?
-TIA,
Tomoki
--
ubuntu-users mailing list
ubuntu-users at lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
More information about the ubuntu-users
mailing list