Pehea e hoʻonui ai / hoʻomaikaʻi iā MariaDB7 no VestaCP / CWP / CentOS 10.10.2?

Ma kēia kumu aʻo e alakaʻi iā ʻoe pehea eNā keneta 7, hoʻonui / hoʻokomo iā MariaDB i ka mana hou loa o Mariadb10.10.2.

• Pili kēia kumu aʻo iā CWP aʻO VestaCPa i ʻole kekahi papa hoʻomalu kikowaena VPS kūpono.

Paʻa loa ʻo MariaDB 10.10.2 i kēia manawa a ua nui nā hiʻohiʻona i hoʻohui ʻia a hoʻomaikaʻi ʻia i kēia hoʻokuʻu.

• hiki iā ʻoeEiaE nānā i ka papa inoa o nā hoʻololi a pau.

ua hoʻohana mākouWordPress, Joomla, xenforo, IPS Forum a me kekahi mau hilinaʻi e hilinaʻi neiMySQL Nānā ka palapala PHP a ka DB no MariaDB 10.10.2, no laila palekana ke hoʻonui i kēia mana.

He aha ka MariaDB?

ʻO kahi wehewehe pōkole e pili ana iā MariaDB:

• Hoʻolālā ʻia ʻo MariaDB eMySQLpani pololei.
• Me nā hiʻohiʻona hou aʻe: ʻenekini mālama hou, liʻiliʻi nā pōpoki a me ka hana ʻoi aku ka maikaʻi.
• Ua hoʻomohala ʻia ʻo MariaDB e ka nui o nā mea hoʻomohala kumu mua o MySQL, e hana nei no ka MariaDB Foundation a me MariaDB Corporation, a me nā mea he nui i ke kaiāulu.

No ka hoʻomaikaʻi ʻana, e hahai i kēia mau ʻanuʻu maʻalahi e hoʻonui i ka mana hou loa.

Pani 1: Holoi i ka mana kahiko o MariaDB

• Holoi i ka mana kahiko o MariaDB, e like me: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Ma mua o ka hoʻouka ʻana, pono ʻoe e hoʻihoʻi muaMySQL waihona.

ʻO ka mua, e hoʻopaʻa i kāu hoʻonohonoho my.cnf o kēia manawa▼

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

• I kēia manawa pono mākou e wehe i ka mana o kēia manawa o mariadb 7 i kau ʻia ma centos 5.5:

No MariaDB 5.5 ▼

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

• I kēia manawa e hoʻopau loa ʻia ʻo MariaDB 5.5, akā ʻaʻole e wehe ʻia ka waihona, mai hopohopo.

No nā mana ma luna o MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• I kēia manawa, e hoʻopau loa ʻia ʻo MariaDB 10.0/10.1/10.2/10.3, akā ʻaʻole e holoi ʻia ka waihona, mai hopohopo.

KaʻAnuʻu Hana 2: E hoʻouka iā MariaDB 10.10.2

• Mai MariaDB 5.5/10.0/10.1/10.2/10.3 versions, e hoʻouka/hōʻano hou iā MariaDB 10.10.2.

E hoʻouka iā Mariadb 10.10.2 repo mana ▼

yum install nano epel-release -y

I kēia manawa hoʻoponopono / hana i ka faila Repo/etc/yum.repos.d

Inā he holoi a hoʻihoʻi paha i nā faila repo i loaʻa, e hōʻoia ʻaʻole loaʻa iā ʻoe nā faila waihona MariaDB ʻē aʻe ▼

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

A laila hoʻopili i kēia, a mālama iā▼

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

Ma hope o kēlā, e hoʻokomo mākou iā Mariadb 10.10.2 ▼

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

Hoʻihoʻi i ka faila my.cnf ▼

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

A laila, hoʻāla iā Mariadb e hoʻomaka, a hoʻomaka i ka lawelawe:

systemctl enable mariadb
service mysql start

KaʻAnuʻu Hana 3: Hoʻonui i ka waihona o kēia manawa

Ma hope o ka hoʻouka ʻana, pono mākou e hoʻomaikaʻi i ka waihona o kēia manawa ma o ke kauoha aʻe ▼

mysql_upgrade

• Inā ʻaʻohe mea ʻē aʻe, ua hoʻomaikaʻi maikaʻi ʻoe iā MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 i ka mana hou loa o MariaDB 10.10.2.

Inā ʻoe e paʻi i ke kauoha mysql_upgrade Ke hoʻomaikaʻi nei i ka waihona, ʻike ʻia kēia memo hewa ▼

[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

E ʻoluʻolu e hoʻohana i kēiamysql_upgrade kauoha e hoʻoponopono ▼

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

• E ʻoluʻolu e hoʻololi i ka "123456" i luna i kāu ʻōlelo huna huna MySQL a i ʻole Mariadb database root password.

ʻO ka hope, hiki iā ʻoe ke hōʻoia i ka mana MySQL a i ʻole Mariadb database ma ka holo ʻana i kēia kauoha ma luna o SSH mai ka terminal▼

mysql -V

Pākuʻi ʻana

Inā loaʻa i kāu waihona MariaDB kahi memo hewa like▼

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

No ka hoʻonā ʻana i nā hewa waihona waihona MariaDB, e kaomi i ka loulou ma lalo nei e nānā▼

E hoʻoholo i ka ʻōlelo aʻo: hewa waihona ʻikepili Ua hewa ka helu ʻana o mysql.proc.

ʻOiaʻiʻo, inā hoʻohana ʻoe iā phpMyAdmin, ʻaʻole hiki iā ʻoe ke ʻike i ka hewa ma hea ka pilikia?ʻO ka pilikia no ka mea ua hoʻonui ʻoe i ka mana MariaDB a i ʻole MySQL database.Ma hope o ka hoʻomaikaʻi ʻana i ka mana ʻo MariaDB a i ʻole MySQL database, ʻaʻole i pau nā hale ʻikepili me ka hoʻohana ʻana i ke kauoha mysql_upgrade ...