404 Tech Support

XAMPP and MySQL error fix

After installing XAMPP (which I have previously discussed) and navigating to the MySQL Admin page, I started getting an error that would pop up about every 20 seconds.

MySQL error message

The error message reads:

“Access violation at address 10009F40 in module ‘LIBMYSQL.dll’. Read of address 00000000.”

If I didn’t close the message, a new pop up would arrive slightly lower and to the right of the first error message. This would go on until it reached the bottom of the screen and started migrating to the lower right corner.

In order to correct this, we need to get into the MySQL service administration tool. If the service is running (which it is, since these error messages are popping up), there should be a little stop light icon in the System Tray (bottom right hand corner). Right click on the Stop light to get this menu and click on ‘Show me’.

MySQL service right-click menu

The MySQL admin window will pop-up as a result. Click on the my.ini Setup tab and your window should look a bit like this: (username and password values may vary)

Either delete or comment out the ‘user’ and ‘password’ lines. You can comment out the lines by simply putting the pound (#) character at the front of the line. As soon as you have done that, click the ‘Save Modification’ button. As soon as you press that button the error messages should stop appearing like magic.