Mokhoa oa ho ntlafatsa / ho ntlafatsa VestaCP/CWP/CentOS 7 ho mofuta oa morao-rao oa MariaDB?

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

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

Phetolelo ea morao-rao ea MariaDB 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 mofuta oa morao-rao oa MariaDB, 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.

Hata 2: Kenya mofuta oa morao-rao oa MariaDB

• Ho tloha ho MariaDB 5.5/10.0/10.1/10.2/10.3 liphetolelo, kenya/ntlafatsa ho MariaDB phetolelo ea morao-rao.

Kenya mofuta oa morao-rao oa repo ea semmuso ea Mariadb ▼

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

• 11.5.1 ke nomoro ea morao-rao ea phetolelo nakong ea ho ntlafatsa sengoloa sena.
• Ho fumana nomoro ea morao-rao, ka kopo etela:http://yum.mariadb.org/

Ka mor'a moo re tla kenya mofuta oa morao-rao oa Mariadb▼

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 neng le sa lebelloa le etsahalang, o atlehile ho ntlafatsa MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 ho mofuta oa morao-rao oa MariaDB.

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 polokelong ea boitsebiso Palo ea Kholomo ea mysql.proc e fosahetse.