Xalli digniinta: Khaladka kaydka xogta tirinta tixda mysql.proc waa khalad.

Dhab ahaantii, haddii aad isticmaashophpMyAdmin, ma heli kartid qaladka halkee dhibku ka jiraa?

• Dhibaatadu waa sababtoo ah waxaad cusboonaysiisay MariaDB amadatabase MySQLNooca.
• Kor u qaad MariaDB amaMySQLKa dib nooca xogta, qaab dhismeedka xogta lama isticmaalomysql_upgradeamar si loo dhamaystiro cusboonaysiinta.
• Ka dib, inta lagu jiro hawlgalinta xogta MySQL, fariimaha khaladka ah waa la soo bandhigi karaa.

plugin WordPress ahIntii lagu gudajiray habka kaydinta tooska ah, khaladkan soo socda ayaa dhacay ▼

Digniin: Cilad Database Tirooyinka mysql.proc waa khalad

• mysql.proc Kani waa shaxda nidaamka ee 5.1 kaas oo diiwaangeliya macluumaadka ku saabsan hababka ama hawlaha la kaydiyay.

Sida loo hagaajiyo digniinta: Khaladka database-ka tirinta tixda mysql.proc waa khalad?

Waxyaabaha soo socdaa waaChen Weiliangxal la diiwaangeliyey.

Tallaabada 1:Dhaqanka badbaadada leh waa in marka hore la shubo ama la qaboojiyo:

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

• Fadlan u beddel kan kore "123456" eraygaaga MySQL ee xididka ah.

Tallaabada 2:isticmaal kuwan soo socdamysql_upgrade amar lagu xaliyo

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

Kuwa soo socdaa waa habka hawlgalka bandhiga 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]#

Waxaa jira xalal badan oo loogu talagalay dhibaatooyinka xogta MySQL ee hoose▼

Sida loo cusboonaysiiyo/kor loogu qaado MariaDB7 ee VestaCP/CWP/CentOS 10.10.2?

Tababarkan ayaa ku hagi doona sida loo cusboonaysiiyo/ku rakibo MariaDB kii ugu dambeeyay ee Mariadb 7 ee Centos 10.10.2.Tababarkani waxa kale oo uu la shaqeeyaa CWP iyo VestaCP ama guddi kasta oo kale oo VPS ah oo kontorool ah oo ku habboon. MariaDB 10.10.2 waa mid aad u deggan hadda ...

Sida loo hagaajiyo mawduuca WordPress {{unknown}} oembed_cache arin?

Sidee buu u xalliyaa mawduuca bilawga ah {{aan la garanayn}} oembed_cache?Waxaa jira dad cusub oo warbaahin ah oo hadda bartay inay dhisaan degel WordPress ah oo ay isticmaalaan mawduuca bilawga Robin.La helay {{aan la aqoon}}, khaladaadka oembed_cache Markii phpMyAdmin hubisay xogta MySQL, waxaa la ogaaday in...

Khaladka miiska xogta mysqld waxa loo calaamadeeyay sidii shil dhacay iyo kii u dambeeyay (otomaatig ah?) xalinta dayactirka

qaladka miiska xogta mysqld waxa loo calaamadeeyay sidii shil iyo kii u danbeeyay (otomaatig ah?) xalinta dayactirka Maqaalkani waxa uu ku bari doonaa khaladka marka aanu hagaajino miiska

Digniin MySQL: La helay safka halka tiirka auto_increment

Haddii maamulaha shabakadda e-commerce uu haysto oggolaansho ku filan, xogta MySQL waxaa lagu sii hayn karaa guddiga kontoroolka xogta phpMyAdmin.Dayactirka miiska "falanqaynta" ama "checks" ayaa lagu samayn karaa kaydka WordPress marka khaladaadku ka dhaco kaydka.Laakiin laga yaabee markaa...