dima23
Thu Apr 09, 2020 10:29:03 am
Hello everyone. I have the latest stable version of Zorin OS 15.2, with updated apt packages.
I've installed mysql-server from official repositories but I'm getting annoyed Plugin '0' is not loaded on every reboot of the machine.
The temporary workaround is to start MySQL in safe mode with the command:
Thus, now I'm able to login into mysql shell and try to do something. This is the corrupted result of mysql database:
The output should be similar to:
I need this machine for local development and with such problems, I'll not stay with Zorin for a long time...
Yesterday I've completely removed mysql-server and PHPMyAdmin and reinstalled them, my output was like second until I shut down my laptop and booted it again. What the heck?! I don't have such problems with Fedora (I know these are completely different distros) but I also didn't have such problems on any Ubuntu-based distro...
MySQL server version: mysqld 5.7.29-0ubuntu0.18.04.1
This is /var/log/mysql/error.log
I'm facing 9 year old bug?
https://bugs.mysql.com/bug.php?id=60432
My steps to try fix the issue:
1. Logged in mysql safe mode
2. Updated all users' passwords
3. Flushed privileges
4. Shutdown safe mode
5. Started mysql server in normal mode
Issue persists
Any suggestion how I can eliminate this issue?
I've installed mysql-server from official repositories but I'm getting annoyed Plugin '0' is not loaded on every reboot of the machine.
The temporary workaround is to start MySQL in safe mode with the command:
- Code:
sudo /etc/init.d/mysql stop; sudo mkdir -p /var/run/mysqld; sudo chown mysql /var/run/mysqld; sudo mysqld_safe --skip-grant-tables &
Thus, now I'm able to login into mysql shell and try to do something. This is the corrupted result of mysql database:
- Code:
mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;
+------+-----------------------+--------+-----------+
| user | authentication_string | plugin | host |
+------+-----------------------+--------+-----------+
| root | | | localhost |
| root | | | 127.0.0.1 |
| root | | | ::1 |
| pma | | | localhost |
+------+-----------------------+--------+-----------+
4 rows in set (0.00 sec)
The output should be similar to:
- Code:
+------------------+-------------------------------------------+-----------------------+-----------+
| user | authentication_string | plugin | host |
+------------------+-------------------------------------------+-----------------------+-----------+
| root | *3636DACC8616D997782ADD0839F92C1571D6D78F | mysql_native_password | localhost |
| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| debian-sys-maint | *CC744277A401A7D25BE1CA89AFF17BF607F876FF | mysql_native_password | localhost |
+------------------+-------------------------------------------+-----------------------+-----------+
4 rows in set (0.00 sec)
I need this machine for local development and with such problems, I'll not stay with Zorin for a long time...
Yesterday I've completely removed mysql-server and PHPMyAdmin and reinstalled them, my output was like second until I shut down my laptop and booted it again. What the heck?! I don't have such problems with Fedora (I know these are completely different distros) but I also didn't have such problems on any Ubuntu-based distro...
MySQL server version: mysqld 5.7.29-0ubuntu0.18.04.1
This is /var/log/mysql/error.log
- Code:
2020-04-09T09:07:04.920046Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-09T09:07:04.922028Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1) starting as process 1651 ...
2020-04-09T09:07:04.937378Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-04-09T09:07:04.937410Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-09T09:07:04.937417Z 0 [Note] InnoDB: Uses event mutexes
2020-04-09T09:07:04.937423Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-09T09:07:04.937429Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-09T09:07:04.937435Z 0 [Note] InnoDB: Using Linux native AIO
2020-04-09T09:07:04.941010Z 0 [Note] InnoDB: Number of pools: 1
2020-04-09T09:07:04.952318Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-04-09T09:07:04.954220Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-09T09:07:04.969069Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-09T09:07:04.973617Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-09T09:07:05.005464Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-09T09:07:05.315971Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-09T09:07:05.316041Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09T09:07:05.361246Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-09T09:07:05.361991Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-04-09T09:07:05.362003Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-04-09T09:07:05.362233Z 0 [Note] InnoDB: Waiting for purge to start
2020-04-09T09:07:05.412377Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3499960251
2020-04-09T09:07:05.412540Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-09T09:07:05.412745Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-04-09T09:07:05.419166Z 0 [Warning] System table 'plugin' is expected to be transactional.
2020-04-09T09:07:05.447690Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-04-09T09:07:05.447711Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-04-09T09:07:05.450756Z 0 [Warning] CA certificate ca.pem is self signed.
2020-04-09T09:07:05.451511Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-04-09T09:07:05.454811Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-04-09T09:07:05.454832Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-04-09T09:07:05.454852Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-09T09:07:05.470697Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'localhost' is not loaded. Nobody can currently login using this account.
2020-04-09T09:07:05.470711Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'127.0.0.1' is not loaded. Nobody can currently login using this account.
2020-04-09T09:07:05.470716Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'::1' is not loaded. Nobody can currently login using this account.
2020-04-09T09:07:05.470721Z 0 [Warning] The plugin '0' used to authenticate user 'pma'@'localhost' is not loaded. Nobody can currently login using this account.
2020-04-09T09:07:05.477878Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2020-04-09T09:07:05.477905Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2020-04-09T09:07:05.477909Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2020-04-09T09:07:05.477912Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2020-04-09T09:07:05.477916Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2020-04-09T09:07:05.485645Z 0 [Warning] System table 'servers' is expected to be transactional.
2020-04-09T09:07:05.560629Z 0 [ERROR] Column count of mysql.db is wrong. Expected 22, found 23. The table is probably corrupted
2020-04-09T09:07:05.560652Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2020-04-09T09:07:05.589892Z 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','NOT_USED','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'), 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_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
2020-04-09T09:07:05.589912Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2020-04-09T09:07:05.590088Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-04-09T09:07:05.692043Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200409 13:07:05
2020-04-09T09:38:30.446637Z 2 [Note] Plugin '0' is not loaded
2020-04-09T09:38:39.576151Z 3 [Note] Plugin '0' is not loaded
2020-04-09T09:39:08.515619Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-04-09T09:39:08.515671Z 0 [Note] Shutting down slave threads
2020-04-09T09:39:08.515685Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-04-09T09:39:08.515757Z 0 [Note] Binlog end
2020-04-09T09:39:08.516399Z 0 [Note] Shutting down plugin 'ngram'
2020-04-09T09:39:08.516417Z 0 [Note] Shutting down plugin 'partition'
2020-04-09T09:39:08.516425Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-04-09T09:39:08.516432Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-04-09T09:39:08.516438Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-04-09T09:39:08.516474Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-04-09T09:39:08.516482Z 0 [Note] Shutting down plugin 'MyISAM'
2020-04-09T09:39:08.516491Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-04-09T09:39:08.516498Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-04-09T09:39:08.516504Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-04-09T09:39:08.516510Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-04-09T09:39:08.516516Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-04-09T09:39:08.516521Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-04-09T09:39:08.516527Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-04-09T09:39:08.516533Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-04-09T09:39:08.516539Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-04-09T09:39:08.516545Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-04-09T09:39:08.516551Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-04-09T09:39:08.516557Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-04-09T09:39:08.516563Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-04-09T09:39:08.516569Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-04-09T09:39:08.516575Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-04-09T09:39:08.516581Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-04-09T09:39:08.516587Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-04-09T09:39:08.516593Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-04-09T09:39:08.516599Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-04-09T09:39:08.516605Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-04-09T09:39:08.516611Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-04-09T09:39:08.516617Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-04-09T09:39:08.516623Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-04-09T09:39:08.516629Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-04-09T09:39:08.516635Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-04-09T09:39:08.516641Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-04-09T09:39:08.516647Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-04-09T09:39:08.516653Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-04-09T09:39:08.516659Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-04-09T09:39:08.516665Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-04-09T09:39:08.516672Z 0 [Note] Shutting down plugin 'InnoDB'
2020-04-09T09:39:08.516729Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-04-09T09:39:08.516912Z 0 [Note] InnoDB: Starting shutdown...
2020-04-09T09:39:08.617073Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-04-09T09:39:08.617394Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200409 13:39:08
2020-04-09T09:39:10.034503Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3499975225
2020-04-09T09:39:10.037472Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-09T09:39:10.037506Z 0 [Note] Shutting down plugin 'MEMORY'
2020-04-09T09:39:10.037516Z 0 [Note] Shutting down plugin 'CSV'
2020-04-09T09:39:10.037525Z 0 [Note] Shutting down plugin 'sha256_password'
2020-04-09T09:39:10.037531Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-04-09T09:39:10.037727Z 0 [Note] Shutting down plugin 'binlog'
2020-04-09T09:39:10.038248Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-04-09T09:39:10.450448Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-09T09:39:10.453349Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1) starting as process 5357 ...
2020-04-09T09:39:10.461296Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-04-09T09:39:10.461346Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-09T09:39:10.461356Z 0 [Note] InnoDB: Uses event mutexes
2020-04-09T09:39:10.461364Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-09T09:39:10.461372Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-09T09:39:10.461381Z 0 [Note] InnoDB: Using Linux native AIO
2020-04-09T09:39:10.461814Z 0 [Note] InnoDB: Number of pools: 1
2020-04-09T09:39:10.462002Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-04-09T09:39:10.464625Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-09T09:39:10.481657Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-09T09:39:10.485228Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-09T09:39:10.500450Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-09T09:39:10.594011Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-09T09:39:10.594120Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09T09:39:10.638885Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-09T09:39:10.640284Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-04-09T09:39:10.640312Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-04-09T09:39:10.640710Z 0 [Note] InnoDB: Waiting for purge to start
2020-04-09T09:39:10.693846Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3499975225
2020-04-09T09:39:10.694077Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-09T09:39:10.694298Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-04-09T09:39:10.712186Z 0 [Warning] System table 'plugin' is expected to be transactional.
2020-04-09T09:39:10.727179Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200409 13:39:10
2020-04-09T09:39:10.729139Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-04-09T09:39:10.729165Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-04-09T09:39:10.730074Z 0 [Warning] CA certificate ca.pem is self signed.
2020-04-09T09:39:10.730132Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-04-09T09:39:10.730252Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-04-09T09:39:10.730268Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-04-09T09:39:10.730295Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-09T09:39:10.731611Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'localhost' is not loaded. Nobody can currently login using this account.
2020-04-09T09:39:10.731630Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'127.0.0.1' is not loaded. Nobody can currently login using this account.
2020-04-09T09:39:10.731637Z 0 [Warning] The plugin '0' used to authenticate user 'root'@'::1' is not loaded. Nobody can currently login using this account.
2020-04-09T09:39:10.731643Z 0 [Warning] The plugin '0' used to authenticate user 'pma'@'localhost' is not loaded. Nobody can currently login using this account.
2020-04-09T09:39:10.732311Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2020-04-09T09:39:10.732324Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2020-04-09T09:39:10.732330Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2020-04-09T09:39:10.732347Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2020-04-09T09:39:10.732352Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2020-04-09T09:39:10.733003Z 0 [Warning] System table 'servers' is expected to be transactional.
2020-04-09T09:39:10.741048Z 0 [ERROR] Column count of mysql.db is wrong. Expected 22, found 23. The table is probably corrupted
2020-04-09T09:39:10.741085Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2020-04-09T09:39:10.741324Z 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','NOT_USED','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'), 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_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
2020-04-09T09:39:10.741342Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2020-04-09T09:39:10.741573Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2020-04-09T09:42:28.823517Z 2 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2020-04-09T09:42:28.827308Z 3 [Note] Plugin '0' is not loaded
2020-04-09T09:42:56.542639Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-04-09T09:42:56.542768Z 0 [Note] Shutting down slave threads
2020-04-09T09:42:56.542824Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-04-09T09:42:56.543355Z 0 [Note] Binlog end
2020-04-09T09:42:56.545201Z 0 [Note] Shutting down plugin 'ngram'
2020-04-09T09:42:56.545254Z 0 [Note] Shutting down plugin 'partition'
2020-04-09T09:42:56.545283Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-04-09T09:42:56.545312Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-04-09T09:42:56.545336Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-04-09T09:42:56.545446Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-04-09T09:42:56.545475Z 0 [Note] Shutting down plugin 'MyISAM'
2020-04-09T09:42:56.545507Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-04-09T09:42:56.545534Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-04-09T09:42:56.545559Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-04-09T09:42:56.545584Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-04-09T09:42:56.545608Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-04-09T09:42:56.545634Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-04-09T09:42:56.545658Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-04-09T09:42:56.545683Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-04-09T09:42:56.545707Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-04-09T09:42:56.545732Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-04-09T09:42:56.545850Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-04-09T09:42:56.545884Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-04-09T09:42:56.545908Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-04-09T09:42:56.545933Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-04-09T09:42:56.545957Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-04-09T09:42:56.546017Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-04-09T09:42:56.546040Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-04-09T09:42:56.546061Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-04-09T09:42:56.546083Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-04-09T09:42:56.546104Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-04-09T09:42:56.546125Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-04-09T09:42:56.546146Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-04-09T09:42:56.546167Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-04-09T09:42:56.546189Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-04-09T09:42:56.546210Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-04-09T09:42:56.546231Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-04-09T09:42:56.546252Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-04-09T09:42:56.546273Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-04-09T09:42:56.546293Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-04-09T09:42:56.546316Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-04-09T09:42:56.546338Z 0 [Note] Shutting down plugin 'InnoDB'
2020-04-09T09:42:56.546502Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-04-09T09:42:56.546956Z 0 [Note] InnoDB: Starting shutdown...
2020-04-09T09:42:56.647321Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-04-09T09:42:56.648209Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200409 13:42:56
2020-04-09T09:42:58.293155Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3499975253
2020-04-09T09:42:58.302226Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-09T09:42:58.302311Z 0 [Note] Shutting down plugin 'MEMORY'
2020-04-09T09:42:58.302342Z 0 [Note] Shutting down plugin 'CSV'
2020-04-09T09:42:58.302365Z 0 [Note] Shutting down plugin 'sha256_password'
2020-04-09T09:42:58.302384Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-04-09T09:42:58.302917Z 0 [Note] Shutting down plugin 'binlog'
2020-04-09T09:42:58.304265Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-04-09T09:43:51.322647Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-09T09:43:51.324487Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1) starting as process 6857 ...
2020-04-09T09:43:51.329466Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-04-09T09:43:51.329517Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-09T09:43:51.329529Z 0 [Note] InnoDB: Uses event mutexes
2020-04-09T09:43:51.329538Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-09T09:43:51.329548Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-09T09:43:51.329557Z 0 [Note] InnoDB: Using Linux native AIO
2020-04-09T09:43:51.329854Z 0 [Note] InnoDB: Number of pools: 1
2020-04-09T09:43:51.330008Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-04-09T09:43:51.331803Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-09T09:43:51.341255Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-09T09:43:51.343801Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-09T09:43:51.355634Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-09T09:43:51.394418Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-09T09:43:51.394589Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09T09:43:51.488922Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-09T09:43:51.492649Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-04-09T09:43:51.492770Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-04-09T09:43:51.494240Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 3499975253
2020-04-09T09:43:51.494991Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-09T09:43:51.495786Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-04-09T09:43:51.505132Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200409 13:43:51
2020-04-09T09:43:51.523665Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-04-09T09:43:51.523799Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-04-09T09:43:51.526528Z 0 [Warning] CA certificate ca.pem is self signed.
2020-04-09T09:43:51.526774Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-04-09T09:43:51.527267Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-04-09T09:43:51.527358Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-04-09T09:43:51.527461Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-09T09:43:51.530978Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2020-04-09T09:43:51.531070Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2020-04-09T09:43:51.531117Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2020-04-09T09:43:51.531161Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2020-04-09T09:43:51.531207Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2020-04-09T09:43:51.532042Z 0 [Warning] System table 'servers' is expected to be transactional.
2020-04-09T09:43:51.551740Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
I'm facing 9 year old bug?
https://bugs.mysql.com/bug.php?id=60432
If database manager accidentally (or deliberately) modifies mysql.user table by adding any column in position lower (or equal) than "max_user_connections", then after reloading privileges no one is allowed to log in.
My steps to try fix the issue:
1. Logged in mysql safe mode
2. Updated all users' passwords
3. Flushed privileges
4. Shutdown safe mode
5. Started mysql server in normal mode
Issue persists
Any suggestion how I can eliminate this issue?