Ngatasi bebaya: kesalahan database Column count mysql.proc salah.

Ing kasunyatan, yen sampeyan nggunakakephpMyAdmin, sampeyan ora bisa nemokake kesalahan ngendi masalah?

• Masalahe amarga sampeyan wis nganyarke MariaDB utawadatabase MySQLversi
• Nganyarke MariaDB utawaMySQLSawise versi database, struktur data ora digunakakemysql_upgradeprintah kanggo ngrampungake nganyari nganyari.
• Sakwise, sajrone operasi database MySQL, pesen kesalahan bisa ditampilake.

plugin WordPressSajrone proses serep otomatis, ana kesalahan ing ngisor iki ▼

Pènget: Kesalahan database Jumlah kolom mysql.proc salah. Dikarepake 21, ditemokake 20. Digawe nganggo MariaDB 50560, saiki mlaku 100406. Mangga gunakake mysql_upgrade kanggo ndandani kesalahan iki.

• mysql.proc Iki minangka tabel sistem ing 5.1 sing nyathet informasi babagan prosedur utawa fungsi sing disimpen.

Carane ndandani bebaya: kesalahan Database Column count mysql.proc salah?

Ing ngisor iki yaikuChen Weiliangsolusi didokumentasikan.

Langkah 1:Praktek sing aman yaiku mbucal utawa serep kadhemen dhisik:

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

• Mangga ganti "123456" ing ndhuwur dadi sandhi root MySQL sampeyan.

Langkah 2:nggunakake ing ngisor ikimysql_upgrade printah kanggo mutusake masalah

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

Ing ngisor iki proses operasi demonstrasi 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]#

Ana luwih akeh solusi kanggo masalah database MySQL ing ngisor iki▼

Carane nganyari / upgrade kanggo MariaDB7 kanggo VestaCP / CWP / CentOS 10.10.2?

Tutorial iki bakal nuntun sampeyan babagan carane nganyarke / nginstal MariaDB menyang versi Mariadb 7 paling anyar ing Centos 10.10.2.Tutorial iki uga bisa digunakake karo CWP lan VestaCP utawa panel kontrol server VPS liyane sing kompatibel. MariaDB 10.10.2 stabil banget saiki ...

Kepiye carane ndandani tema WordPress {{ora dingerteni}} masalah oembed_cache?

Kepiye carane topik wiwitan ngrampungake {{ora dingerteni}} oembed_cache?Ana wong media anyar sing nembe sinau nggawe situs web WordPress lan nggunakake tema robin begin.Ditemokake {{ora dingerteni}}, kesalahan oembed_cache Nalika phpMyAdmin mriksa database MySQL, ditemokake yen...

kesalahan tabel data mysqld ditandhani minangka tabrakan lan pungkasan (otomatis?) solusi ndandani

kesalahan tabel data mysqld ditandhani minangka tabrakan lan pungkasan (otomatis?) solusi ndandani Artikel iki bakal introduce sampeyan kesalahan nalika kita ndandani tabel: Tabel \'./db_name/table_name\' ditandhani minangka tabrakan lan pungkasan ...

MySQL Pènget: Ditemokake baris ngendi auto_increment colum

Yen administrator situs web e-commerce duwe ijin sing cukup, database MySQL bisa dikelola liwat panel kontrol database phpMyAdmin.Pangopènan tabel "analisis" utawa "mriksa" bisa ditindakake ing basis data WordPress nalika ana kesalahan ing basis data.Nanging mungkin banjur ...