Can't get MySQL working (Win7 64Bit) 1.7.7 [SOLVED]

[kdl0]

Hi, I have this same exact problem. I finally got around all the conflicts with Skype and got the other things running, but mysql won't stay up.

A bit of history.. I am working with Magento and wanted to set up a local development environment on my win 7 pc. Well, after a while of trying to manually install php, mysql, and apache, I found a knowledgebase article at magento.com pointing to XAMMP. So that's great, I have solution! Well I tried uninstalling everything, and it seemed to work, and I also ended up installing/removing XAMMP a few times since I didn't know why I was getting the port conflicts, and one of them was 3306 but I think that was only the last time... anyway do you think it could be some left over problem with my original sql install? I am not sure what to do to resolve this.

[kdl0]

fyi, after running /install/portcheck.bat, portcheck.ini contains the following (modified date suggests it was modified):

[Ports]
Port80=BLOCKED
Port443=BLOCKED
Port3306=FREE
Port21=FREE
Port14147=FREE
Port8080=FREE

The httpd is running according to the XAMPP front end

So it doesn't appear to be a port problem preventing mysql from opening.. :/

[Sharley]

Run the version 3 control panel in the xampp folder and click on the Netstat button and see what is currently using port 3306.
xampp-control-3-beta.exe

Latest version is linked in my signature simply extract and overwrite.

The new CPv3 may have more info in it's log file plus many more features for you to enjoy.

Only a guess, you may have a left over my.ini file in the system folders, do a file search as there should only be the one in the \xampp\mysql\bin folder if you uninstalled the other MySQL instance.

[Altrea]

I split this thread because you use a different OS and the reasons for some things don't start can be very different.

Do you start the control panel with administrative priviledges (Rightclick context menu => run as Administrator)?

Does your \xampp\mysql\data\mysql_error.log gives you any information?

[kdl0]

just saw the log file:

111210 16:59:00 [Note] Plugin 'FEDERATED' is disabled.
111210 16:59:00 InnoDB: The InnoDB memory heap is disabled
111210 16:59:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111210 16:59:00 InnoDB: Compressed tables use zlib 1.2.3
111210 16:59:00 InnoDB: Initializing buffer pool, size = 16.0M
111210 16:59:00 InnoDB: Completed initialization of buffer pool
111210 16:59:00 InnoDB: highest supported file format is Barracuda.
111210 16:59:00 InnoDB: Waiting for the background threads to start
111210 16:59:01 InnoDB: 1.1.8 started; log sequence number 1595675
111210 16:59:01 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)


will try running as admin: no change

[Sharley]

That error indicates that you have not extracted the zero length files when installing XAMPP.

You can download the zip version and extract the missing zero length files or uninstall then install again using this method:
viewtopic.php?p=179699#p179699
But do not use your current extract utility as it may not be extracting zero length files that are needed in XAMPP.

See this post:
viewtopic.php?p=189860#p189860

[kdl0]

Run the version 3 control panel in the xampp folder and click on the Netstat button and see what is currently using port 3306.
xampp-control-3-beta.exe

Latest version is linked in my signature simply extract and overwrite.

The new CPv3 may have more info in it's log file plus many more features for you to enjoy.

Only a guess, you may have a left over my.ini file in the system folders, do a file search as there should only be the one in the \xampp\mysql\bin folder if you uninstalled the other MySQL instance.

just saw your response -- only 1 my.ini instance found

new CPv3: looks like the same log messages

Installation was done using the .exe installer, but I did get errors about port issues which may have thrown a monkeywrench into the process..?

[kdl0]

btw thanks for the quick reponse. I have to tell you that in the web development world, apparently works on the first try! I have magento set up already on a web host, but I just want to do some development for the training (btw 40 hrs free training! was $3850 -- if anyone wants to learn Magento ecommerce

[Altrea]

Take a look at Sharleys last post.

You have a problem with zero-byte files. Your extraction failed. Important files are not extracted.

[Sharley]

If as you say you used the installer version then that would have extracted ALL files correctly.

The only other possibility is that a clean-up utility was used which may have removed zero length files and temp/tmp folders needed by the XAMPP components - best to configure clean-up utilities not to clean the XAMPP folder.

Good luck.

[kdl0]

hmm I didn't use a cleanup utility, unless you are considering the windows "uninstall a program" as such.

so XAMPP control panel believes that mysql is running and the demo/examples all worked, but when I try to run phpMyAdmin I get this:

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed.

[Sharley]

You did fix the missing zero length files in the \xampp\mysql\data\mysql folder (host.MYD etc.)?

OK, then try this:

Open the \xampp\mysql\bin\my.ini file and uncomment this line so it looks like this:

Code: Select all

bind-address="127.0.0.1"

Save the file then restart MySQL and see if you can now load phpMyAdmin.

[Sharley]

Just a thought, where did you install XAMPP?

Did you install to the root of a drive or partition so you have for example C:\xampp ?

[kdl0]

yes now the server will stay up. Also yes I left it at the default location of C:\xampp

I found a thread referring to config.inc.php, and I saw that before your last response -- changing 'config' to 'cookie' worked to let me in. I tried to revert back to a failing state in order to test your suggestion, but with 'config' back instead of 'cookie', now I can't get it to fail. When I look at my.ini, the line that starts with bind-address is already commented out now (I'm not sure if it was before.. ). Then I thougt to check the modified time, but only after I uncommented it out and saved as a test (still loads). Well good news is that I am in now! sorry I think I lost the chance to help you debug this, or maybe it was all due to the config/cookie thing? I am just now learning php so I am probably not much help...

[kdl0]

ack: confusing myself here... you said "uncomment" and I somehow read that as "comment" -- sorry to confuse.. with bind-address commented and with 'config' in config.inc.php, I can't get it to fail. Perhaps some kind of cache thing?