MySQL wont start in Windows 10

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

MySQL wont start in Windows 10

Postby Mike GC » 03. February 2016 06:14

Hi,
I have tried so many times to get this to work but unfortunately when trying to start MySQL I get the following message in the XAMPP console;

MySQL Service detected with wrong path
2:19:57 PM [mysql] Change XAMPP MySQL and Control Panel settings or
2:19:57 PM [mysql] Uninstall/disable the other service manually first
2:19:57 PM [mysql] Found Path: "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL
2:19:57 PM [mysql] Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql

I think its basically telling me that MySQL is looking for files in the programs folder but it needs to look in the XAMPP folder??
I'm a beginner just trying to create a website but cant even get started with that! Can some one help me please?

Mike
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Altrea » 03. February 2016 07:05

Hi,

The by far most common reason for this issue is that you already have installed another MySQL server in path C:\Program Files\MySQL\MySQL Server 5.1\.
Xampp cannot tell you what to do with this foreign MySQL installation. It uses the same service name XAMPP MySQL would use too und commonly the same port too, which is not possible.

Best wishes,
Altrea
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 wont start in Windows 10

Postby Mike GC » 03. February 2016 08:27

Thanks Altrea,
I have previously stripped the computer of all other version of MySQL before this latest installation, just as you suggest, but I guess somewhere deep inside, its holding onto an old path and wont let go of it!

As you can see I am a real beginner and used my Email address as a user name. What an Idiot! It seems to be the only thing that cant be altered in the user profile page.
Is this going to be 'my life' trying to use anything other than windows? I sure hope not!

If it's possible can you change my user Name to 'Mike GC'just so I don't get bombarded with *%$# through my Email address?

Thanks
Mike
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Altrea » 03. February 2016 09:11

Hi Mike,

If you have uninstalled MySQL then you can securely remove this service.
To do that please
  • open a Windows cmd (command line) with elevated administration rights (rightclick -> run as Administrator)
  • type in
    Code: Select all
    sc delete mysql
    and hit enter

best wishes,
Altrea

P.S.: I have changed your Name here
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 wont start in Windows 10

Postby Mike GC » 03. February 2016 11:19

Hey Altrea !

It all works!
You are a gentleman and a scholar, surely worthy of a Nobel Prize and many other accolades I'm certain.
Thanks so much for solving that problem for me. I am now a true friend of Apache, that's for sure.

Now tell me, is there a preferred set up for installing word press into this arrangement? Should I direct it into the Xampp directory or just let it sit where it wants to go?

Much appreciated.

Mike GC
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Nobbie » 03. February 2016 12:14

Mike GC wrote:Now tell me, is there a preferred set up for installing word press into this arrangement? Should I direct it into the Xampp directory or just let it sit where it wants to go?


I dont know where WordPress "wants to go", but it has to be in a folder under the htdocs folder of Xampp (otherwise Apache cannot execute it). I *would* put into c:/xampp/htdocs/wordpress for example and then call it via http://localhost/wordpress
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04

Re: MySQL wont start in Windows 10

Postby Mike GC » 03. February 2016 12:24

OK Altrea,
That's what I did but I call it up with http://local host and it shows the wordpress symbol in the browser tab but nothing is on the screen. I expected it to have the 'hello world' and an index with at least wordpress in it.
Actually, I thought it was supposed to see all the folders in the htdocs folder but it doesn't see any of them, and there are a few (5).
So stuck again!
Mike GC
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Mike GC » 03. February 2016 12:32

Altrea,
Adding to the above, This is what index.php looks like;

<?php
if (!empty($_SERVER['HTTPS']) && ('on' == $_SERVER['HTTPS'])) {
$uri = 'https://';
} else {
$uri = 'http://';
}
$uri .= $_SERVER['HTTP_HOST'];
header('Location: '.$uri.'/dashboard/');
exit;
?>
Something is wrong with the XAMPP installation :-(


Judging by the last bit, I guess not all is well in my world again
Mike GC
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Mike GC » 03. February 2016 22:40

Hi Altrea,

OK, persistence pays off.
All working now.....you can have that Nobel Prize back.
I don't know what that weird message was in the admin file but it all seems OK.

Thanks for al your help

Mike
Mike GC
 
Posts: 6
Joined: 03. February 2016 06:06
Operating System: Windows 10

Re: MySQL wont start in Windows 10

Postby Altrea » 03. February 2016 23:38

No problem. You are welcome :D
Have fun with XAMPP and all that stuff 8)
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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 67 guests