Otu esi etinye MariaDB 10 na RHEL 8

MariaDB bụ ihe ọzọ ama ama na sistemụ njikwa nchekwa data MySQL. Ndị mmepe MySQL mbụ mepụtara ya ma echere ka ọ nọgide na-emeghe.

MariaDB bụ ngwa ngwa na ntụkwasị obi, na-akwado igwe nchekwa nchekwa dị iche iche ma nwee plugins nke na-eme ka ọ zuo oke maka ụdị ojiji dị iche iche.

N'ime nkuzi a, anyị ga-egosi gị otu esi etinye ihe nkesa MariaDB na RHEL 8 gị. Anyị ga-etinye ụdị MariaDB 10.3.10.

Mara: Nkuzi a na-eche na ị nwere ndenye aha RHEL 8 na-arụ ọrụ yana na ị nwere ohere mgbọrọgwụ na sistemụ RHEL gị. N'aka nke ọzọ ị nwere ike iji onye ọrụ nwere ihe ùgwù wee jiri sudo mee iwu ahụ.

Ịwụnye MariaDB Server

Iji wụnye ihe nkesa MariaDB, anyị ga-eji iwu yum na-esonụ iji mezue nrụnye.

# yum install mariadb-server

Nke a ga-etinye ihe nkesa MariaDB na ihe ndabere niile achọrọ.

Ozugbo echichi mechara, ị nwere ike ịmalite ọrụ MariaDB site na:

# systemctl start mariadb

Ọ bụrụ na ịchọrọ ịmalite ọrụ MariaDB na-akpaghị aka mgbe buut sistemu ọ bụla, ị nwere ike ịme iwu a:

# systemctl enable mariadb

Nyochaa ọkwa nke ọrụ MariaDB site na:

# systemctl status mariadb

Chekwaa nwụnye MariaDB

Ugbu a anyị amalitela ọrụ anyị, oge eruola imeziwanye nchekwa ya. Anyị ga-edozi okwuntughe mgbọrọgwụ, gbanyụọ nbanye mgbọrọgwụ, wepụ data nchekwa data na onye ọrụ na-amaghị aha. N'ikpeazụ, anyị ga-ebugharị ihe ùgwù niile.

Maka ebumnuche ahụ, mee naanị iwu na-esonụ wee zaa ajụjụ ndị a nke ọma:

# mysql_secure_installation

Rịba ama na paswọọdụ onye ọrụ mgbọrọgwụ bụ ihe efu, yabụ ọ bụrụ na ịchọrọ ịgbanwe ya, pịa Tinye, mgbe kpaliri maka paswọọdụ ugbu a. Ndị ọzọ ị nwere ike soro usoro na azịza na foto dị n'okpuru:

Nweta ihe nkesa MariaDB

Ka anyị banye ntakịrị omimi wee mepụta nchekwa data, onye ọrụ ma nye onye ọrụ ahụ ohere na nchekwa data. Iji nweta ihe nkesa na console, ị nwere ike iji iwu a:

# mysql -u root -p

Mgbe kpaliri, tinye mgbọrọgwụ okwuntughe nke ị debere na mbụ.

Ugbu a, ka anyị mepụta nchekwa data anyị. Maka ebumnuche ahụ na ngwa ngwa MariaDB, mee iwu a:

MariaDB [(none)]> CREATE DATABASE tecmint;

Nke a ga-emepụta nchekwa data ọhụrụ aha ya bụ tecmint. Kama iji onye ọrụ mgbọrọgwụ nweta nchekwa data ahụ, anyị ga-emepụta onye ọrụ nchekwa data dị iche, nke ga-enwe ohere na nchekwa data ahụ naanị.

Anyị ga-emepụta onye ọrụ ọhụrụ anyị a na-akpọ tecmint_user wee nye ya ohere na nchekwa data tecmint, yana iwu a:

MariaDB [(none)]> GRANT ALL ON tecmint.* TO [email  IDENTIFIED BY 'securePassowrd';

Mgbe ị na-eke onye ọrụ nke gị, jide n'aka na ị ga-eji paswọọdụ ịchọrọ inye onye ọrụ ahụ dochie “SecurityPassword”.

Mgbe ịmechara iwu ndị a dị n'elu, pịnye kwụsị na ngwa ngwa ịpụ na MariaDB:

MariaDB [(none)]> quit;

Ugbu a ị nwere ike iji onye ọrụ ọhụrụ nweta nchekwa data tecmint.

# mysql -u tecmint_user -p

Mgbe kpaliri, tinye paswọọdụ maka onye ọrụ ahụ. Ka ịgbanwee nchekwa data eji, ị nwere ike iji ihe ndị a na ngwa ngwa MariaDB:

MariaDB [(none)]> use tecmint;

Nke a ga-agbanwe nchekwa data dị ugbu a ka ọ bụrụ tecmt.

N'aka nke ọzọ, ịnwere ike ịnye iwu mysql site na ịkọwa aha nchekwa data yana egosiri.

# mysql -u tecmint_user -p tecmint

N'ụzọ ahụ mgbe itinyere paswọọdụ onye ọrụ, ị ga-eji nchekwa data tecmint ozugbo.

N'ebe a, ị mụtala ụfọdụ ihe ndabere nke MariaDB, mana enwere ọtụtụ ihe ọzọ ị ga-enyocha. Ọ bụrụ na ịchọrọ ịkwalite ihe ọmụma nchekwa data gị, ị nwere ike lelee ntuziaka anyị ebe a:

  1. Mụta MySQL/MariaDB maka ndị mbido – Akụkụ 1
  2. Mụta MySQL/MariaDB maka ndị mbido – Nkebi nke 2
  3. MySQL Basic Database Administration Iwu – Nkebi III
  4. 20 MySQL (Mysqladmin) Iwu maka nchịkwa nchekwa data - Nkebi IV
  5. 15 Bara uru Ntụgharị na Ntụziaka Nrụ ọrụ MariaDB – Nkebi V

Nke a bụ ya. N'ime nkuzi a, ị mụtara ka esi etinye ma chekwaa ihe nkesa MariaDB wee mepụta nchekwa data mbụ gị. Ọ bụrụ na ị nwere ajụjụ ọ bụla, nweere onwe gị biputere ha na ngalaba nkọwa.