MySQL wont start in Windows 10

[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

[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

[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

[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

[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

[Nobbie]

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

[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

[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

[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

[Altrea]

No problem. You are welcome
Have fun with XAMPP and all that stuff