Description:
Multiple tables are missing on a fresh install of mysql in regards to replication
How to repeat:
Fresh install of mysql 5.6.6-m9
Set permissions properly and run
scripts/mysql_install_db --user=myuserid --datadir=/data/nms_db/mysql/
Set permissions properly
startup mysql
Log file shows the following
"[ERROR] Error creating master info: Error while checking replication metadata. This might also happen when doing a live upgrade from a version that did not make use of the replication metadata tables. If that was the case, consider finishig the upgrade before starting replication."
./mysql_upgrade -s -v
Looking for 'mysql' as: ./mysql
The --upgrade-system-tables option was used, databases won't be touched.
Running 'mysql_fix_privilege_tables'...
ERROR 1146 (42S02) at line 37: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 46: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1146 (42S02) at line 74: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1243 (HY000) at line 75: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 76: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 104: Table 'mysql.slave_master_info' doesn't exist
ERROR 1243 (HY000) at line 105: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 106: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 123: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1243 (HY000) at line 124: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 125: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1906: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1907: Table 'mysql.slave_master_info' doesn't exist
