MySQL not Connecting

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

MySQL not Connecting

Postby nairb » 28. January 2016 06:43

Hi,

New to Xampp, and CI (codeigniter). I posted in a CI forum, thinking it was a CI problem, but now I think it is a MySQL connection problem from different testing.

I just installed Xampp, and I'm trying to run a simple program to test the MySQL connection and it fails. I used a small php file to test a database connection. After quite some time it displays an error. If I put in an invalid connection it fails quickly, but if I use localhost:122, which is my server for this, it spins for quite some time. I can use a url like - http://localhost:122/phpmyadmin/ or some other php file with no db connection and it displays fine. I'm using port 122 for localhost, since my IIS is using 80. It serves up whatever php files okay, unless they have a db connection involved. And, I'm not seeing any errors in any of the logs.

In httpd.conf I've tried using Listen 122 and Listen 127.0.0.1:122

Is there something else I need to change? my.ini file? the connection host variable? some setting?

Any thoughts or recommendations appreciated!

thanks!


Code: Select all
<?php
$link = mysql_connect('localhost:122','nairb','nairb');
if (!$link) {
    die('Could not connect to MySQL: ' . mysql_error());
}
echo 'Connection OK'; mysql_close($link);
?>

Warning: mysql_connect(): MySQL server has gone away in C:\xampp\htdocs\testmysql.php on line 2

Warning: mysql_connect(): Error while reading greeting packet. PID=8108 in C:\xampp\htdocs\testmysql.php on line 2

Warning: mysql_connect(): MySQL server has gone away in C:\xampp\htdocs\testmysql.php on line 2

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\testmysql.php on line 2
nairb
 
Posts: 2
Joined: 28. January 2016 06:29
Operating System: Win 7

Re: MySQL not Connecting

Postby Altrea » 28. January 2016 07:00

Hi,

Your Apache and MySQL cannot have the same port. Obvious your Apache is running on port 122, but that don't effects the port you have to use for your MySQL connection string.

Best wishes,
Altrea
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: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL not Connecting

Postby nairb » 28. January 2016 16:34

Ah, okay, that made me dig a bit further and try some things. I was definitely confused on ports, since I needed to use a different for server.

I ended up needing to change the port to 3306, and remove the password (although there is one in phpmyadmin)
$link = mysql_connect('127.0.0.1:3306','nairb');
nairb
 
Posts: 2
Joined: 28. January 2016 06:29
Operating System: Win 7

Re: MySQL not Connecting

Postby DarthSidus » 28. January 2016 22:27

MySQL is not starting in xampp windows 10. It returns the following error:

Error: MySQL shutdown unexpectedly.
9:08:35 PM [mysql] This may be due to a blocked port, missing dependencies,
9:08:35 PM [mysql] improper privileges, a crash, or a shutdown by another method.
9:08:35 PM [mysql] Press the Logs button to view error logs and check
9:08:35 PM [mysql] the Windows Event Viewer for more clues
9:08:35 PM [mysql] If you need more help, copy and post this
9:08:35 PM [mysql] entire log window on the forums

This is the .ini file:

# 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:/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:/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 = "C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/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"

# Change here for bind listening
# bind-address="127.0.0.1"
# bind-address = ::1 # for ipv6

# Where do all the plugins live
plugin_dir = "C:/xampp/mysql/lib/plugin/"

# 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
# (via the "enable-named-pipe" option) will render mysqld useless!
#
# commented in by lampp security
#skip-networking
#skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR



And this is the error log:

2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-23 18:28:59 3a38 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 18:28:59 14904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:28:59 14904 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:28:59 14904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:28:59 14904 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:28:59 14904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:28:59 14904 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:28:59 14904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:28:59 14904 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:28:59 14904 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:28:59 14904 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:28:59 14904 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:28:59 14904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835037
2016-01-23 18:28:59 14780 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:28:59 14904 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:28:59 14904 [Note] Server socket created on IP: '::'.
2016-01-23 18:28:59 14904 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-23 18:28:59 14904 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:28:59 14904 [ERROR] Aborting

