MySQL Forums
Forum List  »  MySQL Administrator

MySQL-Error: 1044, access denied, but all privileges
Posted by: jumpintodeath
Date: March 18, 2006 05:58PM

mysql> STATUS;
--------------------
mysql Ver 14.12 Distrib 5.0.18, for Win32 (ia32)

Connection id: 28
Current database: mysql
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.18
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 11 min 17 sec

Threads: 1 Questions: 279 Slow queries: 0 Opens: 0 Flush tables: 1 Open tab
les: 4 Queries per second avg: 0.412
-----



mysql> SHOW GRANTS FOR root@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '[here is the encrypted password]' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)



mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| mysql |
| phpmyadmin |
| test |
| webauth |
+--------------------+
6 rows in set (0.00 sec)



mysql> DROP DATABASE information_schema;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'



Same error occurs when sending everything but SHOW and SELECT.
Reloaded, restarted, flushed everything.

Need help, couldn't even find a folder or file, where that database is located. Have no idea as well, why it ignores the order (information > cdcol).

Anyone got an idea? Suggestions? Miracles? *ggg*



Edited 1 time(s). Last edit at 03/18/2006 06:08PM by jumpintodeath.

Options: ReplyQuote


Subject
Written By
Posted
MySQL-Error: 1044, access denied, but all privileges
March 18, 2006 05:58PM
March 19, 2006 05:13PM
March 19, 2006 05:40PM
March 21, 2006 01:06PM
March 21, 2006 01:10PM
March 25, 2006 06:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.