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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby kdl0 » 10. December 2011 23:39

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
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Yikes. I can't get to work on Windows Vista SP2?

Postby kdl0 » 10. December 2011 23:46

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.. :/
kdl0
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Yikes. I can't get to work on Windows Vista SP2?

Postby Sharley » 10. December 2011 23:49

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Yikes. I can't get to work on Windows Vista SP2?

Postby Altrea » 10. December 2011 23:50

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?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby kdl0 » 11. December 2011 00:02

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
kdl0
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby Sharley » 11. December 2011 00:06

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
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Yikes. I can't get to work on Windows Vista SP2?

Postby kdl0 » 11. December 2011 00:07

Sharley wrote: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
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby kdl0 » 11. December 2011 00:09

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 :)
kdl0
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby Altrea » 11. December 2011 00:15

Take a look at Sharleys last post.

You have a problem with zero-byte files. Your extraction failed. Important files are not extracted.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby Sharley » 11. December 2011 00:24

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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't get MySQL working on Windows 7 64Bit

Postby kdl0 » 11. December 2011 00:31

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.
kdl0
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby Sharley » 11. December 2011 00:36

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't get MySQL working on Windows 7 64Bit

Postby Sharley » 11. December 2011 00:42

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 ?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't get MySQL working on Windows 7 64Bit

Postby kdl0 » 11. December 2011 00:47

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
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Re: Can't get MySQL working on Windows 7 64Bit

Postby kdl0 » 11. December 2011 00:50

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?
kdl0
 
Posts: 11
Joined: 10. December 2011 23:35
Operating System: Win 7 x64

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests