Bug #53664 Access Denied for User XXX / Could not retrieve user privilege information
Submitted: 14 May 2010 21:55 Modified: 15 Jun 2010 7:41
Reporter: Patrick Bertsch Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.41 OS:Linux (Ubuntu 10.04)
Assigned to: CPU Architecture:Any
Tags: mysql-admin, No Privileges

[14 May 2010 21:55] Patrick Bertsch
Description:
Tools like MySQL-Query-Browser and Emma tell me that Access is denied for this user and this Database but I'm connected with this user to the Database.

When I try to check the User Privileges with MySQL-Admin Version 1.2.12 I get the Messagebox "Could not retrieve user privilege information.", which I thought was fixed a long long time ago. I hope some can help me.

Thanks in advance,

   Patrick

#######################################################################
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1

Connection id:          43
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.41-3ubuntu12 (Ubuntu)
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 8 min 44 sec

How to repeat:
I'm not sure how I did it but I started the MySQL Server and tried to load data from a csv file into my existing database. 

A day before all worked fine.

LOAD DATA INFILE '/home/patrick/data.csv'
INTO TABLE 'test'
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n';
[15 May 2010 7:41] Valeriy Kravchuk
Please, connect as usual and get the results of:

select user(), current_user();
show grants;
[15 Jun 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".