Mysql lässt sich nicht über den Dienst starten. Schon beim Installieren des Dienstes meldet er einen Systemfehler 1067. Aber mysql ist dann in der Tabelle der Dienste vorhanden. Ich kann ihn aber dann nicht starten.
Ich glaube, der Grund liegt im my.ini.
# 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=D:/Programme/Apache/xampp/mysql
tmpdir=D:/Programme/Apache/xampp/tmp
datadir=D:/Programme/Apache/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 = D:/Programme/Apache/xampp/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = D:/Programme/Apache/xampp/mysql/
#innodb_log_arch_dir = D:/Programme/Apache/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=D:/Programme/Apache/xampp/mysql/bin/winmysqladmin.exe
Ich habe am my.ini nichts geändert, ich habe nur mysql_installservice.bat ausgeführt.
Mich würde interessieren, was ich falsch gemacht habe