2016-01-23 18:29:22 2754 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 18:29:22 10068 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:29:22 10068 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:29:22 10068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:29:22 10068 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:29:22 10068 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:29:22 10068 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:29:22 10068 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:29:22 10068 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:29:22 10068 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:29:22 10068 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:29:22 10068 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:29:22 10068 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835047
2016-01-23 18:29:22 2508 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:29:22 10068 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:29:22 10068 [Note] Server socket created on IP: '::'.
2016-01-23 18:29:22 10068 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-23 18:29:22 10068 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:29:22 10068 [ERROR] Aborting

2016-01-23 18:31:34 21a8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 18:31:34 8616 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:31:34 8616 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:31:34 8616 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:31:34 8616 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:31:34 8616 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:31:34 8616 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:31:34 8616 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:31:34 8616 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:31:34 8616 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:31:34 8616 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:31:34 8616 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:31:34 8616 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835057
2016-01-23 18:31:34 14716 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:31:34 8616 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:31:34 8616 [Note] Server socket created on IP: '::'.
2016-01-23 18:31:34 8616 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-23 18:31:34 8616 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:31:34 8616 [ERROR] Aborting

2016-01-23 18:33:42 3084 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 18:33:42 12420 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:33:42 12420 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:33:42 12420 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:33:42 12420 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:33:42 12420 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:33:42 12420 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:33:42 12420 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:33:42 12420 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:33:42 12420 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:33:42 12420 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:33:42 12420 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:33:42 12420 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835067
2016-01-23 18:33:42 13720 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:33:42 12420 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:33:42 12420 [Note] Server socket created on IP: '::'.
2016-01-23 18:33:42 12420 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 20:51:06 43b4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 20:51:06 17332 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 20:51:06 17332 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 20:51:06 17332 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 20:51:06 17332 [Note] InnoDB: Memory barrier is not used
2016-01-23 20:51:06 17332 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 20:51:06 17332 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 20:51:06 17332 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 20:51:06 17332 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 20:51:06 17332 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-23 20:51:06 17332 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-23 20:51:06 17332 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-23 20:51:06 17332 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-23 20:51:06 17332 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 20:51:06 17332 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-23 20:51:06 17332 [ERROR] Aborting

2016-01-23 21:09:11 2956 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2016-01-23 21:09:11 2956 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 21:09:11 13624 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 21:09:11 2956 [Note] InnoDB: Starting shutdown...
2016-01-23 21:09:12 2956 [Note] InnoDB: Shutdown completed; log sequence number 1835077
2016-01-23 21:09:12 2956 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-23 21:09:18 3b8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 21:09:18 952 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 21:09:18 952 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 21:09:18 952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 21:09:18 952 [Note] InnoDB: Memory barrier is not used
2016-01-23 21:09:18 952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 21:09:18 952 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 21:09:18 952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 21:09:18 952 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 21:09:18 952 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 21:09:18 952 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 21:09:18 952 [Note] InnoDB: Waiting for purge to start
2016-01-23 21:09:18 952 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835077
2016-01-23 21:09:18 5696 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 21:09:18 952 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 21:09:18 952 [Note] Server socket created on IP: '::'.
2016-01-23 21:09:18 952 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 21:09:44 5732 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2016-01-23 21:09:44 5732 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 21:09:44 4848 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 21:09:44 5732 [Note] InnoDB: Starting shutdown...
2016-01-23 21:09:45 5732 [Note] InnoDB: Shutdown completed; log sequence number 1835087
2016-01-23 21:09:45 5732 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-23 21:10:02 2f94 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 21:10:02 12180 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 21:10:02 12180 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 21:10:02 12180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 21:10:02 12180 [Note] InnoDB: Memory barrier is not used
2016-01-23 21:10:02 12180 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 21:10:02 12180 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 21:10:02 12180 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 21:10:02 12180 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 21:10:02 12180 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 21:10:03 12180 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 21:10:03 12180 [Note] InnoDB: Waiting for purge to start
2016-01-23 21:10:03 12180 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835087
2016-01-23 21:10:03 14048 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 21:10:03 12180 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 21:10:03 12180 [Note] Server socket created on IP: '::'.
2016-01-23 21:10:03 12180 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 22:07:20 1228 [Note] mysql\bin\mysqld.exe: Normal shutdown

