Momwe mungasinthire/kukwezera ku MariaDB7 kwa VestaCP/CWP/CentOS 10.10.2?

Mu phunziro ili adzakutsogolerani mmeneCentos 7, kwezani / kukhazikitsa MariaDB ku mtundu waposachedwa wa Mariadb10.10.2.

• Maphunzirowa amagwiranso ntchito ku CWP ndiVestaCPkapena gulu lina lililonse logwirizana la VPS seva.

MariaDB 10.10.2 tsopano ndiyokhazikika kwambiri ndipo zinthu zambiri zawonjezedwa ndikuwongoleredwa pakutulutsidwaku.

• MuthaPanoOnani mndandanda wazosintha zonse.

tagwiritsa ntchitoWordPress, Joomla, xenforo, IPS Forum ndi zina zomwe zimadaliraMySQL DB's PHP script imayang'ana MariaDB 10.10.2, kotero ndikwabwino kukweza mtundu uwu.

MariaDB ndi chiyani?

Kufotokozera mwachidule za MariaDB:

• MariaDB idapangidwa kutiMySQLcholoweza mmalo mwachindunji.
• Ndi zina zambiri: injini yosungirako zatsopano, nsikidzi zochepa komanso magwiridwe antchito abwino.
• MariaDB idapangidwa ndi ambiri omwe adayambitsa MySQL omwe tsopano akugwira ntchito ku MariaDB Foundation ndi MariaDB Corporation, komanso ambiri ammudzi.

Kuti mukweze bwino, tsatirani njira zosavuta izi kuti mukweze ku mtundu waposachedwa.

Khwerero 1: Chotsani mtundu wakale wa MariaDB

• Chotsani mtundu wakale wa MariaDB, monga: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Musanayike, ndi bwino kuti mubwezeretse kayeMySQL database.

Choyamba, sungani kasinthidwe ka my.cnf ▼

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

• Tsopano tikufunika kuchotsa mtundu waposachedwa wa mariadb 7 woyikidwa pa centos 5.5:

Kwa MariaDB 5.5 ▼

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

• Panthawiyi MariaDB 5.5 idzachotsedwa kwathunthu, koma nkhokwe sidzachotsedwa, musadandaule.

Zomasulira pamwamba pa MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Panthawiyi, MariaDB 10.0 / 10.1 / 10.2 / 10.3 idzachotsedwa kwathunthu, koma databaseyo sidzachotsedwa, musadandaule.

Khwerero 2: Ikani MariaDB 10.10.2

• Kuchokera ku matembenuzidwe a MariaDB 5.5/10.0/10.1/10.2/10.3, ikani/sinthani ku MariaDB 10.10.2.

Ikani Mariadb 10.10.2 repo yovomerezeka ▼

yum install nano epel-release -y

Tsopano sinthani / pangani fayilo ya Repo/etc/yum.repos.d

Ngati pali zochotsa kapena zosunga zobwezeretsera zomwe zilipo kale, onetsetsani kuti mulibe mafayilo ena osungira a MariaDB ▼

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

Kenako matani zotsatirazi, ndikusunga▼

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

Pambuyo pake tidzakhazikitsa Mariadb 10.10.2 ▼

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

Bwezerani fayilo ya my.cnf ▼

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

Kenako, yambitsani Mariadb kuti ayambe, ndikuyamba ntchito:

systemctl enable mariadb
service mysql start

Khwerero 3: Sinthani nkhokwe yapano

Pambuyo kukhazikitsa, tiyenera kukweza nkhokwe yapano ndi lamulo ili ▼

mysql_upgrade

• Ngati palibe china, mwakweza bwino MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 ku mtundu waposachedwa wa MariaDB 10.10.2.

Ngati mukulemba lamulo mysql_upgrade Mukakweza nkhokwe, uthenga wolakwika wotsatirawu umawonekera ▼

[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

Chonde gwiritsani ntchito zotsatirazimysql_upgrade lamula kukonza ▼

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

• Chonde sinthani "123456" pamwambapa kukhala mawu anu achinsinsi a MySQL kapena Mariadb database.

Pomaliza, mutha kutsimikizira mtundu wa database ya MySQL kapena Mariadb poyendetsa lamuloli kuchokera pa terminal SSH ▼

mysql -V

Njira zopewera

Ngati database yanu ya MariaDB ili ndi uthenga wolakwika womwewo▼

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

Kuti mupeze mayankho ku zolakwika za database ya MariaDB, chonde dinani ulalo womwe uli pansipa kuti muwone▼

Konzani chenjezo: cholakwika cha database Kuwerengera kwa mysql.proc ndikolakwika.

M'malo mwake, ngati mugwiritsa ntchito phpMyAdmin, simungapeze cholakwika chomwe chili vuto?Vuto ndi chifukwa mwakweza mtundu wa database ya MariaDB kapena MySQL.Pambuyo pokweza mtundu wa database ya MariaDB kapena MySQL, ma data sanamalize kugwiritsa ntchito mysql_upgrade command...