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