Description:
Hi there,
I have reported a bug a while ago (Bug #28140) but I do not seem to receive any news on how to solve it.
This is what I was asked to do:
[2 May 18:06] Miguel Solorzano
Thank you for the feedback. I was not able to repeat either on XP or
Vista. Could you please, stop the service service, edit the my.ini
file adding the general query log:
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3307
log
then start the service again, test the issue reported with MA and
then stop the server and print here the contain od computer_name.log
file.
And here is the text of the .log file:
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version:
5.0.37-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
070508 17:43:36 1 Connect root@localhost on dvdrentals
1 Query SET NAMES utf8
1 Query show databases
1 Query show databases
2 Connect root@localhost on
2 Query SELECT @@sql_mode
2 Query SET SESSION
sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
2 Query SET NAMES utf8
2 Quit
070508 17:43:44 1 Init DB dvdrentals
1 Query SHOW TABLE STATUS
1 Query SHOW INDEX FROM `customers`
1 Query DESCRIBE `customers`
1 Init DB dvdrentals
070508 17:43:46 1 Init DB dvdrentals
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB dvdrentals
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
070508 17:43:48 1 Init DB test
1 Query SHOW TABLE STATUS
070508 17:43:49 1 Query SHOW INDEX FROM `new table`
1 Query DESCRIBE `new table`
1 Init DB dvdrentals
070508 17:43:50 1 Init DB test
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB test
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
1 Init DB mysql
1 Query SHOW TABLE STATUS
070508 17:43:51 1 Query SHOW INDEX FROM `columns_priv`
1 Query DESCRIBE `columns_priv`
1 Init DB dvdrentals
070508 17:43:52 1 Init DB mysql
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB mysql
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
1 Init DB information_schema
1 Query SHOW TABLE STATUS
1 Query SHOW INDEX FROM `CHARACTER_SETS`
1 Query DESCRIBE `CHARACTER_SETS`
1 Init DB dvdrentals
070508 17:43:53 1 Init DB information_schema
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB information_schema
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
Could anyone help me please?
Thanks in advance.
How to repeat:
I have installed MySql Server 5.0 and MySql Administrator 1.2.11 on a XP Home Edition.
