Friday, March 20, 2009

Access violation at address in module libmysql.dll. read of address 00000000

Problem Description
You have installed XAMPP and it was working fine. After restarting your windows it appeared "access violation at address 10002832 in module 'LIBMYSQL.dll'. Read of address 00000000" message popping up over and over again.

Even when you stop the MySql service in the XAMPP panel the messages keep on coming about one every 10 seconds.

But whenever you right-click on the traffic-light in the list of running programs and choose "Win NT>shutdown this tool" then everything works fine again after starting up the MySql service in the XAMPP control panel.

Cause of the Problem
In XAMPP installation MySQL by default install with the user root with no password. Later you changed password of WinMySQLAdmin but the change did not affect in MySQL and hence above pop up windows appears.

Solution of the Problem

1) Open WinMySQLamin. You can usually find it as traffic light on the taskbar. Right click on it and select show me.

2) On the Environment tab select "Set Server's Query Interval". A pop up window will appear. In the "Interval Query Setup" pop up window set a bigger value like 100.

3)Click on "my.ini setup" tab on your WinMySQLamin. In the box you will see password field. Make it null that means remove password from there.

4)Then click "save modification" on the left. Pop up window will appear and save it.

At this stage I hope your problem is disappeared and no pop up window is coming.

If the solution works for you then you have the two options to think.

1. If you are satisfied with it that is leaving password field blank of root user then nothing you need to do. Though it is bad practice to set root password blank.

2. Leave winMySQLAdmin like it is, and rather go and change MySQL to have root and password of the password that is set in WinMySQLAdmin.

No comments:

Post a Comment