MySql not working

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

MySql not working

Postby jennym » 04. May 2010 11:17

Hi

I loaded xampp yesterday - really struggling because the first download (from SF website default mirror) said it had corrupt files on install. So I deleted the first download and downloaded another version from another mirror.

The problem I am having is that MySql on the control panel says: 'ERROR MySql not started [-1 ]

I can access http://localhost/xampp/ which says: Welcome to XAMPP for Windows Version 1.5.4a , Congratulations: You successfully installed XAMPP on this system!

Clicking on xampp/mysql/mysql_installservice comes up with: Save windows my.ini as my.ini.old (not sure about doing this?)

Please, can anyone advise? :)
Last edited by jennym on 04. May 2010 11:24, edited 1 time in total.
jennym
 
Posts: 3
Joined: 04. May 2010 10:51

Re: MySql not working

Postby jennym » 04. May 2010 11:22

Further infor - looking in windows file, there is a my.ini.old already there. There is also a my.ini file, which says:

Code: Select all
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/Program Files (x86)/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/Program Files (x86)/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
basedir="C:/Program Files (x86)/xampp/mysql"
tmpdir="C:/Program Files (x86)/xampp/tmp"
datadir="C:/Program Files (x86)/xampp/mysql/data"

port            = 3306
socket          = mysql

old-passwords
character-set-server = latin1
collation-server = latin1_general_ci

skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id   = 1

# Uncomment the following if you want to log updates
#log-bin=C:/Program Files (x86)/xampp/mysql/data/mysql-bin

# Uncomment the following if you are NOT using BDB tables
skip-bdb

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/Program Files (x86)/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/Program Files (x86)/xampp/mysql/data/
#innodb_log_arch_dir = C:/Program Files (x86)/xampp/mysql/data/
# 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]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server="C:/Program Files (x86)/xampp/mysql/bin/mysqld.exe"
#user=root
#password=


Wondering if this could be the problem?
jennym
 
Posts: 3
Joined: 04. May 2010 10:51

Re: MySql not working

Postby Altrea » 04. May 2010 11:54

jennym wrote:Welcome to XAMPP for Windows Version 1.5.4a


This is a very old version of xampp. The latest version of xampp for Vindows is XAMPP 1.7.3
official downloadlinks
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySql not working

Postby jennym » 04. May 2010 13:58

Altrea - you are a star! Thank you, all now works as it should.

Another lesson I've learnt (it should be obvious really :oops: ) - make sure the latest version is downloaded!
jennym
 
Posts: 3
Joined: 04. May 2010 10:51

Re: MySql not working

Postby Altrea » 04. May 2010 14:11

No problem.
Glad i can help you :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 145 guests