Maitiro ekugadzirisa / kusimudzira VestaCP/CWP/CentOS 7 kune yazvino vhezheni yeMariaDB?

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

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

Iyo yazvino vhezheni yeMariaDB ikozvino yakagadzikana uye akawanda maficha akawedzerwa uye akagadziridzwa mukuburitswa uku.

UnogonahereTarisa rondedzero yezvese shanduko.

takashandisaWordPress, Joomla, xenforo, IPS Forum uye zvimwe zvinotsamira pazviriMySQL DB's PHP script inotarisa yeazvino MariaDB vhezheni, saka zvakachengeteka 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.

Step 2: Isa yazvino vhezheni yeMariaDB

• Kubva kuMariaDB 5.5/10.0/10.1/10.2/10.3 shanduro, isa/gadziridza kuMariaDB yazvino vhezheni.

Isa iyo yazvino vhezheni yeMariadb 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/11.5.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

• 11.5.1 ndiyo yazvino vhezheni nhamba kana chinyorwa ichi chagadziridzwa.
• Kuti uwane nhamba yeshanduro yazvino, ndapota shanya:http://yum.mariadb.org/

Mushure meizvozvo tichaisa yazvino vhezheni yeMariadb▼

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 chaungatarisira chikaitika, wabudirira kukwidziridza MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kune yazvino vhezheni yeMariaDB.

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: Database kukanganisa Column count ye mysql.proc haina kururama.