*Problemă/Întrebare: Problema Mysql
Tipologie server: pvm
*Resursă folosită: -
*ServerFiles utilizat: -
*Syserr: -
Poză:
*Detalii suplimentare: parola e schimbata, dar cand vreau sa dau pe save primesc erroarea asta, am incercat si cu repair si cu comanda ( mysql_upgrade -u root -p ) unde acolo primesc erroarea asta

root@enix:/var/db # mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK

Repairing tables
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 62: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1243 (HY000) at line 63: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 64: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 66: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1243 (HY000) at line 67: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 68: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 81: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1243 (HY000) at line 82: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 83: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 110: Table 'mysql.slave_master_info' doesn't exist
ERROR 1243 (HY000) at line 111: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 112: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 128: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1243 (HY000) at line 129: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 130: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1896: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1897: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1898: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1899: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1146 (42S02) at line 1900: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1146 (42S02) at line 1904: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 1908: Table 'mysql.innodb_index_stats' doesn't exist
FATAL ERROR: Upgrade failed

creaza tabelele urmatoare mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist

Metin2Lunaris scrie: ↑09 Apr 2024, 14:35 creaza tabelele urmatoare mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist

cum?

mysqlcheck -u root -p --all-databases --auto-repair

daca nu merge , ruleaza asta in query

CREATE TABLE mysql.innodb_index_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
index_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_value bigint(20) unsigned NOT NULL,
sample_size bigint(20) unsigned DEFAULT NULL,
stat_description varchar(1024) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (database_name,table_name,index_name,stat_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

CREATE TABLE mysql.innodb_table_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
n_rows bigint(20) unsigned NOT NULL,
clustered_index_size bigint(20) unsigned NOT NULL,
sum_of_other_index_sizes bigint(20) unsigned NOT NULL,
PRIMARY KEY (database_name,table_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

Metin2Lunaris scrie: ↑09 Apr 2024, 15:24 mysqlcheck -u root -p --all-databases --auto-repair

daca nu merge , ruleaza asta in query

CREATE TABLE mysql.innodb_index_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
index_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_value bigint(20) unsigned NOT NULL,
sample_size bigint(20) unsigned DEFAULT NULL,
stat_description varchar(1024) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (database_name,table_name,index_name,stat_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

CREATE TABLE mysql.innodb_table_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
n_rows bigint(20) unsigned NOT NULL,
clustered_index_size bigint(20) unsigned NOT NULL,
sum_of_other_index_sizes bigint(20) unsigned NOT NULL,
PRIMARY KEY (database_name,table_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

am rulat ce mi-ai dat la comanda

mysqlcheck -u root -p --all-databases --auto-repair

primesc asta

root@enixyazilim:~ # mysqlcheck -u root -p --all-databases --auto-repair
Enter password:
account.account OK
account.antifarm OK
account.block_exception OK
account.blocked_hwids OK
account.iptocountry OK
account.string OK
account.string_copy OK
account.vote4bonus OK
common.exp_table OK
common.gmhost OK
common.gmlist OK
common.helperlist OK
common.locale OK
common.priv_settings OK
common.spam_db OK
log.acce OK
log.acce_copy OK
log.attr_transfer OK
log.bootlog OK
log.bootlog_copy OK
log.change_empire OK
log.change_name OK
log.chat_log OK
log.command_log OK
log.cube OK
log.dragon_slay_log OK
log.fish_log OK
log.goldlog OK
log.hack_crc_log OK
log.hack_log OK
log.hackshield_log OK
log.invalid_server_log OK
log.levellog OK
log.log OK
log.loginlog OK
log.loginlog2 OK
log.money_log OK
log.pcbang_loginlog OK
log.quest_reward_log OK
log.refinelog OK
log.shout_log OK
log.speed_hack OK
log.vcard_log OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
player.affect OK
player.banword OK
player.battlepass_missions OK
player.battlepass_playerindex OK
player.change_empire OK
player.daily_reward_items OK
player.daily_reward_status OK
player.dungeon_ranking OK
player.event OK
player.event_table OK
player.guild OK
player.guild_comment OK
player.guild_grade OK
player.guild_member OK
player.guild_war OK
player.guild_war_bet OK
player.guild_war_reservation OK
player.horse_name OK
player.item OK
player.item_attr OK
player.item_attr_rare OK
player.item_award OK
player.item_extra_proto OK
player.item_proto OK
player.land OK
player.lotto_list OK
player.map_list OK
player.marriage OK
player.messenger_list OK
player.mob_proto OK
player.myshop_pricelist OK
player.new_petsystem OK
player.object OK
player.object_proto OK
player.offlineshop_auction_offers OK
player.offlineshop_auctions OK
player.offlineshop_logs OK
player.offlineshop_offers OK
player.offlineshop_safebox_items OK
player.offlineshop_safebox_valutes OK
player.offlineshop_shop_items OK
player.offlineshop_shops OK
player.pcbang_ip OK
player.player OK
player.player_deleted OK
player.player_index OK
player.quest OK
player.refine_proto OK
player.reward_table OK
player.safebox OK
player.savepoint OK
player.shop OK
player.shop_item OK
player.skill_color OK
player.skill_proto OK
player.sms_pool OK
player.string OK

Repairing tables
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
mysql.slave_master_info
Error : Table 'mysql.slave_master_info' doesn't exist
status : Operation failed
mysql.slave_relay_log_info
Error : Table 'mysql.slave_relay_log_info' doesn't exist
status : Operation failed
mysql.slave_worker_info
Error : Table 'mysql.slave_worker_info' doesn't exist
status : Operation failed

si in query asta

Rezolvat cer t/c