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
