Re: Every new machine blocks connection
Posted by: Vitor Vitor
Date: June 27, 2023 12:40PM
Date: June 27, 2023 12:40PM
That's the .err file... I didn't see any difference.
****** WHEN I TRIED TO LOGIN IN THE 1ST TIME AND BLOCKED EVERYONE ******
2023-06-27 14:57:35 3764 [Warning] Access denied for user 'root'@'10.91.2.50' (using password: YES)
****** AFTER THAT, I DID ALL THE STEPS FROM OTHERS POSTS... YOU'LL SEE 2 RESTARTS ******
2023-06-27 14:58:17 3764 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown
2023-06-27 14:58:17 3764 [Note] Giving 60 client threads a chance to die gracefully
2023-06-27 14:58:17 3764 [Note] Event Scheduler: Purging the queue. 0 events
2023-06-27 14:58:17 3764 [Note] Shutting down slave threads
2023-06-27 14:58:19 3764 [Note] Forcefully disconnecting 60 remaining clients
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 67 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 77 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 165 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 163 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 156 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 160 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 176 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 153 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 169 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 167 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 302 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 296 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 143 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 305 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 307 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 303 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 87 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 308 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 146 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 286 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 72 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 75 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 70 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 52 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 43 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 309 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 232 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 207 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 185 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 271 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 255 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 210 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 253 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 218 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 267 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 216 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 237 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 239 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 258 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 260 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 264 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 50 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 273 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 95 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 109 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 124 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 98 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 120 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 131 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 107 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 122 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 114 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 102 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 138 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 116 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 136 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 127 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 129 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 276 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 140 user: 'root'
2023-06-27 14:58:19 3764 [Note] Binlog end
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'partition'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_METRICS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_TRX'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'InnoDB'
2023-06-27 14:58:19 3764 [Note] InnoDB: FTS optimize thread exiting.
2023-06-27 14:58:19 3764 [Note] InnoDB: Starting shutdown...
2023-06-27 14:58:21 3764 [Note] InnoDB: Shutdown completed; log sequence number 1607951
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'BLACKHOLE'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'ARCHIVE'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MRG_MYISAM'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MyISAM'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MEMORY'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'CSV'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'sha256_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'mysql_old_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'mysql_native_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'binlog'
2023-06-27 14:58:21 3764 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
2023-06-27 14:58:22 5816 [Note] Plugin 'FEDERATED' is disabled.
2023-06-27 14:58:22 7ac InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2023-06-27 14:58:22 5816 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-06-27 14:58:22 5816 [Note] InnoDB: The InnoDB memory heap is disabled
2023-06-27 14:58:22 5816 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-27 14:58:22 5816 [Note] InnoDB: Memory barrier is not used
2023-06-27 14:58:22 5816 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-06-27 14:58:22 5816 [Note] InnoDB: Not using CPU crc32 instructions
2023-06-27 14:58:22 5816 [Note] InnoDB: Initializing buffer pool, size = 957.0M
2023-06-27 14:58:22 5816 [Note] InnoDB: Completed initialization of buffer pool
2023-06-27 14:58:22 5816 [Note] InnoDB: Highest supported file format is Barracuda.
2023-06-27 14:58:22 5816 [Note] InnoDB: 128 rollback segment(s) are active.
2023-06-27 14:58:22 5816 [Note] InnoDB: Waiting for purge to start
2023-06-27 14:58:22 5816 [Note] InnoDB: 5.6.37 started; log sequence number 1607951
2023-06-27 14:58:22 5816 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2023-06-27 14:58:22 5816 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2023-06-27 14:58:22 5816 [Note] Server socket created on IP: '0.0.0.0'.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2023-06-27 14:58:23 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.37-log' socket: '' port: 3306 MySQL Community Server (GPL)
****** 2ND RESTART, AFTER NEW PRIVILEGES ******
2023-06-27 14:58:52 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown
2023-06-27 14:58:52 5816 [Note] Giving 0 client threads a chance to die gracefully
2023-06-27 14:58:52 5816 [Note] Shutting down slave threads
2023-06-27 14:58:52 5816 [Note] Forcefully disconnecting 0 remaining clients
2023-06-27 14:58:52 5816 [Note] Binlog end
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'partition'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_METRICS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_TRX'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'InnoDB'
2023-06-27 14:58:52 5816 [Note] InnoDB: FTS optimize thread exiting.
2023-06-27 14:58:52 5816 [Note] InnoDB: Starting shutdown...
2023-06-27 14:58:53 5816 [Note] InnoDB: Shutdown completed; log sequence number 1607961
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'BLACKHOLE'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'ARCHIVE'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MRG_MYISAM'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MyISAM'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MEMORY'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'CSV'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'sha256_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'mysql_old_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'mysql_native_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'binlog'
2023-06-27 14:58:53 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
2023-06-27 14:58:55 6984 [Note] Plugin 'FEDERATED' is disabled.
2023-06-27 14:58:55 15a4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2023-06-27 14:58:55 6984 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-06-27 14:58:55 6984 [Note] InnoDB: The InnoDB memory heap is disabled
2023-06-27 14:58:55 6984 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-27 14:58:55 6984 [Note] InnoDB: Memory barrier is not used
2023-06-27 14:58:55 6984 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-06-27 14:58:55 6984 [Note] InnoDB: Not using CPU crc32 instructions
2023-06-27 14:58:55 6984 [Note] InnoDB: Initializing buffer pool, size = 957.0M
2023-06-27 14:58:55 6984 [Note] InnoDB: Completed initialization of buffer pool
2023-06-27 14:58:55 6984 [Note] InnoDB: Highest supported file format is Barracuda.
2023-06-27 14:58:55 6984 [Note] InnoDB: 128 rollback segment(s) are active.
2023-06-27 14:58:55 6984 [Note] InnoDB: Waiting for purge to start
2023-06-27 14:58:55 6984 [Note] InnoDB: 5.6.37 started; log sequence number 1607961
2023-06-27 14:58:55 6984 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2023-06-27 14:58:55 6984 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2023-06-27 14:58:55 6984 [Note] Server socket created on IP: '0.0.0.0'.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2023-06-27 14:58:55 6984 [Note] Event Scheduler: Loaded 0 events
2023-06-27 14:58:55 6984 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.37-log' socket: '' port: 3306 MySQL Community Server (GPL)
****** AND NOW EVERYONE, INCLUDING THE NEW GUY FROM 10.91.2.50, CAN CONNECT ******
****** WHEN I TRIED TO LOGIN IN THE 1ST TIME AND BLOCKED EVERYONE ******
2023-06-27 14:57:35 3764 [Warning] Access denied for user 'root'@'10.91.2.50' (using password: YES)
****** AFTER THAT, I DID ALL THE STEPS FROM OTHERS POSTS... YOU'LL SEE 2 RESTARTS ******
2023-06-27 14:58:17 3764 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown
2023-06-27 14:58:17 3764 [Note] Giving 60 client threads a chance to die gracefully
2023-06-27 14:58:17 3764 [Note] Event Scheduler: Purging the queue. 0 events
2023-06-27 14:58:17 3764 [Note] Shutting down slave threads
2023-06-27 14:58:19 3764 [Note] Forcefully disconnecting 60 remaining clients
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 67 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 77 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 165 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 163 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 156 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 160 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 176 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 153 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 169 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 167 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 302 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 296 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 143 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 305 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 307 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 303 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 87 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 308 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 146 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 286 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 72 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 75 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 70 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 52 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 43 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 309 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 232 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 207 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 185 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 271 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 255 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 210 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 253 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 218 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 267 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 216 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 237 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 239 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 258 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 260 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 264 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 50 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 273 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 95 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 109 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 124 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 98 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 120 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 131 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 107 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 122 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 114 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 102 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 138 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 116 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 136 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 127 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 129 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 276 user: 'root'
2023-06-27 14:58:19 3764 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 140 user: 'root'
2023-06-27 14:58:19 3764 [Note] Binlog end
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'partition'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_METRICS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_CMP'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'INNODB_TRX'
2023-06-27 14:58:19 3764 [Note] Shutting down plugin 'InnoDB'
2023-06-27 14:58:19 3764 [Note] InnoDB: FTS optimize thread exiting.
2023-06-27 14:58:19 3764 [Note] InnoDB: Starting shutdown...
2023-06-27 14:58:21 3764 [Note] InnoDB: Shutdown completed; log sequence number 1607951
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'BLACKHOLE'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'ARCHIVE'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MRG_MYISAM'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MyISAM'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'MEMORY'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'CSV'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'sha256_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'mysql_old_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'mysql_native_password'
2023-06-27 14:58:21 3764 [Note] Shutting down plugin 'binlog'
2023-06-27 14:58:21 3764 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
2023-06-27 14:58:22 5816 [Note] Plugin 'FEDERATED' is disabled.
2023-06-27 14:58:22 7ac InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2023-06-27 14:58:22 5816 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-06-27 14:58:22 5816 [Note] InnoDB: The InnoDB memory heap is disabled
2023-06-27 14:58:22 5816 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-27 14:58:22 5816 [Note] InnoDB: Memory barrier is not used
2023-06-27 14:58:22 5816 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-06-27 14:58:22 5816 [Note] InnoDB: Not using CPU crc32 instructions
2023-06-27 14:58:22 5816 [Note] InnoDB: Initializing buffer pool, size = 957.0M
2023-06-27 14:58:22 5816 [Note] InnoDB: Completed initialization of buffer pool
2023-06-27 14:58:22 5816 [Note] InnoDB: Highest supported file format is Barracuda.
2023-06-27 14:58:22 5816 [Note] InnoDB: 128 rollback segment(s) are active.
2023-06-27 14:58:22 5816 [Note] InnoDB: Waiting for purge to start
2023-06-27 14:58:22 5816 [Note] InnoDB: 5.6.37 started; log sequence number 1607951
2023-06-27 14:58:22 5816 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2023-06-27 14:58:22 5816 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2023-06-27 14:58:22 5816 [Note] Server socket created on IP: '0.0.0.0'.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:22 5816 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2023-06-27 14:58:23 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.37-log' socket: '' port: 3306 MySQL Community Server (GPL)
****** 2ND RESTART, AFTER NEW PRIVILEGES ******
2023-06-27 14:58:52 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown
2023-06-27 14:58:52 5816 [Note] Giving 0 client threads a chance to die gracefully
2023-06-27 14:58:52 5816 [Note] Shutting down slave threads
2023-06-27 14:58:52 5816 [Note] Forcefully disconnecting 0 remaining clients
2023-06-27 14:58:52 5816 [Note] Binlog end
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'partition'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_METRICS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_CMP'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'INNODB_TRX'
2023-06-27 14:58:52 5816 [Note] Shutting down plugin 'InnoDB'
2023-06-27 14:58:52 5816 [Note] InnoDB: FTS optimize thread exiting.
2023-06-27 14:58:52 5816 [Note] InnoDB: Starting shutdown...
2023-06-27 14:58:53 5816 [Note] InnoDB: Shutdown completed; log sequence number 1607961
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'BLACKHOLE'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'ARCHIVE'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MRG_MYISAM'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MyISAM'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'MEMORY'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'CSV'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'sha256_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'mysql_old_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'mysql_native_password'
2023-06-27 14:58:53 5816 [Note] Shutting down plugin 'binlog'
2023-06-27 14:58:53 5816 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
2023-06-27 14:58:55 6984 [Note] Plugin 'FEDERATED' is disabled.
2023-06-27 14:58:55 15a4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2023-06-27 14:58:55 6984 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-06-27 14:58:55 6984 [Note] InnoDB: The InnoDB memory heap is disabled
2023-06-27 14:58:55 6984 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-27 14:58:55 6984 [Note] InnoDB: Memory barrier is not used
2023-06-27 14:58:55 6984 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-06-27 14:58:55 6984 [Note] InnoDB: Not using CPU crc32 instructions
2023-06-27 14:58:55 6984 [Note] InnoDB: Initializing buffer pool, size = 957.0M
2023-06-27 14:58:55 6984 [Note] InnoDB: Completed initialization of buffer pool
2023-06-27 14:58:55 6984 [Note] InnoDB: Highest supported file format is Barracuda.
2023-06-27 14:58:55 6984 [Note] InnoDB: 128 rollback segment(s) are active.
2023-06-27 14:58:55 6984 [Note] InnoDB: Waiting for purge to start
2023-06-27 14:58:55 6984 [Note] InnoDB: 5.6.37 started; log sequence number 1607961
2023-06-27 14:58:55 6984 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2023-06-27 14:58:55 6984 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2023-06-27 14:58:55 6984 [Note] Server socket created on IP: '0.0.0.0'.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-06-27 14:58:55 6984 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2023-06-27 14:58:55 6984 [Note] Event Scheduler: Loaded 0 events
2023-06-27 14:58:55 6984 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.37-log' socket: '' port: 3306 MySQL Community Server (GPL)
****** AND NOW EVERYONE, INCLUDING THE NEW GUY FROM 10.91.2.50, CAN CONNECT ******
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.