Yuav hloov kho / hloov kho li cas rau MariaDB7 rau VestaCP/CWP/CentOS 10.10.2?

Hauv no nyeem yuav qhia koj yuav ua li casCentos 7, upgrade/install MariaDB mus rau qhov tseeb Mariadb10.10.2 version.

• Qhov kev qhia no kuj siv tau rau CWP thiabVestaCPlos yog lwm yam tshaj VPS server tswj vaj huam sib luag.

MariaDB 10.10.2 tam sim no ruaj khov heev thiab ntau yam nta tau ntxiv thiab txhim kho hauv qhov kev tso tawm no.

• Koj ua tauntawm noXyuas cov npe ntawm txhua qhov kev hloov pauv.

peb tau sivWordPress, Joomla, xenforo, IPS Forum thiab qee qhov kev vam khom uas nyob ntawmMySQL DB's PHP tsab ntawv txheeb xyuas MariaDB 10.10.2, yog li nws muaj kev nyab xeeb los hloov kho rau qhov version no.

MariaDB yog dab tsi?

Cov lus piav qhia luv luv txog MariaDB:

• MariaDB yog tsim los rauMySQLdirect hloov.
• Nrog ntau yam nta: tshiab cia cav, tsawg kab thiab kev ua tau zoo dua.
• MariaDB tau tsim los ntawm ntau tus MySQL thawj tus tsim tawm uas tam sim no ua haujlwm rau MariaDB Foundation thiab MariaDB Corporation, nrog rau ntau yam hauv zej zog.

Txhawm rau hloov kho, ua raws cov kauj ruam yooj yim no txhawm rau txhim kho mus rau qhov tseeb version.

Kauj ruam 1: Rho tawm MariaDB qub version

• Rho tawm cov qub version ntawm MariaDB, xws li: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Ua ntej txhim kho, nws raug nquahu kom koj rov qab ua ntejMySQL database.

Ua ntej, backup koj tam sim no my.cnf configuration ▼

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

• Tam sim no peb yuav tsum tshem tawm tam sim no version ntawm mariadb 7 ntsia ntawm centos 5.5:

Rau MariaDB 5.5 ▼

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

• Lub sijhawm no MariaDB 5.5 yuav raug tshem tawm tag nrho, tab sis cov ntaub ntawv yuav tsis raug tshem tawm, tsis txhob txhawj.

Rau cov qauv saum toj no MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Thaum lub sijhawm no, MariaDB 10.0/10.1/10.2/10.3 yuav raug tshem tawm tag nrho, tab sis cov ntaub ntawv yuav tsis raug tshem tawm, tsis txhob txhawj.

Kauj ruam 2: Nruab MariaDB 10.10.2

• Los ntawm MariaDB 5.5/10.0/10.1/10.2/10.3 versions, nruab / hloov tshiab rau MariaDB 10.10.2.

Nruab Mariadb 10.10.2 official repo ▼

yum install nano epel-release -y

Tam sim no hloov kho / tsim cov ntaub ntawv Repo/etc/yum.repos.d

Yog hais tias muaj deleted los yog backup cov ntaub ntawv repo uas twb muaj lawm, xyuas kom tseeb tias koj tsis muaj lwm yam MariaDB repository ntaub ntawv ▼

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

Tom qab ntawd muab tshuaj txhuam rau hauv qab no, thiab txuag ▼

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

Tom qab ntawd peb yuav nruab Mariadb 10.10.2 ▼

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

Rov qab my.cnf cov ntaub ntawv ▼

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

Tom qab ntawd, qhib Mariadb rau khau raj, thiab pib qhov kev pabcuam:

systemctl enable mariadb
service mysql start

Kauj ruam 3: Txhim kho cov ntaub ntawv tam sim no

Tom qab kev teeb tsa, peb yuav tsum hloov kho cov ntaub ntawv tam sim no los ntawm cov lus txib hauv qab no ▼

mysql_upgrade

• Yog tias tsis muaj dab tsi ntxiv, koj tau ua tiav kev hloov kho MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 mus rau qhov tseeb version ntawm MariaDB 10.10.2.

Yog tias koj ntaus ntawv hais kom ua mysql_upgrade Thaum hloov kho cov ntaub ntawv, cov lus yuam kev hauv qab no tshwm ▼

[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

Thov siv cov hauv qab nomysql_upgrade hais kom kho ▼

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

• Thov hloov qhov saum toj no "123456" rau koj MySQL lossis Mariadb database root password.

Thaum kawg, koj tuaj yeem paub meej tias MySQL lossis Mariadb database version los ntawm kev khiav cov lus txib no los ntawm lub davhlau ya nyob twg SSH ▼

mysql -V

Ceev faj

Yog tias koj lub database MariaDB muaj cov lus yuam kev zoo sib xws ▼

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

Rau cov kev daws teeb meem rau MariaDB database yuam kev, thov nyem qhov txuas hauv qab no mus saib ▼

daws cov lus ceeb toom: database yuam kev Kem suav ntawm mysql.proc yog lawm.

Qhov tseeb, yog tias koj siv phpMyAdmin, koj nrhiav tsis tau qhov yuam kev qhov twg yog qhov teeb meem?Qhov teeb meem yog vim tias koj tau hloov kho MariaDB lossis MySQL database version.Tom qab kho dua tshiab MariaDB lossis MySQL database version, cov ntaub ntawv cov qauv tsis tas siv mysql_upgrade hais kom ua ...