2016-01-23 22:07:20 1228 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 22:07:20 13692 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 22:07:20 1228 [Note] InnoDB: Starting shutdown...
2016-01-23 22:07:22 1228 [Note] InnoDB: Shutdown completed; log sequence number 1835097
2016-01-23 22:07:22 1228 [Note] mysql\bin\mysqld.exe: Shutdown complete

2016-01-23 22:07:28 22e4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-23 22:07:28 8932 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 22:07:28 8932 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 22:07:28 8932 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 22:07:28 8932 [Note] InnoDB: Memory barrier is not used
2016-01-23 22:07:28 8932 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 22:07:28 8932 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 22:07:28 8932 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 22:07:28 8932 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 22:07:28 8932 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 22:07:28 8932 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 22:07:28 8932 [Note] InnoDB: Waiting for purge to start
2016-01-23 22:07:28 8932 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835097
2016-01-23 22:07:28 5300 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 22:07:28 8932 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 22:07:28 8932 [Note] Server socket created on IP: '::'.
2016-01-23 22:07:28 8932 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 11:57:18 30a0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 11:57:18 12448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 11:57:18 12448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 11:57:18 12448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 11:57:18 12448 [Note] InnoDB: Memory barrier is not used
2016-01-24 11:57:18 12448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 11:57:18 12448 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 11:57:18 12448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 11:57:18 12448 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 11:57:18 12448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-24 11:57:18 12448 [Note] InnoDB: The log sequence numbers 1835097 and 1835097 in ibdata files do not match the log sequence number 1835107 in the ib_logfiles!
2016-01-24 11:57:18 12448 [Note] InnoDB: Database was not shutdown normally!
2016-01-24 11:57:18 12448 [Note] InnoDB: Starting crash recovery.
2016-01-24 11:57:18 12448 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-24 11:57:18 12448 [Note] InnoDB: Restoring possible half-written data pages
2016-01-24 11:57:18 12448 [Note] InnoDB: from the doublewrite buffer...
2016-01-24 11:57:18 12448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-24 11:57:18 12448 [Note] InnoDB: Waiting for purge to start
2016-01-24 11:57:18 12448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835107
2016-01-24 11:57:18 13248 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-24 11:57:18 12448 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 11:57:18 12448 [Note] Server socket created on IP: '::'.
2016-01-24 11:57:18 12448 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 12:22:34 16204 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2016-01-24 12:22:34 16204 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-24 12:22:34 15736 [Note] InnoDB: FTS optimize thread exiting.
2016-01-24 12:22:34 16204 [Note] InnoDB: Starting shutdown...
2016-01-24 12:22:36 16204 [Note] InnoDB: Shutdown completed; log sequence number 1835117
2016-01-24 12:22:36 16204 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-24 16:14:18 1e5c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:14:18 7772 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:14:18 7772 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:14:18 7772 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:14:18 7772 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:14:18 7772 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:14:18 7772 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:14:18 7772 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:14:18 7772 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:14:18 7772 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-24 16:14:18 7772 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-24 16:14:18 7772 [Note] InnoDB: Waiting for purge to start
2016-01-24 16:14:18 7772 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835117
2016-01-24 16:14:18 10152 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-24 16:14:18 7772 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:14:18 7772 [Note] Server socket created on IP: '::'.
2016-01-24 16:14:18 7772 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 16:22:31 46fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:22:31 18172 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:22:31 18172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:22:31 18172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:22:31 18172 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:22:31 18172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:22:31 18172 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:22:31 18172 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:22:31 18172 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:22:31 18172 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:22:31 18172 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:22:31 18172 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:22:31 18172 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:22:31 18172 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:22:31 18172 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:22:31 18172 [ERROR] Aborting

2016-01-24 16:22:55 3ed4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:22:55 16084 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:22:55 16084 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:22:55 16084 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:22:55 16084 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:22:55 16084 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:22:55 16084 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:22:55 16084 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:22:55 16084 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:22:55 16084 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:22:55 16084 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:22:55 16084 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:22:55 16084 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:22:55 16084 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:22:55 16084 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:22:55 16084 [ERROR] Aborting

2016-01-24 16:23:21 253c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:23:21 9532 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:23:21 9532 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:23:21 9532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:23:21 9532 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:23:21 9532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:23:21 9532 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:23:21 9532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:23:21 9532 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:23:21 9532 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:23:21 9532 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:23:21 9532 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:23:21 9532 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:23:21 9532 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:23:21 9532 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:23:21 9532 [ERROR] Aborting

