MySQL Bugs: #5747: User Priveleges not shown at all

Bug #5747	User Priveleges not shown at all
Submitted:	25 Sep 2004 20:56	Modified:	12 Nov 2004 15:09
Reporter:	Baldie .	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.12	OS:	Windows (Windows XP SP2)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
- On Global privileges tab both assigned privileges and available are empty

- On both schema and Table/Column tabs assigned privileges is empty, available is full of choices

The mysql.db table lists the privileges correctly. They just don't show up in the administrator.

This is somewhat similar to bug #4561, #2744 both closed but I still have this problem and this is the very latest version.

How to repeat:
View user administration, select a user for example root.

- On global privileges both assigned privileges and available privileges are empty

- On schema Privileges select a user and a schema -> Assigned privileges empty, Available privileges full of choses

- Same thing on Table/Column privileges

Create a new user , go to schema tab assign a privilege, press apply changes, assigned privileges still empty.

Pictures of described situation

Attachment: mysqlbug.zip (application/zip, text), 134.53 KiB.

a select that shows that the user in the picture supplied shoule have shema priveleges visible

Attachment: privileges.html (text/html), 744 bytes.

I also have the same problem.

I'm able to set user permissions fine on a local development Win2k server.

However on a remote Linux server I have the same problem described above.. First permissions tab empty, second I can select, apply, and then it resets.

Same for me. How do you can survive to this bug without using command line?

Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://www.mysql.com/doc/en/Making_trace_files.html

Once you have generated a backtrace, please submit it to this bug
report and change the status back to 'Open'. Thank you for helping
us make our products better.

Additional info:

I suppose this is a duplicate of the 

http://bugs.mysql.com/bug.php?id=5957 and
http://bugs.mysql.com/bug.php?id=5675

Could you test the versions of your servers?
(show me the result of 'select version();')

Where I can find a debug compiled version for Windows? 
(I'm using XP SP2)

C:\Programmi\MySQL\MySQL Server 4.1\bin>mysql.exe -V
mysql.exe  Ver 14.6 Distrib 4.1.5-gamma, for Win95/Win98 (i32)

C:\Programmi\MySQL\MySQL Server 4.1\bin>mysqld --standalone
041011 14:20:01  [ERROR] Can't find messagefile 'C:\mysql\share\english\errmsg.s
ys'
041011 14:20:01  [ERROR] Aborting

C:\Programmi\MySQL\MySQL Server 4.1\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.5-gamma-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+----------------+
| version()      |
+----------------+
| 4.1.5-gamma-nt |
+----------------+
1 row in set (0.00 sec)

Seems I don't have a debuggable version installed. Only thing i can see is that I apparently have the same version installed as Francesco Ferrara.

mysqld -V
mysqld  Ver 4.1.5-gamma for Win95/Win98 on i32 (Source distribution)

mysql -V
mysql  Ver 14.6 Distrib 4.1.5-gamma, for Win95/Win98 (i32)

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".