Me pehea te whakahou / whakahou ki a MariaDB7 mo VestaCP / CWP / CentOS 10.10.2?

I tenei akoranga ka arahi koe me peheaNga pokapū 7, whakahou / whakauru MariaDB ki te putanga hou o Mariadb10.10.2.

• Ka pa ano tenei akoranga ki te CWP meVestaCPtetahi atu paewhiri mana tūmau VPS hototahi ranei.

Ko MariaDB 10.10.2 kua tino pumau inaianei, he maha nga ahuatanga kua taapirihia me te whakapai ake i tenei tukunga.

• Ka taea e koekoneiTirohia te rarangi o nga huringa katoa.

kua whakamahia e matouWordPress, Joomla, xenforo, Huinga IPS me etahi o nga whakawhirinakitanga e whakawhirinaki ana ki rungaMySQL Ko te tuhinga PHP a te DB e arowhai ana mo MariaDB 10.10.2, no reira he pai te whakapai ake ki tenei putanga.

He aha te MariaDB?

He korero poto mo MariaDB:

• I hangaia a MariaDB kiMySQLwhakakapi tika.
• He maha atu nga waahanga: miihini rokiroki hou, he iti ake nga pepeke me te pai ake o te mahi.
• I whakawhanakehia a MariaDB e te maha o nga kaiwhakawhanake taketake a MySQL, e mahi ana inaianei mo te MariaDB Foundation me MariaDB Corporation, me te tini o te hapori.

Hei whakapai ake, whai i enei mahi ngawari ki te whakahou ki te putanga hou.

Hipanga 1: Mukua MariaDB putanga tawhito

• Mukua te putanga tawhito o MariaDB, penei: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

I mua i te tāutanga, e tūtohu ana kia pūrua koe i te tuatahipātengi raraunga MySQL.

Tuatahi, pūrua tō whirihoranga my.cnf o nāianei▼

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

• Inaianei me tango e tatou te putanga o naianei o mariadb 7 kua whakauruhia ki runga centos 5.5:

Mo MariaDB 5.5 ▼

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

• I tenei wa ka tangohia katoatia a MariaDB 5.5, engari kaore e tangohia te papaa raraunga, kaua e manukanuka.

Mo nga putanga i runga ake i te MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• I tenei wa, ka whakakorea katoatia a MariaDB 10.0/10.1/10.2/10.3, engari kaore e whakakorehia te paataka, kaua e manukanuka.

Hipanga 2: Tāuta MariaDB 10.10.2

• Mai i nga putanga MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3, whakauru / whakahou ki a MariaDB 10.10.2.

Tāutahia Mariadb 10.10.2 repo mana ▼

yum install nano epel-release -y

Inaianei whakatika/hangatia te konae Repo/etc/yum.repos.d

Mena kei te mukua, kei te taapiri ranei nga konae repo, me mohio kaore koe i etahi atu konae penapena MariaDB ▼

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

Na ka whakapiri i nga mea e whai ake nei, ka tiakina▼

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

I muri i tera ka whakauruhia e matou a Mariadb 10.10.2 ▼

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

Whakaora i taku.cnf kōnae ▼

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

Na, whakahohe a Mariadb ki te whakaoho, ka tiimata te ratonga:

systemctl enable mariadb
service mysql start

Hipanga 3: Whakapai ake te pātengi raraunga o nāianei

Whai muri i te whakaurunga, me whakahou ake i te paataka raraunga o naianei ma te whakahau e whai ake nei ▼

mysql_upgrade

• Mena kaore he mea ke atu, kua pai te whakapai ake i a MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 ki te putanga hou o MariaDB 10.10.2.

Mena kei te pato koe i te whakahau mysql_upgrade I te wa e whakapai ake ana i te papaunga raraunga, ka puta te karere hapa e whai ake nei ▼

[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

Tena koa whakamahia nga mea e whai ake neimysql_upgrade whakahau ki te whakatika ▼

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

• Tena koa hurihia te "123456" i runga ake nei ki to kupuhipa pakiaka papaa raraunga MySQL, Mariadb ranei.

Ka mutu, ka taea e koe te whakau i te putanga raraunga MySQL, Mariadb ranei ma te whakahaere i tenei whakahau ki runga SSH mai i te tauranga▼

mysql -V

Nga Whakatakarotanga

Mēnā he karere hapa rite tō pātengi raraunga MariaDB▼

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

Mo nga otinga ki nga hapa papaa raraunga MariaDB, paatohia te hono i raro nei hei tiro▼

Whakaotihia te whakatupato: hapa raraunga Kei te he te tatau o te pou o mysql.proc.

Inaa, ki te whakamahi koe i te phpMyAdmin, kaore e kitea te hapa kei hea te raru?Ko te raru na te mea kua whakahoutia e koe te putanga papaa raraunga MariaDB, MySQL ranei.I muri i te whakahou i te putanga papaaarangi MariaDB, MySQL ranei, kaore i oti nga hanganga raraunga ma te whakamahi i te whakahau mysql_upgrade...