Me pehea te whakahou / whakahou i te VestaCP / CWP / CentOS 7 ki te putanga hou o MariaDB?

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

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

Ko te putanga hou o MariaDB kua tino pumau, he maha nga waahanga 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 DB e arowhai ana mo te putanga hou o MariaDB, 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āutahia te putanga hou o MariaDB

• Mai i nga putanga MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3, whakauru / whakahou ki te putanga hou o MariaDB.

Tāutahia te putanga hou o Mariadb 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/11.5.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

• Ko 11.5.1 te tau putanga hou ina whakahoutia tenei tuhinga.
• Ki te tiki i te tau putanga hou, tirohia koa:http://yum.mariadb.org/

I muri i tera ka whakauruhia e matou te putanga hou o Mariadb▼

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 ohorere ka puta, kua pai te whakapai ake i a MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 ki te putanga hou o MariaDB.

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▼

🔗Whakaoti whakatupato: Hapa Raraunga Raraunga Kei te he te tatau o nga pou o mysql.proc.