Apache Friends Support Forum

Hi, I just updated from Xampp 1.4.11 to 1.4.12 with the zip-download (the 1.4.11 was a fresh install, also zip-version). Everything works smooth, but there is one weird thing. When I try to start the Mysql using the new control-panel it immediatly jumps back to status "stopped", the rest (apache, filezilla and mercury) run perfect with the control panel, but I have to start the Mysql using the mysql_start.bat file. Stopping mysql through the control-panel is working well.

mysql_installservice.bat i think thats what its call
but run that its in the mysql folder

I'm running Xampp as a tool to test new scripts for websites, otherwise I have to upload the files everytime I change something, now I can test it locally. I don't have apache or mysql installed as service because of that, I want to start and stop them without having to install it as service, is that possible.

check your my.cnf (in xampp/mysql/bin)
especially the ports

I don't recall making any changes to all this, but here it is, I don't see anything wrong with it, but then again: I'n not an expert by a long shot on this...

Code: Select all

# The MySQL client
[client]
# password       = your_password
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
old-passwords
port            = 3306
socket          = mysql
skip-locking
# default-character-set=utf8
character-set-server = latin1
collation-server = latin1_general_ci
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
net_buffer_length = 8K
myisam_sort_buffer_size = 64M
# log-bin
server-id       = 1
thread_cache = 8

basedir=C:/xampp/mysql
tmpdir=C:/xampp/tmp
datadir=C:/xampp/mysql/data

#bind-address=192.168.1.1
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/xampp/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/mysql/
#innodb_log_arch_dir = C:/xampp/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server=C:/xampp/mysql/bin/winmysqladmin.exe

anyone see anything wrong?

that looks like mine, excepting the datapaths

So there's isn't anything wrong with it...

Anybody any other ideas why it won't start mysql?

No idea why it won't, but I suggest you install the MySQL daemon as a service, if its under Win2k/XP. Then it should start fine, and you can still stop it thru xampp CPL.


Also, try upgrading to version 2.0 of the CPL - the bundled version is 1.4.x

I only se Xampp control panel 1.0 in the downloadablke packages. Can someone give me a link to the 2.0-version?

I'd like to try the nw CPL first, before running mysql as a service.

http://www.nat32.com/xampp/

XAMPP CPL 2.1 - Enjoy!

OK, installed the new CP (nice!) but the mysql still won't work smoothly. I installed it as a service, didn't do the trick either. I'm afriad I'm going to have to wait till the next xampp-update unless anyone has an idea?

Well, starting it using the batch-file is working you say?
Then why not try this:

1. Stop mysql fully, first.
2. Go into "\xampp\mysql\" folder.
3. run the .BAT file that uninstalls the service.
4. run the .BAT file that installs the service.
Should work now... If it doesn't, then there's a problem with your "my.cnf" file.


If the problem is with the "my.cnf", then I suggest you download the 7zip version of XAMPP, and extract the default "my.cnf" from it. Repleace yours with the default file.

Do post back on how it goes.

prathapml wrote:Well, starting it using the batch-file is working you say?
Then why not try this:

1. Stop mysql fully, first.
2. Go into "\xampp\mysql" folder.
3. run the .BAT file that uninstalls the service.
4. run the .BAT file that installs the service.
Should work now...

This works, but the mysql is now started automaticly when I switch on my computer. Since I use Xampp for local testing of webpages, I don't want it on for most of the times. Is there a way to have mysql turned off by standard, and starting when asked through the control panel?

Run that .BAT to install the service when you want to run it.
Then run the uninstall .BAT when you want to stop it.
Simple now?