Indlela yokuhlaziya / ukuphuculwa kwe-MariaDB7 yeVestaCP/CWP/CentOS 10.10.2?

Kule tutorial iya kukukhokela ukuba wenze njaniIisenti 7, phucula / ufake i-MariaDB kuguqulelo lwamva nje lwe-Mariadb10.10.2.

• Esi sifundo sisebenza nakwi-CWP kunyeVestaCPokanye nayiphi na enye ipaneli yokulawula iseva yeVPS ehambelanayo.

I-MariaDB 10.10.2 ngoku izinzile kwaye ezininzi iimpawu zongezwa kwaye ziphuculwe kolu kukhululwa.

• UngaAphaJonga uluhlu lwalo lonke utshintsho.

sisebenziseWordPress, Joomla, xenforo, IPS Forum kunye nabanye abaxhomekeke kuyoMySQL Umbhalo we-DB we-PHP ujonga i-MariaDB 10.10.2, ngoko ke kukhuselekile ukunyusela kolu guqulelo.

Yintoni uMariaDB?

Inkcazo emfutshane malunga noMariaDB:

• I-MariaDB yenzelwe ukubaMySQLindawo ethe ngqo.
• Ngeempawu ezingakumbi: injini entsha yokugcina, iibhugi ezimbalwa kunye nokusebenza ngcono.
• I-MariaDB yaphuhliswa ngabaninzi babaphuhlisi bokuqala be-MySQL, ngoku basebenzela i-MariaDB Foundation kunye ne-MariaDB Corporation, kunye nabaninzi kuluntu.

Ukuphucula, landela la manyathelo alula ukunyusela kwinguqulelo yamva nje.

Inyathelo 1: Cima inguqulelo yakudala kaMariaDB

• Cima uhlobo oludala lweMariaDB, olunje: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Phambi kokufaka, kuyacetyiswa ukuba wenze i-backup kuqalaMySQL database,

Okokuqala, gcina i-my.cnf yakho yangoku yoqwalaselo▼

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

• Ngoku kufuneka sisuse inguqulelo yangoku ye-mariadb 7 efakwe kwi-centos 5.5:

KuMariaDB 5.5 ▼

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

• Ngeli xesha i-MariaDB 5.5 iya kususwa ngokupheleleyo, kodwa i-database ayiyi kususwa, ungakhathazeki.

Kwiinguqulelo ezingentla kuMariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Ngeli xesha, i-MariaDB 10.0/10.1/10.2/10.3 iya kususwa ngokupheleleyo, kodwa i-database ayiyi kususwa, ungakhathazeki.

Inyathelo 2: Faka i-MariaDB 10.10.2

• Ukusuka ku-MariaDB 5.5/10.0/10.1/10.2/10.3 iinguqulelo, faka/uhlaziywe kuMariaDB 10.10.2.

Faka i-Mariadb 10.10.2 irepo esemthethweni ▼

yum install nano epel-release -y

Ngoku hlela/yenza ifayile yeRepo/etc/yum.repos.d

Ukuba kukho ukucima okanye ugcino lweefayile zerepo ezikhoyo, qiniseka ukuba awunazo ezinye iifayile zokugcina zikaMariaDB ▼

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

Emva koko coma oku kulandelayo, kwaye ugcine▼

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

Emva koko siya kufaka i-Mariadb 10.10.2 ▼

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

Fumana ifayile yam.cnf ▼

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

Emva koko, vula uMariadb ukuze uqalise, kwaye uqalise inkonzo:

systemctl enable mariadb
service mysql start

Inyathelo 3: Phucula isiseko sedatha yangoku

Emva kokufakela, kufuneka siphucule isiseko sedatha ngalo myalelo ulandelayo ▼

mysql_upgrade

• Ukuba akukho nto, uye waphucula ngempumelelo i-MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kwinguqulo yakamuva ye-MariaDB 10.10.2.

Ukuba uchwetheza umyalelo mysql_upgrade Xa uphucula isiseko sedatha, lo myalezo wemposiso ulandelayo uvela ▼

[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

Nceda usebenzise oku kulandelayomysql_upgrade umyalelo wokulungisa ▼

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

• Nceda utshintshe okungasentla "123456" kwi-MySQL okanye i-Mariadb yesiseko segama lokugqitha.

Okokugqibela, ungaqinisekisa iMySQL okanye iMariadb inguqulelo yedatabase ngokusebenzisa lo myalelo kwi-terminal SSH ▼

mysql -V

Izilumkiso

Ukuba idatabase yakho yeMariaDB inomyalezo wemposiso efanayo▼

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

Ngezisombululo kwiimpazamo zedatha ye-MariaDB, nceda ucofe ikhonkco elingezantsi ukujonga▼

Sombulula isilumkiso: impazamo yedatabase Ubalo lweKholam ye-mysql.proc ayilunganga.

Ngapha koko, ukuba usebenzisa iphpMyAdmin, awufumani mpazamo apho ingxaki?Ingxaki kukuba uphucule i-MariaDB okanye i-MySQL database version.Emva kokuphucula i-MariaDB okanye i-MySQL yedatha yedatha, izakhiwo zedatha azigqitywanga ngokusebenzisa umyalelo we-mysql_upgrade...