Indlela yokuhlaziya/ukuphucula iVestaCP/CWP/CentOS 7 kwinguqulelo yamva nje yeMariaDB?

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

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

Inguqulelo yamva nje ye-MariaDB ngoku izinzile kwaye izinto ezininzi zongeziwe kwaye ziphuculwe kolu kukhutshwa.

UngaAphaJonga uluhlu lwalo lonke utshintsho.

sisebenziseWordPress, Joomla, xenforo, IPS Forum kunye nabanye abaxhomekeke kuyoMySQL Isikripthi se-PHP yeDB sijonga inguqulelo ye-MariaDB yamva nje, 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 inguqulelo yamva nje ye-MariaDB

• Ukusuka ku-MariaDB 5.5/10.0/10.1/10.2/10.3 iinguqulelo, faka/uhlaziywe kwi-MariaDB inguqulelo yamva nje.

Faka inguqulelo yamva nje ye-Mariadb esemthethweni repo ▼

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

• 11.5.1 yinombolo yenguqulo yakutshanje xa eli nqaku lihlaziywa.
• Ukufumana inombolo yenguqulelo yamva nje, nceda undwendwele:http://yum.mariadb.org/

Emva koko siya kufaka inguqulelo yamva nje ye-Mariadb▼

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 ingalindelekanga eyenzekayo, uphucule ngempumelelo i-MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kwinguqulelo yamva nje ye-MariaDB.

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.