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ị!