Probelm with MySql on Ubuntu 16.04 (XAMPP for Linux)

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

Probelm with MySql on Ubuntu 16.04 (XAMPP for Linux)

Postby RFR » 26. October 2019 02:50

I posted the problem before on https://community.bitnami.com/t/problem-with-mysql-on-ubuntu-16-04-xampp-for-linux/71466/5
In short, when I try to start mysql service, I get
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...already running.
root@HAL:/run/systemd# /opt/lampp/bin/mysql.server: 264: kill: No such process.

gongomra, who has been very helpful so far, requested to run:
sudo bash /opt/lampp/share/mysql/mysql.server start

and post the err file here.

$ sudo bash /opt/lampp/share/mysql/mysql.server start
[sudo] password for richard:
Starting MariaDB.2019-10-26 03:07:13 29600 mysqld_safe Logging to '/opt/lampp/var/mysql/HAL.err'.
2019-10-26 03:07:13 29600 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/share/mysql/mysql.server: line 264: kill: (29600) - No such process

I don't see a way to attach files here, so I opened the file in geany and removed blocks of simillar error lines and replaced them with ...
There appears to be something wrong with the database.
Apparently, I need to run mysql_upgrade.
Then I see this error:
[ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 17:04:35 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

The truncated err log is still about 600 lines and a rather boring (but probably informative) read:

2019-10-20 14:21:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-20 14:21:39 0 [Note] InnoDB: Uses event mutexes
2019-10-20 14:21:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-20 14:21:39 0 [Note] InnoDB: Number of pools: 1
2019-10-20 14:21:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-20 14:21:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-20 14:21:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-20 14:21:39 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 14:21:39 0 [Note] InnoDB: Upgrading redo log: 2*5242880 bytes; LSN=1762733
2019-10-20 14:21:39 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-10-20 14:21:39 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile101 size to 5242880 bytes
2019-10-20 14:21:39 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile1 size to 5242880 bytes
2019-10-20 14:21:39 0 [Note] InnoDB: Renaming log file /opt/lampp/var/mysql/ib_logfile101 to /opt/lampp/var/mysql/ib_logfile0
2019-10-20 14:21:39 0 [Note] InnoDB: New log files created, LSN=1762733
2019-10-20 14:21:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 14:21:39 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-10-20 14:21:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 14:21:39 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-20 14:21:39 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-20 14:21:39 0 [Note] InnoDB: 10.4.8 started; log sequence number 1762733; transaction id 2369
2019-10-20 14:21:39 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 14:21:39 0 [Note] InnoDB: Cannot open '/opt/lampp/var/mysql/ib_buffer_pool' for reading: No such file or directory
2019-10-20 14:21:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-20 14:21:39 0 [Note] Server socket created on IP: '::'.
2019-10-20 14:21:39 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2019-10-20 14:21:39 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2019-10-20 14:21:39 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:21:39 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:21:39 0 [Note] Reading of all Master_info entries succeeded
2019-10-20 14:21:39 0 [Note] Added new Master_info '' to hash table
2019-10-20 14:21:39 0 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-20 14:37:03 10 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
...
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 10 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-20 14:37:03 9 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-20 14:37:03 10 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-20 14:37:03 9 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 14:37:03 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
...
2019-10-20 14:38:43 41 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-20 14:38:43 42 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100408. Please use mysql_upgrade to fix this error
2019-10-20 14:38:43 41 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
...
2019-10-20 17:31:07 0 [Note] /opt/lampp/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-20 17:31:07 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-20 17:31:08 0 [Note] InnoDB: Starting shutdown...
2019-10-20 17:31:08 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 17:31:08 0 [Note] InnoDB: Instance 0, restricted to 250 pages due to innodb_buf_pool_dump_pct=25
2019-10-20 17:31:08 0 [Note] InnoDB: Buffer pool(s) dump completed at 191020 17:31:08
2019-10-20 17:31:09 0 [Note] InnoDB: Shutdown completed; log sequence number 1766826; transaction id 2391
2019-10-20 17:31:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-20 17:31:09 0 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2019-10-20 17:31:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-20 17:31:18 0 [Note] InnoDB: Uses event mutexes
2019-10-20 17:31:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-20 17:31:18 0 [Note] InnoDB: Number of pools: 1
2019-10-20 17:31:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-20 17:31:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-20 17:31:18 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-20 17:31:18 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 17:31:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 17:31:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 17:31:18 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-20 17:31:18 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-20 17:31:18 0 [Note] InnoDB: Waiting for purge to start
2019-10-20 17:31:18 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766826; transaction id 2392
2019-10-20 17:31:18 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 17:31:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-20 17:31:18 0 [Note] InnoDB: Buffer pool(s) load completed at 191020 17:31:18
2019-10-20 17:31:18 0 [Note] Server socket created on IP: '::'.
2019-10-20 17:31:18 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2019-10-20 17:31:18 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2019-10-20 17:31:18 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:31:18 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:31:18 0 [Note] Reading of all Master_info entries succeeded
2019-10-20 17:31:18 0 [Note] Added new Master_info '' to hash table
2019-10-20 17:31:18 0 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
2019-10-20 17:36:34 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:36:34 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:36:34 9 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-20 17:36:34 9 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-20 17:36:35 9 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:36:35 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-20 17:36:35 9 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
...
2019-10-20 17:50:38 29 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-20 17:50:38 29 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-20 17:52:48 31 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2019-10-20 17:59:18 32 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2019-10-20 18:02:43 33 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
...
2019-10-20 18:53:12 95 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).

