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