MySql Won't start

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

MySql Won't start

Postby cheesehead » 24. February 2009 02:57

I installed a fresh copy of XAMPP and MySql will not run.

In the control panel I get this error when I try to start MySql
Code: Select all
ERROR: MySql service not started [-1]


When I go view my services via windows XP administrative tools the path to executable is
Code: Select all
c:/xampp/mysql/bin/mysqld-shareware.exe


When I look in that directory, there is no such mysqld-shareware.exe file.

What is the fix? Why do I even need a fix? Shouldn't it just work out of the box?
cheesehead
 
Posts: 1
Joined: 24. February 2009 02:47

Re: MySql Won't start

Postby yedi » 24. February 2009 15:08

look at c:\WINDOWS\my.ini and change
Server=c:/xampp/mysql/bin/mysqld-shareware.exe
to
Server=c:/xampp/mysql/bin/mysqld.exe



#This File was made using the WinMySQLAdmin 1.4 Tool
#29.07.2008 16:35:12

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=c:/xampp/mysql
#bind-address=10.10.0.63
datadir=c:/xampp/mysql/data
#language=c:/xampp/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=c:/xampp/mysql/bin/mysqld-shareware.exe
user=*****
password=*****



in the 1.7.! xampp's my.ini file is contain that bug

Server=c:/xampp/mysql/bin/mysqld-nt.exe


"c:/xampp/mysql/bin/" folder dont contain mysqld-nt.exe file


good day
yedi
 
Posts: 1
Joined: 24. February 2009 14:59

Re: MySql Won't start

Postby WLFM » 25. February 2009 18:24

I'm getting this same error, except my path to executable points to an old directory where I had another version of MySQL installed. The directory went away with uninstallation, but apparently the service and this variable within it didn't.

I just searched my entire computer and I can't find a my.ini anywhere. Is there some other file I should check for?
WLFM
 
Posts: 1
Joined: 25. February 2009 18:19

Re: MySql Won't start

Postby Izzy » 26. February 2009 00:33

WLFM wrote:...but apparently the service and this variable within it didn't.

I just searched my entire computer and I can't find a my.ini anywhere. Is there some other file I should check for?
No my.ini file any where including in the Windows folder is all the above fix relates to so you should be fine to go forward and locate any other issue preventing you from starting MySQL.

However you may still have a sticking MySQL service that needs to be removed.

First check in your Windows start menu and make sure that there is no shortcut to winmysqladmin and if there is then delete it.


Try this:
Click on
start> then Run...>

then type
sc delete mysql

Click OK

Now reboot and try again to start Apache and MySQL but DO NOT click on the Admin... button next to MySQL or you will have the same problem all over again.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 132 guests