MySQL will not start on Win VISTA Ultimate x64

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

MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 16:04

I just installed XAMPP on Windows VISTA Ultimate x64. Apache started without issue, but I cannot get MySQL to start. I thought there might be an issue with the installation, so I went to Control Panel/Programs and Features to uninstall the XAMPP application, but it is not in the installed applications list. Are there known issues with VISTA Ultimate x64 and XAMPP, or is this something unique to my computer?

Please help... I need to get started working on a new web site written using Joomla, and I need to learn it first.

Thanks in advance for your help.
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55

Re: MySQL will not start on Win VISTA Ultimate x64

Postby Altrea » 03. May 2010 16:13

first of all, check if port 3306 is blocked by another process. run the port-check.

If port 3306 is free then maybe its a windows uac issue.

Try this:
Start your xampp control panel as Administrator (right click on the control panel icon -> run as Administrator). Then try to start mysql.

If this doesn't help, tick the svc checkbox for MySQL and restart your computer. After that check if your MySQL Server has started.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 16:28

Thanks for all your suggestions.

I tried all of your suggestions, but still MySQL doesn't make any difference.

I did right click on the XAMPP Control Panel and selected "Run as Administrator". When I click on Start for MwSQL, the button blinks from Blue to grey, and in the status box at the bottom it returns the message saying, "MySQL service started".

I made sure the checkbox next to run as a service was checked, restarted the computer and went to http://localhost/ and looked at status, but still MySQL is not running. The status says "DEACTIVATED".

So what's my next step?
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55

Re: MySQL will not start on Win VISTA Ultimate x64

Postby Altrea » 03. May 2010 16:50

Doesn't matter if the status says deactivated or not. This display is not always true.
Try to connect to your database through phpmyadmin or the shell. If you can connect, create databases, etc, MySQL is running.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 16:51

How do I start or connect using phpmyadmin?
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55

Re: MySQL will not start on Win VISTA Ultimate x64

Postby Altrea » 03. May 2010 16:55

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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 17:02

OK, I got the following error:

MySQL said: Documentation
#2003 - Can't connect to MySQL server on 'localhost' (10061)
Connection for controluser as defined in your configuration failed.
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55

Re: MySQL will not start on Win VISTA Ultimate x64

Postby Altrea » 03. May 2010 17:06

then you have defined a password for your root user (or runned the security script where a password is setted).
You had to tell phpmyadmin what the password is to connect.
phpmyadmin has a confic.inc.php file where this must be set.
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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 17:14

No, I never run any security script... the instructions I have never told me anything about running a security script. I have installed this before... a year or so ago and do not remember having this much of a problem. Is there a step by step instruction manual somewhere that I can follow? I am sorry for all the trouble I am being with this, but I am a complete newbie.
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55

Re: MySQL will not start on Win VISTA Ultimate x64

Postby davidg47 » 03. May 2010 18:51

Just to let you know, I uninstalled the first installation of XAMPP, and reinstalled it to C:/ (the first time I installed it on my F:/ drive). This time when I installed it, it asked me about several more options, and when I clicked on the Run as a Service button and then clicked on Start, Apache and MySQL both started without error.
davidg47
 
Posts: 6
Joined: 03. May 2010 15:55


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests