Ogohlantirishni hal qiling: ma'lumotlar bazasi xatosi mysql.proc ustunlari soni noto'g'ri.

Aslida, agar siz foydalansangizphpMyAdmin, xatoni topa olmayapsizmi, muammo qayerda?

• Muammo shundaki, siz MariaDB yoki yangilangansizMySQL ma'lumotlar bazasiversiyasi.
• MariaDB-ni yangilang yokiMySQLMa'lumotlar bazasi versiyasidan keyin ma'lumotlar tuzilmalari ishlatilmaydimysql_upgradeyangilash yangilanishini yakunlash uchun buyruq.
• Keyinchalik, MySQL ma'lumotlar bazasining ishlashi paytida xato xabarlari ko'rsatilishi mumkin.

WordPress plaginAvtomatik zaxiralash jarayonida quyidagi xatolik yuz berdi ▼

Ogohlantirish: maʼlumotlar bazasi xatosi mysql.proc ustunlari soni notoʻgʻri. Kutilayotgan 21, topilgan 20. MariaDB 50560 bilan yaratilgan, hozir 100406. Bu xatolikni tuzatish uchun mysql_upgrade dan foydalaning.

• mysql.proc Bu 5.1-dagi tizim jadvali bo'lib, saqlangan protseduralar yoki funksiyalar haqidagi ma'lumotlarni yozadi.

Ogohlantirishni qanday tuzatish mumkin: ma'lumotlar bazasi xatosi mysql.proc ustunlari soni noto'g'ri?

QuyidagichaChen Veylianghujjatlashtirilgan yechim.

1 yil:Xavfsiz amaliyot birinchi navbatda zaxira nusxasini tashlash yoki sovutishdir:

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

• Iltimos, yuqoridagi "123456" ni MySQL ildiz paroliga o'zgartiring.

2 yil:quyidagilardan foydalaningmysql_upgrade hal qilish buyrug'i

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

Quyida SSHni namoyish qilish jarayoni▼

[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]#

Quyida MySQL maʼlumotlar bazasi bilan bogʻliq muammolarning boshqa yechimlari mavjud▼

🔗Qanday qilib VestaCP/CWP/CentOS 7-ni MariaDB-ning so'nggi versiyasiga yangilash/yangilash mumkin?

🔗Oembed_cache WordPress mavzusidagi {{noma'lum}} muammosini qanday hal qilish mumkin?

🔗MySQLd ma'lumotlar jadvali xatosi buzilgan va oxirgi (avtomatikmi?) tuzatish yechimi sifatida belgilangan

🔗MySQL haqida ogohlantirish: auto_increment ustuni joylashgan qator topildi