Otu esi etinye nchekwa data MariaDB na Debian 10

MariaDB bụ isi mmalite mepere emepe yana sistemụ njikwa nchekwa data ama ama (RDBMS) nke ndị mbido MySQL mere. Ọ bụ sistemụ nchekwa data ngwa ngwa, nke nwere ike ịgbatị ma sie ike, nwere nnukwu gburugburu ebe obibi nke igwe nchekwa, plugins na ọtụtụ ngwaọrụ ndị ọzọ na-enye interface SQL maka ịnweta data.

MariaDB bụ nkwalite, ndochi nke MySQL nke òtù na ụlọ ọrụ dị ka Wikipedia, WordPress.com, Google na ọtụtụ ndị ọzọ na-eji.

N'ime edemede a dị mkpirikpi, anyị ga-egosi gị otu esi etinye ma chekwaa ihe nkesa MariaDB na Debian 10.

  1. Wụnye Debian 10 (Buster) sava kacha nta

Rịba ama: Ọ bụrụ na ị na-arụ ọrụ ahụ dị ka onye na-abụghị onye ọrụ nchịkwa, were iwu sudo iji nweta ohere mgbọrọgwụ ma ọ bụrụ na ị nwere MySQL arụnyere ma na-agba ọsọ, kwụsị ya ma gbanyụọ ya tupu ị gaa n'ihu.

Ịwụnye MariaDB Server na Debian 10

Ị nwere ike ịwụnye ngwugwu nkesa MariaDB site na ebe nchekwa ndị ọrụ Debian site na ịme iwu na-esonụ, nke ga-etinye ihe nkesa MariaDB, onye ahịa na ihe niile dabere na ya.

# apt install mariadb-server

Ọ bụ ihe a na-emekarị n'ime Debian na usoro ya dị ka Ubuntu ịmalite na-akpaghị aka ma mee ka daemons site na systemd, ozugbo etinyere ha. Otu a na-emetụta ọrụ MariaDB.

Ị nwere ike ịlele ma ọrụ MariaDB na-arụ ọrụ site na iji usoro systemctl na-esonụ.

# systemctl status mariadb

Na mgbakwunye, ịkwesịrị ịma iwu ndị ọzọ a na-ahụkarị maka ijikwa ọrụ MariaDB n'okpuru sistemu, nke gụnyere iwu ka ịmalite, malitegharịa, kwụsị na bugharịa ọrụ MariaDB dị ka egosiri.

# systemctl start mariadb
# systemctl restart mariadb
# systemctl stop mariadb
# systemctl reload mariadb

Na-echekwa nkesa MariaDB na Debian 10

Usoro ntinye MariaDB gụnyere ịchekwa nrụnye ndabara na enwere ike ime ya site na iji mysql_secure_installation script, nke ga-enye gị ohere itinye ntakịrị nchekwa na ihe atụ MariaDB gị site na:

  • Ịtọba paswọọdụ maka akaụntụ mgbọrọgwụ.
  • Ịgbanyụọ nbanye mgbọrọgwụ ime ime.
  • wepu akaụntụ onye ọrụ amaghị aha.
  • wepu nchekwa data nnwale, nke ndị ọrụ na-amaghị aha nwere ike ịnweta na ndabara.
  • Na ibugharị ihe ùgwù.

Iji kpọkuo edemede nche, mee iwu na-esonụ wee zaa ajụjụ ndị dị ka egosiri na nseta ihuenyo na-esonụ.

Ozugbo ị nwetachara nrụnye MariaDB gị, ị nwere ike jikọọ na shei mysql site na iji paswọọdụ onye ọrụ mgbọrọgwụ.

# mysql -u root -p

Iji mepụta nchekwa data aha ya bụ \my_test_db\ yana onye ọrụ aha ya bụ \test_user nwere ikike zuru oke ijikwa nchekwa data na-eme iwu SQL ndị a.

MariaDB [(none)]> CREATE DATABASE  my_test_db;
MariaDB [(none)]> GRANT ALL ON my_test_db.* TO 'test_user'@'localhost' IDENTIFIED BY 'test_user_pass_here' WITH GRANT OPTION;
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;

Mgbe ịmepụtara nchekwa data ọhụrụ na onye ọrụ nchekwa data, gbalịa ịnweta shei MariaDB site na iji akaụntụ njirimara ọhụrụ wee gosi ọdụ data niile ekenyere onye ọrụ dị ka ndị a.

# mysql -u test_user -p
MariaDB [(none)]> SHOW DATABASES;

Ị nwekwara ike ịmasị ịgụ akụkọ ndị a bara uru na MariaDB.

  1. Mụta MySQL/MariaDB maka ndị mbido – Akụkụ 1
  2. Mụta ka esi eji ọtụtụ ọrụ MySQL na MariaDB - Nkebi 2
  3. 12 MySQL/MariaDB Omume Kachasị Mma maka Linux
  4. Otu esi akwado/weghachite MySQL/MariaDB na PostgreSQL Iji 'Automysqlbackup' na 'Autopostgresqlbackup' Ngwaọrụ
  5. Ndụmọdụ bara uru iji dozie mperi a na-emekarị na MySQL

Nke ahụ bụ maka ugbu a! N'ime ntuziaka a, anyị gosiri otu esi etinye ma chekwaa ihe nkesa MariaDB na ntinye nkesa Debian 10 pere mpe. Jiri ụdị nkọwa dị n'okpuru ebe a iji nweta anyị ajụjụ ma ọ bụ ozi ọ bụla ịchọrọ ịkọrọ anyị.