Hello,
Just recently I started having problems creating and deleting databases...
When I login as the user root I get this error when I try and create or
delete a DB.
ERROR 1006: Can't create database 'tier2'. (errno: 13)
I am fully aware that the errno: 13 is a permissions denied error code.
the following are the GRANTS that have been givin to the user ROOT:
+---------------------------------------------------------------------------
------------------------------------
| Grants for root@localhost
+---------------------------------------------------------------------------
------------------------------------
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'546d9699645d04f3' WITH GRANT OPTION
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON
guestbook2k.* TO 'root'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON cbms.*
TO 'root'@'localhost' |
| GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost'
+---------------------------------------------------------------------------
------------------------------------
I have been pullin my hair out over this one....for the past 12 hours..
I even uninstalled mySQL and reinstalled it to see if that would fix the
problem..unfortunatly it did not..
Any help or advice would be greatly appreciated.. Thx Troy
---------------------------------------------------------------------
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
