E hoʻoholo i ka ʻōlelo aʻo: hewa waihona ʻikepili Ua hewa ka helu ʻana o mysql.proc.

ʻOiaʻiʻo, inā ʻoe e hoʻohanaphpMyAdmin, ʻaʻole hiki iā ʻoe ke ʻike i ka hewa ma hea ka pilikia?

• ʻO ka pilikia no ka mea ua hoʻonui ʻoe iā MariaDB a i ʻoleMySQL waihonaManao.
• Hoʻonui iā MariaDB a i ʻoleMySQLMa hope o ka hōkeo waihona, ʻaʻole hoʻohana ʻia nā hale ʻikepilimysql_upgradekauoha e hoʻopau i ka hōʻano hou.
• Ma hope, i ka wā o ka hana ʻana o ka waihona MySQL, hiki ke hōʻike ʻia nā memo hewa.

WordPress pluginI ka wā o ke kaʻina hana hoʻihoʻi ʻakomi, ua hiki mai kēia hewa ▼

'Ōlelo Aʻo: Ua hewa ka helu ʻikepili o ka helu o mysql.proc. Manaʻo ʻia 21, loaʻa 20. Hana ʻia me MariaDB 50560, e holo ana i kēia manawa 100406. E ʻoluʻolu e hoʻohana i ka mysql_upgrade e hoʻoponopono i kēia hewa Nīnau SHOW FUNCTION STATUS

• mysql.proc He papa ʻōnaehana kēia ma 5.1 e hoʻopaʻa i ka ʻike e pili ana i nā kaʻina hana a i ʻole nā ​​​​hana i mālama ʻia.

Pehea e hoʻoponopono ai i ka ʻōlelo aʻo: ʻAʻole hewa ka helu ʻana i ke kolamu o mysql.proc?

Eia malalo iho neiChen Weilianghoʻonā palapala.

KaʻAnuʻu 1:ʻO ka hana palekana ʻo ka hoʻolei ʻana a i ʻole ka hoʻihoʻi anuanu ma mua:

mysqldump -uroot -p123456 --quick --master-data=1 --all-databases --flush-logs --lock-tables >

• E ʻoluʻolu e hoʻololi i ka "123456" i luna i kāu ʻōlelo huna huna MySQL.

KaʻAnuʻu 2:e hoohana i keiamysql_upgrade kauoha e hooponopono

mysql_upgrade -u root --datadir=/var/lib/mysql/ --basedir=/ --password=123456

Eia ke kaʻina hana hōʻikeʻike SSH▼

[root@db lib]# mysql_upgrade -u root -p123456 -hdb --datadir=/var/lib/mysql/ --basedir=/
mysql_upgrade: the '--datadir' option is always ignored
mysql_upgrade: the '--basedir' option is always ignored
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--host=db'
Running 'mysqlcheck' with connection arguments: '--host=db'
mysql.columns_priv                                OK
mysql.db                                          OK
mysql.event                                       OK
mysql.func                                        OK
mysql.general_log
Error   : You can't use locks with log tables.
status  : OK
mysql.help_category                               OK
mysql.help_keyword                                OK
mysql.help_relation                               OK
mysql.help_topic                                  OK
mysql.host                                        OK
mysql.ndb_binlog_index                            OK
mysql.plugin                                      OK
mysql.proc                                        OK
mysql.procs_priv                                  OK
mysql.servers                                     OK
mysql.slow_log
Error   : You can't use locks with log tables.
status  : OK
mysql.student                                     OK
mysql.t1                                          OK
mysql.t2                                          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
................................................
test.newuser                                      OK
test.usertag                                      OK
Running 'mysql_fix_privilege_tables'...
WARNING: NULL values of the 'character_set_client' column ('mysql.proc' table) have been updated with a default value (latin1). Please verify if necessary.
WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (latin1_swedish_ci). Please verify if necessary.
WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary.
OK
[root@db lib]#

Nui aʻe nā hoʻonā i nā pilikia waihona MySQL ma lalo▼

Pehea e hoʻonui ai / hoʻomaikaʻi iā MariaDB7 no VestaCP / CWP / CentOS 10.10.2?

Na kēia kumu aʻo e alakaʻi iā ʻoe pehea e hoʻonui ai / hoʻokomo iā MariaDB i ka mana hou o Mariadb 7 ma Centos 10.10.2.Ke hana pū nei kēia kumu aʻo me CWP a me VestaCP a i ʻole kekahi papa mana hoʻomalu kikowaena VPS kūpono. Paʻa loa ʻo MariaDB 10.10.2 i kēia manawa...

Pehea e hoʻoponopono ai i ke kumuhana WordPress {{unknown}} oembed_cache pilikia?

Pehea e hoʻoholo ai ke kumuhana hoʻomaka {{unknown}} oembed_cache?Aia nā poʻe media hou i aʻo e kūkulu i kahi pūnaewele WordPress a hoʻohana i ke kumumanaʻo robin begin.Loaʻa iā {{unknown}}, oembed_cache errors I ka nānā ʻana o phpMyAdmin i ka waihona MySQL, ua ʻike ʻia ua...

Ua hōʻailona ʻia ka hewa papa ʻikepili mysqld e like me ka hāʻule a me ka hopena hoʻoponopono hope (akomi?).

Ua hōʻailona ʻia ka hewa papa ʻikepili mysqld e like me ka hāʻule ʻana a me ka hopena hoʻoponopono hope (aunoa?) E hōʻike ana kēia ʻatikala iā ʻoe i ka hewa ke hoʻoponopono mākou i ka pākaukau: Ua kaha ʻia ka papa \'./db_name/table_name\' i hāʻule a hope loa...

'Ōlelo Aʻo MySQL: Loaʻa ka lālani kahi o ka auto_increment colum

Inā lawa ka ʻae ʻana o ka luna hoʻomalu pūnaewele e-commerce, hiki ke mālama ʻia ka waihona MySQL ma o ka phpMyAdmin database control panel.Hiki ke hana 'ia nā "analyses" a i 'ole "checks" ma ka waihona 'ikepili WordPress ke loa'a nā hewa i ka waihona.Akā ma laila paha ...