Akwụkwọ ndekọ ederede
Na nkuzi a ga-eduzi gị otu esi eme yaSenti 7, kwalite/wụnye MariaDB na ụdị Mariadb10.10.2 kachasị ọhụrụ.
- Nkuzi a metụtakwara CWP naVestaCPma ọ bụ ogwe njikwa ihe nkesa VPS ọ bụla dakọtara.
MariaDB 10.10.2 kwụsiri ike ugbu a yana ọtụtụ atụmatụ agbakwunyere ma melite na ntọhapụ a.
- ị nwere ikeEbe aLelee ndepụta mgbanwe niile.
anyị ejirilaWordPress, Joomla, xenforo, IPS Forum na ụfọdụ dabere naMySQL Edemede PHP nke DB na-enyocha MariaDB 10.10.2, yabụ ọ dị mma ịkwalite ụdị a.
Kedu ihe bụ MariaDB?
Nkọwa dị mkpirikpi gbasara MariaDB:
- Ezubere MariaDB ka ọ bụrụMySQLkpọmkwem nnọchi.
- N'iji njirimara ndị ọzọ: injin nchekwa ọhụrụ, mpe mpe mpe na arụmọrụ ka mma.
- Ọtụtụ n'ime ndị nrụpụta mbụ MySQL mepụtara MariaDB, ndị na-arụ ọrụ ugbu a maka MariaDB Foundation na MariaDB Corporation, yana ọtụtụ ndị obodo.
Iji kwalite, soro usoro ndị a dị mfe iji kwalite gaa na ụdị kachasị ọhụrụ.
Kwụpụ 1: Hichapụ ụdị ochie nke MariaDB
- Hichapụ ụdị ochie nke MariaDB, dị ka: 5.5 / 10.0 / 10.1 / 10.2 / 10.3
Tupu ịwụnye, a na-atụ aro ka ị buru ụzọ kwado ndabereMySQL nchekwa data.
Nke mbụ, kwado nhazi my.cnf gị ugbu a▼
cp /etc/my.cnf /etc/my.cnf.bak
- Ugbu a, anyị kwesịrị iwepụ ụdị mariadb 7 dị ugbu a na centos 5.5:
Maka MariaDB 5.5 ▼
service mariadb stop / service mysql stop rpm -e --nodeps galera yum remove mariadb mariadb-server
- N'oge a MariaDB 5.5 ga-ewepụ kpamkpam, mana nchekwa data agaghị ewepụ, echegbula.
Maka nsụgharị dị n'elu MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼
service mysql stop rpm -e --nodeps galera yum remove MariaDB-server MariaDB-client
- N'oge a, MariaDB 10.0/10.1/10.2/10.3 ga-ehichapụ kpamkpam, mana nchekwa data agaghị ehichapụ, echegbula.
Kwụpụ 2: Wụnye MariaDB 10.10.2
- Site na ụdị MariaDB 5.5/10.0/10.1/10.2/10.3, wụnye/melite na MariaDB 10.10.2.
Wụnye Mariadb 10.10.2 repo gọọmentị ▼
yum install nano epel-release -y
Ugbu a dezie/mepụta faịlụ Repo/etc/yum.repos.d
Ọ bụrụ na ihichapụ ma ọ bụ ndabere faịlụ repo dị ugbu a, jide n'aka na ị nweghị faịlụ nchekwa MariaDB ọzọ ▼
mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak nano /etc/yum.repos.d/mariadb.repo
Mgbe ahụ mado ihe ndị a, wee chekwaa▼
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.10.2/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Mgbe nke ahụ gasịrị, anyị ga-etinye Mariadb 10.10.2 ▼
yum clean all yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y yum update -y
Weghachite faịlụ my.cnf ▼
rm -rf /etc/my.cnf cp /etc/my.cnf.bak /etc/my.cnf
Mgbe ahụ, rụọ ọrụ Mariadb ka ị buut, wee malite ọrụ:
systemctl enable mariadb service mysql start
Kwụpụ 3: kwalite nchekwa data dị ugbu a
Mgbe echichi gasịrị, anyị kwesịrị ịkwalite nchekwa data dị ugbu a site na iwu na-esonụ ▼
mysql_upgrade
- Ọ bụrụ na ọ nweghị ihe ọzọ, ị kwalitela MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 gaa na ụdị MariaDB 10.10.2 kachasị ọhụrụ.
Ọ bụrụ na ị na-apị iwu mysql_upgrade
Mgbe ị na-akwalite nchekwa data, ozi njehie na-egosi ▼
[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
Biko jiri ihe ndị amysql_upgrade
iwu idozi ▼
mysql_upgrade -u root --datadir=/var/lib/mysql/ --basedir=/ --password=123456
- Biko gbanwee "123456" dị n'elu ka ọ bụrụ MySQL ma ọ bụ Mariadb nchekwa data mgbọrọgwụ paswọọdụ.
N'ikpeazụ, ị nwere ike kwado ụdị nchekwa data MySQL ma ọ bụ Mariadb site na iji iwu a n'elu SSH site na ọnụ ▼
mysql -V
Cakpachara anya
Ọ bụrụ na nchekwa data MariaDB nwere ozi njehie yiri nke 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
Maka azịza maka njehie nchekwa data MariaDB, biko pịa njikọ dị n'okpuru ka ịlele▼
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kesara "Otu esi emelite / kwalite na MariaDB7 na VestaCP/CWP/CentOS 10.10.2? , iji nyere gị aka.
Nnọọ ka ị kesaa njikọ nke akụkọ a:https://www.chenweiliang.com/cwl-1100.html
Nabata na ọwa Telegram nke blọgụ Chen Weiliang ka ị nweta mmelite kachasị ọhụrụ!
📚 Ntuziaka a nwere nnukwu uru, 🌟Nke a bụ ohere dị ụkọ, echefula ya! ⏰⌛💨
Kekọrịta na-amasị ma ọ bụrụ na-amasị gị!
Ịkekọrịta na mmasị gị bụ mkpali anyị na-aga n'ihu!