Feb142008XAMPP Madness!!!!
If you’re running Windows, and have set up XAMPP to complete the PHP tutorials for the Dreamweaver CS3 or Dreamweaver 8 Missing Manuals you may be encountering an error with MySQL (if none of this applies to you, then you can skip this post.)
With the latest XAMPP (maybe some earlier versions too) some people are getting error messages (about every 10 seconds) popping up on their screens. The message reads “access violation at address 10002593 in module ‘LIBMYSQL.dll’ read at address 00000000.”
This error has to do with the a program called WinMySQLadmin. To get rid of those annoying error messages you need to:
- Choose Start > All Programs > Startup > WinMySQLadmin
- Click on the my.ini Setup tab in the WinMySQLadmin window. This can be tricky because the darn error message windows keep popping up on top the WinMySQLadmin window.
- In the my.ini Setup tab, there’s a big text box and at the bottom, you’ll see
user=root
password=password - Delete the second ‘password’ so that those two lines look like this:
user=root
password= - Click the ‘Save Modification’ button in the left area of the window, and confirm that you want to save your changes.
- The error messages should stop now. Close all the open error message windows and breath a sigh of relief.
Thanks to the Php bugs blog for this answer.
12 Responses to “XAMPP Madness!!!!”
Bas van der Veen February 24th, 2008 at 7:04 am
I found this with Google, that helped me solve the problem:
http://www.apachefriends.org/f/viewtopic.php?p=115533&sid=c848556477529d4edef3b99f46e79620
PHPAdmin should be used instead of WinMySQLAdmin apparently and MySql should be started in Windows as a service (check svc in control panel). Good luck!
Ananth February 28th, 2008 at 4:36 am
Thanks mate, it works!
Dr. Jesse March 5th, 2008 at 10:45 am
This is exactly what I was looking for. I had just installed XAMPP and I kept receiving the “access violation at address 10002593 in module ‘LIBMYSQL.dll’ read at address 00000000.” error message. Thanks for the assist.
Dr. Jesse March 5th, 2008 at 11:11 am
After you successfully install XAMPP do not forget to go to http://localhost/xampp and then click the “security” link. Even if your network is secure you should still try to secure the first four “subjects.” The last three subjects are fixable by clicking the link below the subjects table.
Dr. Jesse March 5th, 2008 at 11:13 am
Error in my previous post. The last sentence should read: “The FIRST three subjects are fixable by clicking the link below the subjects table.”
Caspian1 March 12th, 2008 at 11:32 am
I have used the fix you provided and it does stop the the error message, however, when I go to MySQL from the command prompt the server “crashes” (I believe that is the right terminology.) Essentially, the cmd prompt opens and closes. If anyone has a suggestion or can direct me to a location where I can learn to use the environment as a beginner I would appreciate an email to CaspianOne@yahoo.com
Dave March 16th, 2008 at 6:14 pm
Installed XAMPP on Windows XP SP2. Anything requiring PHP crashs XAMPP or one of the sub apps/Apache/MySQL etc. and I have to restart. PHPInfo never runs. It give this error
The instruction at “0×005d19a9″ reference memory at “0×057a0000″. The memory good not bee “read”. The title is apache.exe - Application error.
Ray March 17th, 2008 at 11:00 am
OK so stupid question. The admin tool closes immediately (well within a coupla seconds) of opening and I start getting error messages. Is there anyway to manually edit these settings without using the admin tool? Searching now but any help appreciated
David Candreva April 5th, 2008 at 3:10 am
Thank you! this was verry anoying!
Raw Funk April 7th, 2008 at 12:46 pm
For those who are having hassles accessing the my.ini file from WinMySQLadmin, you can access this file directly from within your Windows directory. EG c:\Windows
open the file and check if the parameters are set to the following:
(these should be the last two entries in the my.ini file).
user=root
password=
If not change to these settings and save.
You’ll need to re-start XAMPP; Apache; mySQL
This should take care of the Access violation LIBMYSQL.dll pop-ups.
Cheers
D
kevin May 8th, 2008 at 10:11 am
Thanks alot for the advise. You really saved me alot of time.
Andreas February 20th, 2008 at 1:00 am
Hi.
The annoying error messages do indeed stop. But WinMySQLAdmin keeps crashing. Now without messages. Not even in the Application Events Log.
OS: Windows XP Professional SP2
WinMySQLAdmin: Version 1.4, part of XAMPP 3.0.8
Would be grateful for all help that makes WinMySQLAdmin usable.
Andreas