MySQL Forums :: MySQL Administrator :: MySQL-Error: 1044, access denied, but all privileges


Advanced Search

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 jumpintodeath 03/18/2006 05:58PM
freak show continues jumpintodeath 03/19/2006 05:13PM
Re: freak show continues Bob Field 03/19/2006 05:40PM
Re: freak show continues jumpintodeath 03/21/2006 01:06PM
Re: freak show continues Bob Field 03/21/2006 01:10PM
Re: freak show continues jumpintodeath 03/25/2006 06:06AM
Re: MySQL-Error: 1044, access denied, but all privileges noel del rosario 06/15/2007 12:54AM
Re: MySQL-Error: 1044, access denied, but all privileges Sunil Kumar 09/29/2007 01:28AM
Re: MySQL-Error: 1044, access denied, but all privileges Niels Caspers 01/08/2008 06:18AM
Re: MySQL-Error: 1044, access denied, but all privileges Alexander Ryan 08/23/2008 03:33AM
Re: MySQL-Error: 1044, access denied, but all privileges Michael Yarde 09/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.