Nzira yekuvandudza/kusimudzira kuMariaDB7 yeVestaCP/CWP/CentOS 10.10.2?

Muchidzidzo ichi chinokuratidza kuti ungaita seicents 7, simudza/isa MariaDB kune yazvino Mariadb10.10.2 vhezheni.

• Ichi chidzidzo chinoshandawo kuCWP uyeVestaCPkana chero imwe inoenderana VPS server control panel.

MariaDB 10.10.2 ikozvino yakagadzikana uye akawanda maficha akawedzerwa nekuvandudzwa mukuburitswa uku.

• UnogonahereTarisa rondedzero yezvese shanduko.

takashandisaWordPress, Joomla, xenforo, IPS Forum uye zvimwe zvinotsamira pazviriMySQL Manyorero eDB's PHP anotarisa MariaDB 10.10.2, saka hazvina njodzi kukwidziridza kune iyi vhezheni.

Chii chinonzi MariaDB?

Tsanangudzo pfupi nezve MariaDB:

• MariaDB yakagadzirirwa kuveMySQLmutsivi wakananga.
• Iine zvimwe zvinhu: injini yekuchengetera nyowani, tsikidzi shoma uye kuita zvirinani.
• MariaDB yakagadziridzwa nevakawanda vevagadziri veMySQL avo vava kushandira MariaDB Foundation uye MariaDB Corporation, pamwe nevakawanda munharaunda.

Kuti uvandudze, tevera matanho ari nyore aya kuti ukwidziridze kune yazvino vhezheni.

Danho 1: Delete MariaDB yekare vhezheni

• Dzima iyo yekare vhezheni yeMariaDB, yakadai se: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Usati waisa, zvinokurudzirwa kuti utange wadzosera kumashureMySQL database.

Chekutanga, chengetedza mamiriro ako ezvino my.cnf▼

cp /etc/my.cnf /etc/my.cnf.bak

• Iye zvino tinoda kubvisa yazvino vhezheni ye mariadb 7 yakaiswa pacentos 5.5:

YeMariaDB 5.5 ▼

service mariadb stop / service mysql stop
rpm -e --nodeps galera
yum remove mariadb mariadb-server

• Panguva ino MariaDB 5.5 ichabviswa zvachose, asi dhatabhesi haizobviswa, usanetseka.

Kune shanduro dziri pamusoro peMariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

service mysql stop 
rpm -e --nodeps galera
yum remove MariaDB-server MariaDB-client

• Panguva ino, MariaDB 10.0/10.1/10.2/10.3 ichabviswa zvachose, asi dhatabhesi haizodzimwa, usanetseka.

Nhanho yechipiri: Isa MariaDB 2

• Kubva kuMariaDB 5.5/10.0/10.1/10.2/10.3 shanduro, install/update kuMariaDB 10.10.2.

Isa Mariadb 10.10.2 official repo ▼

yum install nano epel-release -y

Iye zvino gadzirisa / gadzira iyo Repo faira/etc/yum.repos.d

Kana paine kudzima kana backup iripo repo mafaera, ita shuwa kuti hauna mamwe eMariaDB repository mafaera ▼

mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak
nano /etc/yum.repos.d/mariadb.repo

Wobva waisa zvinotevera, uye chengeta▼

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Mushure mezvo tichaisa Mariadb 10.10.2 ▼

yum clean all
yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
yum update -y

Dzorera my.cnf faira ▼

rm -rf /etc/my.cnf
cp /etc/my.cnf.bak /etc/my.cnf

Wobva waita kuti Mariadb atange, wotanga sevhisi:

systemctl enable mariadb
service mysql start

Nhanho 3: Simudzira dhatabhesi iripo

Mushure mekuisa, tinoda kukwidziridza dhatabhesi iripo nemurairo unotevera ▼

mysql_upgrade

• Kana pasina chimwe chinhu, wabudirira kukwidziridza MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kune yazvino vhezheni yeMariaDB 10.10.2.

Kana uri kunyora murairo mysql_upgrade Paunenge uchivandudza dhatabhesi, inotevera mhosho meseji inooneka ▼

[root@ ~]# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed

Ndapota shandisa zvinoteveramysql_upgrade raira kugadzirisa ▼

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

• Ndokumbirawo uchinje zviri pamusoro "123456" kune yako MySQL kana Mariadb dhatabhesi midzi password.

Chekupedzisira, unogona kusimbisa iyo MySQL kana Mariadb dhatabhesi vhezheni nekumhanyisa uyu murairo pamusoro peSSH kubva kune terminal▼

mysql -V

Kuchenjerera

Kana yako MariaDB dhatabhesi ine yakafanana meseji yekukanganisa▼

警告：数据库错误 Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50560, now running 100406. Please use mysql_upgrade to fix this error 查询 SHOW FUNCTION STATUS

Kuti uwane mhinduro kuMariaDB dhatabhesi kukanganisa, ndapota tinya chinongedzo chiri pazasi kuti uone▼

Gadzirisa yambiro: mhosho yedatabase Column count ye mysql.proc haina kururama.

Muchokwadi, kana ukashandisa phpMyAdmin, haugone kuwana chikanganiso chiripi dambudziko?Dambudziko nderekuti wakakwidziridza iyo MariaDB kana MySQL database vhezheni.Mushure mekusimudzira iyo MariaDB kana MySQL dhatabhesi vhezheni, iyo data data haina kupedzwa uchishandisa mysql_upgrade command...