My fight this week with mySQL continues. I started getting really strange errors in the error log, and users couldn’t connect, not even root@localhost. The error log showed
1 2 3 4 5 6 7 8 |
2016-09-30T15:04:08.790598Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2016-09-30T15:04:08.790625Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2016-09-30T15:04:08.790628Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2016-09-30T15:04:08.790643Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2016-09-30T15:04:08.790646Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2016-09-30T15:04:08.793672Z 0 [Warning] System table 'servers' is expected to be transactional. 2016-09-30T15:04:08.800142Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2016-09-30T15:04:08.803287Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. |
Followed by logins failing
1 2 3 |
2016-09-30T15:14:27.945521Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2016-09-30T15:14:35.794051Z 5 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2016-09-30T15:14:50.242206Z 6 [Note] Access denied for user 'root'@'localhost' (using password: YES) |
What I think had happened, mySQL was upgraded on the OS by the linux admins. It doesn’t look like anything inside …
Recent Comments