Mokhoa oa ho ntlafatsa / ho ntlafatsa ho MariaDB7 bakeng sa VestaCP/CWP/CentOS 10.10.2?

Thutong ena e tla u tataisa hore na u kaLilemo 7, ntlafatsa/kenya MariaDB ho mofuta oa morao-rao oa Mariadb10.10.2.

• Thupelo ena e sebetsa le ho CWP leVestaCPkapa phanele efe kapa efe e lumellanang ea taolo ea seva ea VPS.

MariaDB 10.10.2 e se e tsitsitse haholo mme likarolo tse ngata li kentsoe le ho ntlafatsoa tokollong ena.

• u ka khonaMonaSheba lenane la liphetoho tsohle.

re sebelitseWordpress, Joomla, xenforo, IPS Forum le tse ling tse itšetlehileng ka tsonaMySQL DB's PHP script e hlahloba MariaDB 10.10.2, kahoo ho bolokehile ho ntlafatsa mofuta ona.

MariaDB ke eng?

Tlhaloso e khutšoanyane ka MariaDB:

• MariaDB e etselitsoe hoMySQLkemedi e tobileng.
• E na le likarolo tse ling: enjine e ncha ea polokelo, liphoso tse fokolang le ts'ebetso e ntle.
• MariaDB e ntlafalitsoe ke bahlahisi ba bangata ba MySQL, bao hajoale ba sebeletsang MariaDB Foundation le MariaDB Corporation, hammoho le ba bangata sechabeng.

Ho ntlafatsa, latela mehato ena e bonolo ho nyollela besheneng ea morao-rao.

Hata 1: Hlakola mofuta oa khale oa MariaDB

• Hlakola mofuta oa khale oa MariaDB, joalo ka: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Pele o kenya, ho kgothaletswa hore o etse bekapo peleMySQL database.

Taba ea pele, boloka tlhophiso ea hau ea hajoale ea my.cnf▼

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

• Joale re hloka ho tlosa mofuta oa hajoale oa mariadb 7 o kentsoeng ho centos 5.5:

Bakeng sa MariaDB 5.5 ▼

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

• Ka nako ena MariaDB 5.5 e tla tlosoa ka ho feletseng, empa database e ke ke ea tlosoa, u se ke ua tšoenyeha.

Bakeng sa liphetolelo tse ka holimo ho MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Ka nako ena, MariaDB 10.0/10.1/10.2/10.3 e tla hlakoloa ka ho feletseng, empa database e ke ke ea hlakoloa, u se ke ua tšoenyeha.

Mohato oa 2: Kenya MariaDB 10.10.2

• Ho tloha ho MariaDB 5.5/10.0/10.1/10.2/10.3 liphetolelo, kenya / ntlafatsa ho MariaDB 10.10.2.

Kenya repo ea semmuso ea Mariadb 10.10.2 ▼

yum install nano epel-release -y

Joale hlophisa/etsa faele ea Repo/etc/yum.repos.d

Haeba ho na le ho hlakola kapa ho boloka lifaele tsa repo tse teng, etsa bonnete ba hore ha u na lifaele tse ling tsa polokelo ea MariaDB ▼

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

Ebe u beha se latelang, 'me u boloke▼

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

Ka mor'a moo re tla kenya Mariadb 10.10.2 ▼

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

Fumana faele ea my.cnf ▼

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

Ebe, kenya Mariadb ho qala, 'me u qale tšebeletso:

systemctl enable mariadb
service mysql start

Mohato oa 3: Ntlafatsa database ea hajoale

Kamora ho kenya, re hloka ho ntlafatsa database ea hajoale ka taelo e latelang ▼

mysql_upgrade

• Haeba ho se letho le leng, u atlehile ho ntlafatsa MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 ho phetolelo ea morao-rao ea MariaDB 10.10.2.

Haeba u thaepa taelo mysql_upgrade Ha u ntlafatsa database, molaetsa o latelang oa phoso o hlaha ▼

[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

Ka kopo sebelisa tse latelangmysql_upgrade taelo ea ho lokisa ▼

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

• Ka kopo fetola "123456" e kaholimo ho password ea hau ea database ea MySQL kapa Mariadb.

Qetellong, o ka netefatsa mofuta oa database oa MySQL kapa Mariadb ka ho tsamaisa taelo ena holim'a SSH ho tsoa ho terminal▼

mysql -V

Litlhokomelo

Haeba database ea hau ea MariaDB e na le molaetsa o tšoanang oa phoso▼

警告：数据库错误 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

Bakeng sa tharollo ea liphoso tsa database tsa MariaDB, ka kopo, tobetsa sehokelo se ka tlase ho sheba▼

Rarolla temoso: phoso ea database Palo ea Kholomo ea mysql.proc e fosahetse.

Ha e le hantle, haeba u sebelisa phpMyAdmin, u ke ke ua fumana phoso moo bothata bo leng teng?Bothata ke hobane u ntlafalitse mofuta oa database oa MariaDB kapa MySQL.Kamora ho ntlafatsa mofuta oa database oa MariaDB kapa MySQL, meaho ea data ha e e-so qete ho sebelisa mysql_upgrade command...