Otu esi etinye MySQL 8 kacha ọhụrụ na Debian 10

MySQL bụ usoro njikwa nchekwa data mepere emepe nke a na-ejikarị echekwa ma weghachite data maka ngwa dị iche iche ama ama. Na Debian 10, MariaDB na-abịa na ndabara dị ka ntinye ntinye maka MySQL na n'ọtụtụ ọnọdụ, MariaDB na-arụ ọrụ nke ọma.

Ọ bụ ya mere, n'ime akụkọ abụọ anyị gara aga, anyị ejirila ihe nkesa nchekwa data MariaDB, ebe anyị gosipụtara otu esi etinye nchịkọta LEMP na Debian 10.

Ọ bụrụ na ịchọrọ naanị njirimara dị na MySQL, mgbe ahụ ịkwesịrị ịwụnye ya na ebe nchekwa MySQL APT gọọmentị dị ka egosiri n'isiokwu a.

Kwụpụ 1: Ịgbakwunye MySQL Software Repository

Iji wụnye ụdị MySQL ọhụrụ, ịkwesịrị ibudata na wụnye MySQL APT nchekwa na-abata na .deb ngwugwu na-ejikwa hazie na wụnye MySQL software repositories na gị Debian usoro.

$ cd /tmp
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
$ sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb

N'oge nrụnye ngwugwu, a ga-akpali gị ịhazi ebe nchekwa MySQL APT ka ịhọrọ ụdị nke sava MySQL na ihe ndị ọzọ ịchọrọ ịwụnye. Hapụ nhọrọ ndabara iji wụnye ụdị ọhụrụ. Ozugbo ịmechara, pịa Tinye ma ọ bụ gaa OK wee pịa Tinye.

Kwụpụ 2: Wụnye MySQL na Debian 10

Mgbe ịgbakwunye ebe nchekwa MySQL APT, melite cache ngwugwu APT wee wụnye ngwugwu MySQL, nke ga-etinyekwa ngwugwu maka onye ahịa yana maka faịlụ nkịtị nchekwa data dị ka ndị a.

$ sudo apt update
$ sudo apt install mysql-server

N'oge ntinye nke ngwugwu ahụ, windo nhazi ngwugwu ga-egosi, na-arịọ gị ka ịtọọ paswọọdụ onye ọrụ mgbọrọgwụ nchekwa data maka MySQL. Tinye paswọọdụ echekwara ma sie ike wee kwado ya site na itinye ya ọzọ.

Mgbe ahụ gụọ maka sistemụ nyocha ọhụrụ dabere na ụzọ paswọọdụ dabere na SHA256, nke MySQL na-eji wee pịa OK. Ma họrọ ngwa mgbakwunye nkwenye ndabara ịchọrọ iji (hapụ nhọrọ ndabara iji jiri ngwa mgbakwunye akwadoro) wee pịa bọtịnụ Tinye ka ịmechaa usoro nwụnye.

Mgbe nrụnye ngwugwu zuru ezu, onye nrụnye na-akpali systemd ka ọ malite ọrụ MySQL ozugbo wee hazie ya ka ọ malite na buut sistemụ. Iji jide n'aka na ọrụ MySQL na-arụ ọrụ, nyochaa ọkwa ya site na iji iwu na-esonụ.

$ sudo systemctl status mysql 

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2019-08-01 06:20:12 UTC; 3s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 2673 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 2709 (mysqld)
   Status: "Server is operational"
    Tasks: 39 (limit: 4915)
   Memory: 378.4M
   CGroup: /system.slice/mysql.service
           └─2709 /usr/sbin/mysqld

Aug 01 06:20:10 tecmint systemd[1]: Starting MySQL Community Server...
Aug 01 06:20:12 tecmint systemd[1]: Started MySQL Community Server.

Enwere ọtụtụ iwu systemctl ndị ọzọ ịchọrọ ịma iji jikwaa (malite, malitegharịa, kwụsị, na bugharịa) ọrụ MySQL ebe ọ dị mkpa, ndị a bụ:

$ sudo systemctl start mysql 
$ sudo systemctl restart mysql 
$ sudo systemctl stop mysql 
$ sudo systemctl reload mysql

Kwụpụ 3: Chekwaa MySQL na Debian 10

Ihe ọ bụla nkesa MySQL ọ bụla enweghị nchebe na ndabara yana iji melite nchekwa nke ihe nkesa MySQL, ị ga-agba ọsọ mysql_secure_installation script nke na-akpali gị ikpebi omume ị ga-eme.

$ sudo mysql_secure_installation

Mgbe ahụ zaa ajụjụ ndị ahụ nke ọma site n'ịgụ nkọwa nke nke ọ bụla. Nke mbụ, tinye paswọọdụ onye ọrụ mgbọrọgwụ ị debere n'oge nrụnye ngwugwu. Mgbe ahụ, ị nwere ike họrọ y (maka EE) ma ọ bụ n (maka Mba) iji jiri ma ọ bụ ghara iji ngwa VALIDATE PASSWORD, n'otu n'otu.

Ọzọkwa, họrọ enweghị mgbe a gwara gị ka ịtọọ paswọọdụ njirimara mgbọrọgwụ ọhụrụ (nke ị deberela n'oge nrụnye ngwugwu). Wee jiri nlezianya soro mkpali ndị ọzọ wee họrọ y (maka EE) iji wepụ ndị ọrụ na-amaghị aha, kwe ka nbanye mgbọrọgwụ dịpụrụ adịpụ, wepụ nchekwa data ule wee bugharịa tebụl ihe ùgwù.

Kwụpụ 4: Na-anwale nwụnye MySQL

Mgbe ị nwetachara ihe nkesa MySQL gị, ị nwere ike ịmalite iji ya maka ịchekwa data maka weebụsaịtị ma ọ bụ ngwa weebụ gị. Iji nweta shei MySQL, mee iwu na-esonụ (tinye MySQL mgbọrọgwụ paswọọdụ mgbe kpaliri dị ka egosiri na nseta ihuenyo na-esonụ):

$ mysql -u root -p

Ị ga-ahụkwa ntuziaka ndị a gbasara MySQL bara uru:

  1. 12 MySQL/MariaDB Omume Kachasị Mma maka Linux
  2. Otu esi tọgharịa paswọọdụ mgbọrọgwụ na MySQL 8.0
  3. Ngwaọrụ iwu iwu bara uru iji nyochaa arụmọrụ MySQL na Linux

N'isiokwu a, anyị kọwara otú e si wụnye MySQL ọhụrụ nkesa nchekwa data na Debian 10. Ọ bụrụ na ị nwere ajụjụ ọ bụla gbasara isiokwu a, zitere anyị site na nzaghachi nzaghachi n'okpuru.