Momwe mungasinthire / kukweza VestaCP/CWP/CentOS 7 kukhala mtundu waposachedwa wa MariaDB?

Phunziroli lidzakutsogolerani momwe mungasinthire/kukhazikitsa MariaDB ku mtundu waposachedwa pa CentOS 7.

Phunziroli likugwiranso ntchito pa CWP ndi VestaCP kapena gulu lina lililonse lolamulira seva ya VPS.

Mtundu waposachedwa wa MariaDB tsopano ndiwokhazikika kwambiri ndipo zinthu zambiri zawonjezedwa ndikuwongoleredwa pakutulutsidwaku.

Mutha kuwona mndandanda wa zosintha zonse apa .

Tayang'ana mtundu waposachedwa wa MariaDB pogwiritsa ntchito WordPress , Joomla, xenforo, forum ya IPS, ndi zolemba zina za PHP zomwe zimadalira MySQL DB, kotero ndikotetezeka kusintha kuti ukhale 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

Musanayambe kukhazikitsa, ndi bwino kuti muyambe mwasunga kaye database yanu ya MySQL.

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 mtundu waposachedwa wa MariaDB

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

Ikani mtundu waposachedwa kwambiri wa Mariadb official repo ▼

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

• 11.5.1 ndiye nambala yaposachedwa pomwe nkhaniyi isinthidwa.
• Kuti mupeze nambala ya mtundu waposachedwa, chonde pitani:http://yum.mariadb.org/

Pambuyo pake tidzayika mtundu waposachedwa wa Mariadb▼

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 chomwe chingachitike mwadzidzidzi, mwakweza bwino MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kukhala mtundu waposachedwa wa MariaDB.

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: Zolakwika mu database Kuwerengera kwa mysql.proc ndikolakwika.