Page 1 of 1

MySQL wont start in Windows 10

PostPosted: 03. February 2016 06:14
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 07:05
by Altrea
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 08:27
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 09:11
by Altrea
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 11:19
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 12:14
by Nobbie
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 12:24
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 12:32
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 22:40
by Mike GC
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

Re: MySQL wont start in Windows 10

PostPosted: 03. February 2016 23:38
by Altrea
No problem. You are welcome :D
Have fun with XAMPP and all that stuff 8)