Otu esi tọgharịa MySQL ma ọ bụ MariaDB Root Password na Linux


Ọ bụrụ na ị na-edozi ihe nkesa MySQL ma ọ bụ MariaDB maka oge mbụ, ọ ga-abụ na ị ga-agba ọsọ mysql_secure_installation n'oge na-adịghị anya iji mejuputa ntọala nchekwa.

Otu n'ime ntọala ndị a bụ paswọọdụ maka akaụntụ mgbọrọgwụ nchekwa data - nke ị ga-edobe na nzuzo ma jiri naanị mgbe achọrọ ya. Ọ bụrụ na ịchefu paswọọdụ ma ọ bụ mkpa ịtọgharịa ya (dịka ọmụmaatụ, mgbe onye nchịkwa nchekwa data gbanwere ọrụ - ma ọ bụ na-achụpụ!).

Akụkọ a ga-aba uru. Anyị ga-akọwa otu esi tọgharịa ma ọ bụ weghachite MySQL ma ọ bụ MariaDB mgbọrọgwụ paswọọdụ na Linux.

Ọ bụ ezie na anyị ga-eji ihe nkesa MariaDB n'isiokwu a, ntụziaka ahụ kwesịrị ịrụ ọrụ maka MySQL.

Weghachite MySQL ma ọ bụ MariaDB mgbọrọgwụ paswọọdụ

Iji malite, kwụsị ọrụ nchekwa data wee lelee ọkwa ọrụ, anyị kwesịrị ịhụ mgbanwe gburugburu ebe anyị debere na mbụ:

------------- SystemD ------------- 
# systemctl stop mariadb

------------- SysVinit -------------
# /etc/init.d/mysqld stop

Ọzọ, malite ọrụ na --skip-grant-tables:

------------- SystemD ------------- 
# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mariadb
# systemctl status mariadb

------------- SysVinit -------------
# mysqld_safe --skip-grant-tables &

Nke a ga-enye gị ohere ijikọ na ihe nkesa nchekwa data dị ka mgbọrọgwụ na-enweghị paswọọdụ (ị nwere ike ịgbanwe gaa na ọdụ dị iche iji mee ya):

# mysql -u root

Site na mgbe ahụ gawa, soro usoro ndị akọwapụtara n'okpuru.

MariaDB [(none)]> USE mysql;
MariaDB [(none)]> UPDATE user SET password=PASSWORD('YourNewPasswordHere') WHERE User='root' AND Host = 'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;

N'ikpeazụ, kwụsị ọrụ ahụ, wepụ mgbanwe gburugburu ebe obibi wee malite ọrụ ahụ ọzọ:

------------- SystemD ------------- 
# systemctl stop mariadb
# systemctl unset-environment MYSQLD_OPTS
# systemctl start mariadb

------------- SysVinit -------------
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Nke a ga-eme ka mgbanwe ndị gara aga na-arụ ọrụ, na-enye gị ohere iji paswọọdụ ọhụrụ jikọọ na sava nchekwa data.

N'isiokwu a, anyị atụlewo ka esi tọgharịa MariaDB/MySQL mgbọrọgwụ paswọọdụ. Dị ka mgbe niile, nweere onwe gị iji ụdị nkọwa n'okpuru dobe anyị ndetu ma ọ bụrụ na ị nwere ajụjụ ọ bụla ma ọ bụ nzaghachi. Anyị na-atụ anya ịnụ gị!