MySQL Error 2013 on last step of configuration wizard

[GirlFriday]

I have searched the internet and have not been able to solve my problem.  I used the article on how to install Apache, PHP, and MySQL.  Fantastic article!  However, I bomb on the last step of the MySQL install, and can't seem to get it working.  The error I get is:

Apply Security Settings:
The security settings could not be applied.  Error number 2013.  Lost connection to MySQL server during query.

When I open up cmd and type in mysql -u root -p and enter the password, I get the same error (error 2013 HY000: Lost connection to MySQL server during query.

I am installing on XP, have Norton Internet Security.

In Norton, I went into Personal Firewall, Configure, Programs, and changed Internet Access to "Permit All" for mysql, mysqld-nt, and MySQLInstanceConfig.  Also added 3306 to Port List (think I read that on internet somewhere). 

Tried to run config again and it still fails.

What am I doing wrong or where is the problem? 

TIA
GirlFriday

P.S.  I read the previous post:
P.S.  Do you have multiple copies of libmysql.dll. DO a search from windows explorer to confirm.Ensure that the libmysql.dll are both of the same versions (Did you upgrade from an older version  ? ) .If not available in the ystem32 directory yhen Copy libmysql.dll to the system32 directory .


My libmysql.dll are two different versions, and I don't have libmysql in the System32 directory.  How do I find out which version is the latest, and is that the one that I use in all places?

[COBOLdinosaur]

I'm not a real guru on this stuff but I think I have it tracked down.  Apparently this is a common problem with Norton and some databases including mysql.  It will run if you disable NPF, but that is not really desirable.  What I found was this thread http://forums.mysql.com/read.php?11,71632,71632  in the mysql forums. The 5th comment down timestamped: 03/01/2006 04:12PM  looks like it has the answer which involves using an option to enable all ports because mysql is using some additional ports.

Take a look and see if that helps.  If it is a solution, then maybe we can get the author of the article to update with the additional information, or we will add an additional follow up article.

Thanks for bringing the problem to the forum, it helps us improve the articles when we get this kind of feedback.  If it is still a problem after you try that, let me know.

Cd&

[GirlFriday]

I read the article, and I have tried everything, and so far nothing ugggg!  I even tried turning off Norton Personal Firewall, and it still didn't work.  Do I dare disable Norton completely and try to install?

Now one thing that was different is that I logged on to Mysql.com and made sure my account was created out there.  When I re-installed mysql, I received the message having to do with the mysql.com sign up that login was successfull. 

The next step is the configuration wizard, and it fails again on the last step (apply security settings with the 2013 error).

Here are some questions so I understand better.

1.  Since I got as far as the login successful, does that mean sql is installed but not configured properly?

2.  When I go to browser and type in localhost/phpinfo(), I do not see anything about mysql.  Doesn't this mean that mysql is not installed?

3.  When I open up cmd window and type in mysql -u root -p, it prompts me for my password, and then I get the error 2013.  Does this mean that mysql is not installed?

Thank you for your patience and help.  I really appreciate it as I have tried everything possible to solve this problem!  I think I have uninstalled/reinstalled at least 12 times now trying all different options.

Thank you for your help.
GirlFriday

[COBOLdinosaur]

It sounds like PHP cannot find mysql.  Like it does not understand the path.  I will PM Matt and see if he can take a look.  He has been doing a lot of work on the backend of the site and may not have noticed this.  He wrote the article, so he is the real pro on it.

 

[nicholassolutions]

PM received -- I believe I received an email from GirlFriday also. Thanks for coming to the ERT Forum ;-)

unfortunately I am on my way out the door for a 3 day trip. I'll try to have a look at this while I'm away, but may not have time. From the looks of it, you have MySQL installed, though not properly configured. I'm guessing you have looked here already, but if not see
http://www.vbulletin.com/forum/showthread.php?s=&postid=310265

To be honest, I have never ecountered this error before. You might try also PMing sajuks about this one -- he's probably more experienced with trouble-shooting MySQL than I am.

Sorry I can't be of more help at the moment -- I'll have another look when I get the chance.

-Matt

[GirlFriday]

Thank you for your quick response.  I will look into the the article.  I did read sajuks article on the dll problem, and when I did a search I noticed that I did have two different libmysql.dll's in php and mysql folders and none in the system32 folder.  Will see if I can get that problem fixed. 

By the way, how do you know which dll is the latest version besides looking at the date?  When I right click and go to properties, summary, and detail, there is no version detail listed for the dll.  Here is what I have:

D:WebserverPHP                                libmysql.dll     1044 kb   modified 5/4/2006
D:WebserverMySQLin                     libmySQL.dll    1436 kb   modified 5/26/2006
D:WebserverMySQLAdministrator     libmySQL.dll   1416 kb   modified 2/14/2006

I believe I should probably use the one modified 5/26/2006.  Is this correct?

GirlFriday
Posted on: July 24, 2006, 04:53:07 AMI used the 5/4 dll version and made sure the same version was in all 3 places:  sqlin, php, and system32.  Restarted computer.  Did the localhostphpinfo(), and mysql still does not show up.

Turned off Norton PF, deleted configuration, and ran the configuration again, and still failed on error 2013 on the last step of applying security settings.

went to cmd prompt and entered: mysqld --console and received the following error:
InnoDB: Operating system error number 32 in a file operation.

Can you see I am grasping at straws :(  and don't know what I am doing?  I am trying to read all of the documentation, but it doesn't seem that anything is working?

Thank you for your time.
GirlFriday
Posted on: July 25, 2006, 06:45:15 AMWell, got one step further....  Got the SQL Info to show up in PHPInfo.  The follwoing line (e.g.extension_dir=d:phpext) had an extra " in it. 

But I am still stuck on the other two errors.
GirlFriday
Posted on: July 25, 2006, 06:50:20 AMWell, it is definitely a problem with Norton Internet Security.  I downloaded AVG and installed it so I could turn off Norton Internet Security, and I was able to uninstall the current configuration, and reinstall it successfully. 

When I typed > mysql -u root -p it prompted me for my password, accepted my password, and allowed me to get to the >mysql prompt.

When I turned NIS back on, it failed again with same above error.

Under Firewall, I have added port 3306
For every mysql* program, it shows "permit all" for Internet Access
For MSIF it shows "permit all" for Internet Access.

So, I don't know where to look next except for mysql forums and google!

Any tips/tricks would be appreciated.

GirlFriday
Posted on: July 27, 2006, 05:20:31 PM*** FIXED ***

After continually working on this problem for weeks, changing multiple items in NIS, I finally got it to work by DISABLING Port 3306. 

I have no idea why this works as all the documentation says to enable port 3306 in NIS.

Sigh...

Now on to learn mysql!!!!  I am sure I will be back with more questions <wink>