Status information:

Current dir: /opt/lampp/var/mysql/
Running threads: 5 Cached threads: 2 Stack size: 299008

Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_threshold: 300
Partitions: 0
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0


handler status:
read_key: 85
read_next: 0
read_rnd 3
read_first: 3
write: 0
delete 0
update: 0

Table status:
Opened tables: 22
Open tables: 16
Open files: 30
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 9240576
Number of free chunks: 89
Number of fastbin blocks: 16
Number of mmapped regions: 9
Space in mmapped regions: 160882688
Maximum total allocated space: 0
Space available in freed fastbin blocks: 1104
Total allocated space: 5302448
Total free space: 3938128
Top-most, releasable space: 71856
Estimated memory (with thread stack): 172216320
Global memory allocated by server: 156606768
Memory allocated by threads: 139440



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked
The Event Scheduler is disabled

2019-10-20 18:54:41 0 [Note] /opt/lampp/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-20 18:54:48 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-20 18:54:49 0 [Note] InnoDB: Starting shutdown...
2019-10-20 18:54:49 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 18:54:49 0 [Note] InnoDB: Instance 0, restricted to 250 pages due to innodb_buf_pool_dump_pct=25
2019-10-20 18:54:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 191020 18:54:49
2019-10-20 18:54:50 0 [Note] InnoDB: Shutdown completed; log sequence number 1766835; transaction id 2395
2019-10-20 18:54:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-20 18:54:50 0 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2019-10-20 20:25:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-20 20:25:19 0 [Note] InnoDB: Uses event mutexes
2019-10-20 20:25:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-20 20:25:19 0 [Note] InnoDB: Number of pools: 1
2019-10-20 20:25:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-20 20:25:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-20 20:25:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-20 20:25:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 20:25:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 20:25:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 20:25:19 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-20 20:25:19 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-20 20:25:19 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766835; transaction id 2392
2019-10-20 20:25:19 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 20:25:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-20 20:25:19 0 [Note] Server socket created on IP: '::'.
2019-10-20 20:25:19 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-20 20:25:19 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-20 20:25:19 0 [ERROR] Aborting
2019-10-20 20:48:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-20 20:48:44 0 [Note] InnoDB: Uses event mutexes
2019-10-20 20:48:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-20 20:48:44 0 [Note] InnoDB: Number of pools: 1
2019-10-20 20:48:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-20 20:48:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-20 20:48:44 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-20 20:48:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 20:48:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 20:48:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 20:48:44 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-20 20:48:44 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-20 20:48:44 0 [Note] InnoDB: Waiting for purge to start
2019-10-20 20:48:44 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766844; transaction id 2392
2019-10-20 20:48:44 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 20:48:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-20 20:48:44 0 [Note] InnoDB: Buffer pool(s) load completed at 191020 20:48:44
2019-10-20 20:48:44 0 [Note] Server socket created on IP: '::'.
2019-10-20 20:48:44 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-20 20:48:44 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-20 20:48:44 0 [ERROR] Aborting
2019-10-20 21:33:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-20 21:33:36 0 [Note] InnoDB: Uses event mutexes
2019-10-20 21:33:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-20 21:33:36 0 [Note] InnoDB: Number of pools: 1
2019-10-20 21:33:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-20 21:33:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-20 21:33:36 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-20 21:33:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 21:33:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 21:33:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 21:33:36 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-20 21:33:36 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-20 21:33:36 0 [Note] InnoDB: Waiting for purge to start
2019-10-20 21:33:36 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766853; transaction id 2392
2019-10-20 21:33:36 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-20 21:33:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-20 21:33:36 0 [Note] InnoDB: Buffer pool(s) load completed at 191020 21:33:36
2019-10-20 21:33:36 0 [Note] Server socket created on IP: '::'.
2019-10-20 21:33:36 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-20 21:33:36 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-20 21:33:36 0 [ERROR] Aborting
2019-10-22 16:09:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:09:37 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:09:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:09:37 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:09:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:09:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:09:37 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:09:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:09:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:09:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:09:37 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:09:37 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:09:37 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 16:09:37 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766862; transaction id 2392
2019-10-22 16:09:37 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:09:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:09:37 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:09:37 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:09:37 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:09:37 0 [ERROR] Aborting
2019-10-22 16:10:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:10:22 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:10:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:10:22 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:10:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:10:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:10:22 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:10:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:10:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:10:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:10:22 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:10:22 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:10:22 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 16:10:22 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766871; transaction id 2392
2019-10-22 16:10:22 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:10:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:10:22 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:10:22
2019-10-22 16:10:22 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:10:22 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:10:22 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:10:22 0 [ERROR] Aborting
2019-10-22 16:16:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:16:45 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:16:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:16:45 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:16:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:16:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:16:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:16:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:16:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:16:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:16:45 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:16:45 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:16:45 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 16:16:45 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766880; transaction id 2392
2019-10-22 16:16:45 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:16:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:16:45 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:16:45
2019-10-22 16:16:45 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:16:45 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:16:45 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:16:45 0 [ERROR] Aborting
2019-10-22 16:17:27 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:17:27 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:17:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:17:27 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:17:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:17:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:17:27 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:17:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:17:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:17:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:17:27 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:17:27 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:17:27 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766889; transaction id 2392
2019-10-22 16:17:27 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:17:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:17:27 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:17:27
2019-10-22 16:17:27 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:17:27 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:17:27 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:17:27 0 [ERROR] Aborting
2019-10-22 16:18:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:18:57 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:18:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:18:57 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:18:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:18:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:18:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:18:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:18:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:18:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:18:58 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:18:58 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:18:58 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 16:18:58 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766898; transaction id 2392
2019-10-22 16:18:58 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:18:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:18:58 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:18:58
2019-10-22 16:18:58 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:18:58 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:18:58 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:18:58 0 [ERROR] Aborting
2019-10-22 16:37:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:37:12 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:37:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:37:12 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:37:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:37:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:37:12 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:37:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:37:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:37:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:37:12 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:37:12 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:37:12 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766907; transaction id 2392
2019-10-22 16:37:12 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:37:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:37:12 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:37:12
2019-10-22 16:37:12 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:37:12 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:37:12 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:37:12 0 [ERROR] Aborting
2019-10-22 16:46:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:46:10 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:46:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:46:10 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:46:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:46:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 16:46:10 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:46:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:46:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:46:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:46:10 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:46:10 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 16:46:10 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766932; transaction id 2392
2019-10-22 16:46:10 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:46:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:46:10 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:46:10
2019-10-22 16:46:10 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:46:10 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:46:10 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:46:10 0 [ERROR] Aborting
2019-10-22 16:48:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 16:48:10 0 [Note] InnoDB: Uses event mutexes
2019-10-22 16:48:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 16:48:10 0 [Note] InnoDB: Number of pools: 1
2019-10-22 16:48:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 16:48:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-10-22 16:48:10 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 16:48:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 16:48:10 0 [Note] InnoDB: Resizing redo log from 2*5242880 to 2*50331648 bytes; LSN=1766950
2019-10-22 16:48:10 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-10-22 16:48:10 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2019-10-22 16:48:10 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2019-10-22 16:48:10 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-10-22 16:48:10 0 [Note] InnoDB: New log files created, LSN=1766950
2019-10-22 16:48:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 16:48:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 16:48:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:48:10 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-10-22 16:48:10 0 [Note] InnoDB: 10.4.8 started; log sequence number 1766950; transaction id 2392
2019-10-22 16:48:10 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 16:48:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 16:48:10 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 16:48:10
2019-10-22 16:48:10 0 [Note] Server socket created on IP: '::'.
2019-10-22 16:48:10 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 16:48:10 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 16:48:10 0 [ERROR] Aborting
2019-10-22 17:04:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:04:35 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:04:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:04:35 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:04:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:04:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-10-22 17:04:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:04:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:04:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:04:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:04:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 17:04:35 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-10-22 17:04:35 0 [Note] InnoDB: 10.4.8 started; log sequence number 1767445; transaction id 2392
2019-10-22 17:04:35 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:04:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:04:35 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 17:04:35
2019-10-22 17:04:35 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:04:35 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 17:04:35 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 17:04:35 0 [ERROR] Aborting
2019-10-22 17:13:06 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:13:06 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:13:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:13:06 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:13:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:13:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 17:13:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:13:06 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:13:06 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*5242880 bytes; LSN=1767463
2019-10-22 17:13:06 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-10-22 17:13:06 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile101 size to 5242880 bytes
2019-10-22 17:13:06 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile1 size to 5242880 bytes
2019-10-22 17:13:06 0 [Note] InnoDB: Renaming log file /opt/lampp/var/mysql/ib_logfile101 to /opt/lampp/var/mysql/ib_logfile0
2019-10-22 17:13:06 0 [Note] InnoDB: New log files created, LSN=1767463
2019-10-22 17:13:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:13:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:13:06 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 17:13:06 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 17:13:06 0 [Note] InnoDB: 10.4.8 started; log sequence number 1767463; transaction id 2392
2019-10-22 17:13:06 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:13:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:13:06 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 17:13:06
2019-10-22 17:13:06 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:13:06 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2019-10-22 17:13:06 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2019-10-22 17:13:06 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:13:06 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:13:06 0 [Note] Reading of all Master_info entries succeeded
2019-10-22 17:13:06 0 [Note] Added new Master_info '' to hash table
2019-10-22 17:13:06 0 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
2019-10-22 17:18:11 10 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2019-10-22 17:24:21 0 [Note] /opt/lampp/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-22 17:24:21 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-22 17:24:21 0 [Note] InnoDB: Starting shutdown...
2019-10-22 17:24:21 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:24:21 0 [Note] InnoDB: Instance 0, restricted to 250 pages due to innodb_buf_pool_dump_pct=25
2019-10-22 17:24:21 0 [Note] InnoDB: Buffer pool(s) dump completed at 191022 17:24:21
2019-10-22 17:24:22 0 [Note] InnoDB: Shutdown completed; log sequence number 1767957; transaction id 2393
2019-10-22 17:24:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-22 17:24:22 0 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2019-10-22 17:27:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:27:11 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:27:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:27:11 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:27:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:27:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 17:27:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:27:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:27:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:27:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:27:11 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 16:48:10 0 [Note] InnoDB: New log files created, LSN=1766950
2019-10-22 17:27:11 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 17:27:11 0 [Note] InnoDB: 10.4.8 started; log sequence number 1767957; transaction id 2392
2019-10-22 17:27:11 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:27:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:27:11 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:27:11 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 17:27:11 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 17:27:11 0 [ERROR] Aborting
2019-10-22 17:29:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:29:58 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:29:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:29:58 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:29:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:29:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 17:29:58 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:29:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:29:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:29:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:29:59 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 17:29:59 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 17:29:59 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 17:29:59 0 [Note] InnoDB: 10.4.8 started; log sequence number 1767966; transaction id 2392
2019-10-22 17:29:59 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:29:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:29:59 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:29:59 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 17:29:59
2019-10-22 17:29:59 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2019-10-22 17:29:59 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-22 17:29:59 0 [ERROR] Aborting
2019-10-22 17:33:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:33:46 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:33:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:33:46 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:33:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:33:46 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-10-22 17:33:46 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:33:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:33:46 0 [Note] InnoDB: Resizing redo log from 2*5242880 to 2*50331648 bytes; LSN=1767984
2019-10-22 17:33:46 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-10-22 17:33:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2019-10-22 17:33:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2019-10-22 17:33:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-10-22 17:33:46 0 [Note] InnoDB: New log files created, LSN=1767984
2019-10-22 17:33:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:33:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:33:46 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 17:33:46 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-10-22 17:33:46 0 [Note] InnoDB: Waiting for purge to start
2019-10-22 17:33:46 0 [Note] InnoDB: 10.4.8 started; log sequence number 1767984; transaction id 2392
2019-10-22 17:33:46 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:33:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:33:46 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 17:33:46
2019-10-22 17:33:46 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:33:46 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2019-10-22 17:33:46 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2019-10-22 17:33:46 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:33:46 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:33:46 0 [Note] Reading of all Master_info entries succeeded
2019-10-22 17:33:46 0 [Note] Added new Master_info '' to hash table
2019-10-22 17:33:46 0 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
2019-10-22 17:35:23 0 [Note] /opt/lampp/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-22 17:35:23 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-22 17:35:23 0 [Note] InnoDB: Starting shutdown...
2019-10-22 17:35:23 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:35:23 0 [Note] InnoDB: Buffer pool(s) dump completed at 191022 17:35:23
2019-10-22 17:35:24 0 [Note] InnoDB: Shutdown completed; log sequence number 1768469; transaction id 2393
2019-10-22 17:35:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-22 17:35:24 0 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

