Page 1 of 1

MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:04
by davidg47
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:13
by Altrea
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:28
by davidg47
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?

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:50
by Altrea
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:51
by davidg47
How do I start or connect using phpmyadmin?

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 16:55
by Altrea

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 17:02
by davidg47
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 17:06
by Altrea
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 17:14
by davidg47
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.

Re: MySQL will not start on Win VISTA Ultimate x64

PostPosted: 03. May 2010 18:51
by davidg47
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.