MySQL-Error: 1044, access denied, but all privileges
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.
Subject
Written By
Posted
MySQL-Error: 1044, access denied, but all privileges
March 18, 2006 05:58PM
September 29, 2007 01:28AM
September 04, 2008 06:35PM
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.