Ungabuyekeza/uthuthukele kanjani ku-MariaDB7 ku-VestaCP/CWP/CentOS 10.10.2?

Kulesi sifundo sizokuqondisa ukuthi wenze kanjaniI-Centos 7, thuthukisa/faka i-MariaDB enguqulweni yakamuva ye-Mariadb10.10.2.

• Lesi sifundo sisebenza naku-CWP kanyeVestaCPnanoma iyiphi enye iphaneli yokulawula iseva ye-VPS ehambisanayo.

I-MariaDB 10.10.2 manje isizinze kakhulu futhi izici eziningi zengeziwe futhi zathuthukiswa kulokhu kukhululwa.

• UngakwazilaphaHlola uhlu lwazo zonke izinguquko.

sisebenziseWordPress, Joomla, xenforo, IPS Forum nokunye okuncikile okuncike kukhoMySQL Umbhalo we-PHP we-DB uhlola i-MariaDB 10.10.2, ngakho-ke kuphephile ukuthuthukela kule nguqulo.

Iyini i-MariaDB?

Incazelo emfushane mayelana ne-MariaDB:

• I-MariaDB yakhelwe ukwenzaMySQLesikhundleni esiqondile.
• Ngezici ezengeziwe: injini entsha yesitoreji, iziphazamisi ezimbalwa nokusebenza okungcono.
• I-MariaDB yathuthukiswa onjiniyela abaningi bokuqala be-MySQL asebesebenzela i-MariaDB Foundation kanye ne-MariaDB Corporation, kanye nabaningi emphakathini.

Ukuze uthuthukise, landela lezi zinyathelo ezilula ukuze uthuthukele enguqulweni yakamuva.

Isinyathelo 1: Susa inguqulo yakudala ye-MariaDB

• Susa inguqulo endala ye-MariaDB, njenge: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Ngaphambi kokufaka, kunconywa ukuthi wenze ikhophi yasenqolobaneni kuqalaMySQL database,

Okokuqala, yenza isipele ukucushwa kwakho kwamanje kwe-my.cnf▼

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

• Manje sidinga ukususa inguqulo yamanje ye-mariadb 7 efakwe ku-centos 5.5:

Okwe-MariaDB 5.5 ▼

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

• Kuleli qophelo i-MariaDB 5.5 izosuswa ngokuphelele, kodwa i-database ngeke isuswe, ungakhathazeki.

Ezinguqulweni ezingaphezu kuka-MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

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

• Kuleli qophelo, i-MariaDB 10.0/10.1/10.2/10.3 izosuswa ngokuphelele, kodwa isizindalwazi ngeke sisuswe, ungakhathazeki.

Isinyathelo sesi-2: Faka i-MariaDB 10.10.2

• Kusukela ku-MariaDB 5.5/10.0/10.1/10.2/10.3 izinguqulo, faka/ubuyekeze ku-MariaDB 10.10.2.

Faka i-Mariadb 10.10.2 repo esemthethweni ▼

yum install nano epel-release -y

Manje hlela/dala ifayela le-Repo/etc/yum.repos.d

Uma kukhona susa noma ulondoloze amafayela e-repo akhona, qiniseka ukuthi awunawo amanye amafayela enqolobane ye-MariaDB ▼

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

Bese unamathisela okulandelayo, bese 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

Ngemuva kwalokho sizofaka i-Mariadb 10.10.2 ▼

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

Buyisela ifayela le-my.cnf ▼

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

Bese, yenza kusebenze i-Mariadb ukuze iqale, bese uqala isevisi:

systemctl enable mariadb
service mysql start

Isinyathelo sesi-3: Thuthukisa isizindalwazi samanje

Ngemva kokufaka, sidinga ukuthuthukisa isizindalwazi samanje ngomyalo olandelayo ▼

mysql_upgrade

• Uma kungekho okunye, uthuthukise ngempumelelo i-MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 kuya enguqulweni yakamuva ye-MariaDB 10.10.2.

Uma uthayipha umyalo mysql_upgrade Lapho uthuthukisa isizindalwazi, umyalezo wephutha olandelayo uyavela ▼

[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

Sicela usebenzise okulandelayomysql_upgrade umyalo wokulungisa ▼

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

• Sicela uguqule okungenhla kokuthi "123456" ku-MySQL yakho noma i-Mariadb database ye-root password.

Ekugcineni, ungaqinisekisa inguqulo yesizindalwazi se-MySQL noma i-Mariadb ngokusebenzisa lo myalo usuka kutheminali ethi SSH ▼

mysql -V

Ukuqapha

Uma isizindalwazi sakho se-MariaDB sinomlayezo wephutha ofanayo▼

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

Ukuze uthole izixazululo zamaphutha esizindalwazi se-MariaDB, sicela uchofoze isixhumanisi esingezansi ukuze ubuke▼

Xazulula isexwayiso: iphutha lesizindalwazi Isibalo sekholomu ye-mysql.proc akulungile.

Eqinisweni, uma usebenzisa i-phpMyAdmin, awukwazi ukuthola iphutha lapho inkinga?Inkinga ingoba uthuthukise inguqulo ye-MariaDB noma ye-MySQL database.Ngemuva kokuthuthukisa inguqulo yedatha ye-MariaDB noma ye-MySQL, izakhiwo zedatha aziqediwe kusetshenziswa umyalo we-mysql_upgrade...