XAMPP and MySQL error on startup -


i getting error when try starting mysql service through xampp control panel:

2014-08-17 14:53:44 6028 [error] tcp/ip, --shared-memory, or --named-pipe should configured on nt os 2014-08-17 14:53:44 6028 [error] aborting 

anyone ran issue before , have configuration change may used running?

for reference, these settings within my.ini:

[client]  port            = 3306 socket          = "g:/dev/xampp/mysql/mysql.sock"  # mysql server [mysqld] port= 3306 socket = "g:/dev/xampp/mysql/mysql.sock" basedir = "g:/dev/xampp/mysql"  tmpdir = "g:/dev/xampp/tmp"  datadir = "g:/dev/xampp/mysql/data" pid_file = "mysql.pid" # enable-named-pipe key_buffer = 16m max_allowed_packet = 1m sort_buffer_size = 512k net_buffer_length = 8k read_buffer_size = 256k read_rnd_buffer_size = 512k myisam_sort_buffer_size = 8m log_error = "mysql_error.log" # security changes skip-networking local-infile=0  plugin_dir = "g:/dev/xampp/mysql/lib/plugin/"   skip-federated  server-id   = 1  innodb_data_home_dir = "g:/dev/xampp/mysql/data" innodb_data_file_path = ibdata1:10m:autoextend innodb_log_group_home_dir = "g:/dev/xampp/mysql/data" innodb_buffer_pool_size = 256m innodb_additional_mem_pool_size = 2m innodb_log_file_size = 32m innodb_log_buffer_size = 8m innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 50 innodb_thread_concurrency   = 16 innodb_flush_method = normal  [mysqldump] quick max_allowed_packet = 16m  [mysql] no-auto-rehash  [isamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m  [myisamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m  [mysqlhotcopy] interactive-timeout 

either enable named pipes removing comment before option enable-named-pipe

pid_file = "mysql.pid" enable-named-pipe           # line key_buffer = 16m  

or let mysql listen on tcp/ip port commenting out option skip-networking:

# security changes # skip-networking           # line 

if networking disabled , named pipes not enabled mysqld useless.


Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -