Sida loo cusboonaysiiyo/kor loogu qaado MariaDB7 ee VestaCP/CWP/CentOS 10.10.2?

Casharradan ayaa ku hagaya sida loo sameeyoCentos 7, cusboonaysii/ku rakib MariaDB una rog roga nooca ugu dambeeyay ee Mariadb10.10.2.

• Tababarkan sidoo kale wuxuu khuseeyaa CWP iyoVestaCPama wax kasta oo kale oo ku habboon kontaroolada server-ka VPS.

MariaDB 10.10.2 hadda aad bay u deggan tahay oo sifooyin badan ayaa lagu daray oo la hagaajiyay siideyntan.

• Waad awoodaa此处Hubi liiska dhammaan isbeddellada

waan isticmaalnayWordPress, Joomla, xenforo, IPS Forum iyo qaar ku tiirsanaanta oo ku xiranMySQL Qoraalka DB ee PHP wuxuu hubinayaa MariaDB 10.10.2, marka waa ammaan in loo cusboonaysiiyo noocaan.

Waa maxay MariaDB?

Sharaxaad gaaban oo ku saabsan MariaDB:

• MariaDB waxaa loogu talagalay inayMySQLbedel toos ah.
• Iyada oo leh astaamo badan: mashiinka kaydinta cusub, dhiqlaha yar iyo waxqabadka wanaagsan.
• MariaDB waxaa horumariyay qaar badan oo ka mid ah horumariyayaashii asalka ahaa ee MySQL, kuwaas oo hadda u shaqeeya MariaDB Foundation iyo MariaDB Corporation, iyo sidoo kale qaar badan oo bulshada ah.

Si aad u cusboonaysiiso, raac talaabooyinkan fudud si aad ugu cusboonaysiiso noocii ugu dambeeyay.

Tallaabada 1: Tirtir MariaDB version hore

• Tirtir nooca hore ee MariaDB, sida: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Kahor intaadan rakibin, waxaa lagugula talinayaa inaad marka hore dib u soo celisodatabase MySQL.

Marka hore, ku kaydi qaabayntaada hadda my.cnf▼

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

• Hadda waxaan u baahanahay inaan ka saarno nooca hadda ee mariadb 7 ee lagu rakibay centos 5.5:

Loogu talagalay MariaDB 5.5 ▼

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

• Halkaa marka ay marayso MariaDB 5.5 gabi ahaanba waa laga saarayaa, laakiin kaydka xogta lama saari doono, ha werwerin.

Noocyada ka sarreeya MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Halkaa marka ay marayso, MariaDB 10.0/10.1/10.2/10.3 gabi ahaanba waa la tirtiri doonaa, laakiin kaydka xogta lama tirtiri doono, ha ka welwelin.

Tallaabada 2: Ku rakib MariaDB 10.10.2

• Laga soo bilaabo MariaDB 5.5/10.0/10.1/10.2/10.3, ku rakib/cusbooneysii MariaDB 10.10.2.

Ku rakib Mariadb 10.10.2 repo rasmiga ah ▼

yum install nano epel-release -y

Hadda wax ka beddel/abuur faylka Repo/etc/yum.repos.d

Haddii ay jiraan tirtir ama kaydin faylalka kaydinta ee jira, iska hubi inaadan haysan wax kale oo kayd ah MariaDB ▼

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

Kadibna ku dheji kuwa soo socda, oo kaydi▼

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

Intaa ka dib waxaan ku rakibi doonaa Mariadb 10.10.2 ▼

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

Soo celi my.cnf faylka ▼

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

Ka dib, dhaqaaji Mariadb si aad u bilowdo, oo aad bilowdo adeegga:

systemctl enable mariadb
service mysql start

Talaabada 3: cusboonaysii xogta hadda jirta

Ka dib markii la rakibo, waxaan u baahanahay inaan cusboonaysiino xogta hadda jirta amarka soo socda ▼

mysql_upgrade

• Haddii aysan jirin wax kale, waxaad si guul leh u cusboonaysiisay MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 una cusboonaysiisay nooca ugu dambeeyay ee MariaDB 10.10.2.

Haddii aad ku qorayso amarka mysql_upgrade Marka la cusboonaysiinayo xogta xogta, fariinta khaladka ah ee soo socota ayaa soo baxaysa ▼

[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

Fadlan isticmaal kuwan soo socdamysql_upgrade amar lagu hagaajiyo ▼

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

• Fadlan u beddel kan kor ku xusan "123456" MySQL ama eraygaaga xididka xogta Mariadb.

Ugu dambeyntii, waxaad xaqiijin kartaa nooca xogta MySQL ama Mariadb adiga oo ku socodsiinaya amarkan SSH ka terminalka▼

mysql -V

Digtooni

Haddii xogtaada MariaDB ay leedahay fariin khalad ah oo la mid ah▼

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

Si loo xalliyo khaladaadka xogta MariaDB, fadlan guji xiriirka hoose si aad u aragto▼

Xalli digniinta: Khaladka kaydka xogta tirinta tixda mysql.proc waa khalad.

Dhab ahaantii, haddii aad isticmaasho phpMyAdmin, ma heli kartid qaladka halka ay dhibaatadu ka jirto?Dhibaatadu waa sababtoo ah waxaad cusboonaysiisay nooca xogta ee MariaDB ama MySQL.Ka dib markii la cusboonaysiiyay nooca database-ka ee MariaDB ama MySQL, qaab dhismeedka xogta lama dhammeeyo adeegsiga amarka mysql_upgrade...