I thank anyone in advance who may be able to help me iron this out.

1. I am setting up mysql on my apache server. I have had it there for a
while, but haven't really done much with getting my head round it.

2. I have figured out some shell commands, and have been able to set a root
password.

3. I have also been able to use phpMyAdmin - which I had to modify to take
into account the root password etc that is now in place.

4. I can create a database & table using the phpMyAdmin forms - and it was
relatively easy. However, when I go back to try and set up a new user who
has permission to do a range of things on this database, (using shell now),
I am given an error....

ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa'

Shell command I am using....

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON cbaa.*
    ->     TO cbaa@localhost
    ->     IDENTIFIED BY 'itsmeolord';

This seems strange to me, as I figured that root would have permission to do
anything (even if it were 'inappropriate'.

Any guidance would be appreciated.

Ian


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to