2019-10-22 17:35:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-22 17:35:26 0 [Note] InnoDB: Uses event mutexes
2019-10-22 17:35:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-22 17:35:26 0 [Note] InnoDB: Number of pools: 1
2019-10-22 17:35:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-22 17:35:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-22 17:35:26 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-22 17:35:26 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-22 17:35:26 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*5242880 bytes; LSN=1768478
2019-10-22 17:35:26 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-10-22 17:35:26 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile101 size to 5242880 bytes
2019-10-22 17:35:26 0 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile1 size to 5242880 bytes
2019-10-22 17:35:26 0 [Note] InnoDB: Renaming log file /opt/lampp/var/mysql/ib_logfile101 to /opt/lampp/var/mysql/ib_logfile0
2019-10-22 17:35:26 0 [Note] InnoDB: New log files created, LSN=1768478
2019-10-22 17:35:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-22 17:35:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-22 17:35:26 0 [Note] InnoDB: Setting file '/opt/lampp/var/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-22 17:35:26 0 [Note] InnoDB: File '/opt/lampp/var/mysql/ibtmp1' size is now 12 MB.
2019-10-22 17:35:26 0 [Note] InnoDB: 10.4.8 started; log sequence number 1768478; transaction id 2392
2019-10-22 17:35:26 0 [Note] InnoDB: Loading buffer pool(s) from /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:35:26 0 [Note] InnoDB: Buffer pool(s) load completed at 191022 17:35:26
2019-10-22 17:35:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-22 17:35:26 0 [Note] Server socket created on IP: '::'.
2019-10-22 17:35:26 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
2019-10-22 17:35:26 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2019-10-22 17:35:26 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:35:26 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2019-10-22 17:35:26 0 [Note] Reading of all Master_info entries succeeded
2019-10-22 17:35:26 0 [Note] Added new Master_info '' to hash table
2019-10-22 17:35:26 0 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
2019-10-22 17:47:56 0 [Note] /opt/lampp/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-22 17:47:56 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-22 17:47:57 0 [Note] InnoDB: Starting shutdown...
2019-10-22 17:47:57 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/lampp/var/mysql/ib_buffer_pool
2019-10-22 17:47:57 0 [ERROR] InnoDB: Cannot open '/opt/lampp/var/mysql/ib_buffer_pool.incomplete' for writing: Permission denied
2019-10-22 17:47:58 0 [Note] InnoDB: Shutdown completed; log sequence number 1768981; transaction id 2393
2019-10-22 17:47:58 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2019-10-22 17:47:58 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2019-10-22 17:47:58 0 [Note] /opt/lampp/sbin/mysqld: Shutdown complete
RFR
 
Posts: 1
Joined: 26. October 2019 02:26
XAMPP version: 7.3.10-0
Operating System: Ubuntu 16.04

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 28 guests