2016-01-24 16:27:34 3f54 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:27:34 16212 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:27:34 16212 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:27:34 16212 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:27:34 16212 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:27:34 16212 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:27:34 16212 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:27:34 16212 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:27:34 16212 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:27:34 16212 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:27:34 16212 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:27:34 16212 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:27:34 16212 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:27:34 16212 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:27:34 16212 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:27:34 16212 [ERROR] Aborting

2016-01-24 16:27:44 11e8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-24 16:27:44 4584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:27:44 4584 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:27:44 4584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:27:44 4584 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:27:44 4584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:27:44 4584 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:27:44 4584 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:27:44 4584 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:27:44 4584 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:27:44 4584 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:27:44 4584 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:27:44 4584 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:27:44 4584 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:27:44 4584 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:27:44 4584 [ERROR] Aborting

2016-01-28 20:58:48 1638 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-28 20:58:48 5688 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 20:58:48 5688 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 20:58:48 5688 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 20:58:48 5688 [Note] InnoDB: Memory barrier is not used
2016-01-28 20:58:48 5688 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 20:58:48 5688 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 20:58:48 5688 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 20:58:48 5688 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 20:58:48 5688 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 20:58:48 5688 [Note] InnoDB: The log sequence numbers 1835117 and 1835117 in ibdata files do not match the log sequence number 1835127 in the ib_logfiles!
2016-01-28 20:58:48 5688 [Note] InnoDB: Database was not shutdown normally!
2016-01-28 20:58:48 5688 [Note] InnoDB: Starting crash recovery.
2016-01-28 20:58:48 5688 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-28 20:58:48 5688 [Note] InnoDB: Restoring possible half-written data pages
2016-01-28 20:58:48 5688 [Note] InnoDB: from the doublewrite buffer...
2016-01-28 20:58:48 5688 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 20:58:48 5688 [Note] InnoDB: Waiting for purge to start
2016-01-28 20:58:48 5688 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835127
2016-01-28 20:58:48 17916 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 20:58:48 5688 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 20:58:48 5688 [Note] Server socket created on IP: '::'.
2016-01-28 20:58:48 5688 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-28 20:58:48 5688 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 20:58:48 5688 [ERROR] Aborting

2016-01-28 21:02:35 4810 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-28 21:02:35 18448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 21:02:35 18448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 21:02:35 18448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 21:02:35 18448 [Note] InnoDB: Memory barrier is not used
2016-01-28 21:02:35 18448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 21:02:35 18448 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 21:02:35 18448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 21:02:35 18448 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 21:02:35 18448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 21:02:35 18448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 21:02:35 18448 [Note] InnoDB: Waiting for purge to start
2016-01-28 21:02:35 18448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835137
2016-01-28 21:02:35 12236 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 21:02:35 18448 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 21:02:35 18448 [Note] Server socket created on IP: '::'.
2016-01-28 21:02:35 18448 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-28 21:02:35 18448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 21:02:35 18448 [ERROR] Aborting

2016-01-28 21:08:32 4ac0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-01-28 21:08:32 19136 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 21:08:32 19136 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 21:08:32 19136 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 21:08:32 19136 [Note] InnoDB: Memory barrier is not used
2016-01-28 21:08:32 19136 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 21:08:32 19136 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 21:08:32 19136 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 21:08:32 19136 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 21:08:32 19136 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 21:08:32 19136 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 21:08:32 19136 [Note] InnoDB: Waiting for purge to start
2016-01-28 21:08:32 19136 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835147
2016-01-28 21:08:32 12372 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 21:08:32 19136 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 21:08:32 19136 [Note] Server socket created on IP: '::'.
2016-01-28 21:08:32 19136 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-28 21:08:32 19136 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 21:08:32 19136 [ERROR] Aborting


I would appreciate any help in getting MySQL running Thanks
DarthSidus
 
Posts: 2
Joined: 24. January 2016 13:07
Operating System: windows 10

Re: MySQL not Connecting

Postby Altrea » 28. January 2016 23:42

Is there already running another MySQL server?
Badly you don't show us the full control panel log entries.
Check for occupied port 3306 in netstat (netstat button in the control panel)
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: 8293
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 73 guests