Yadda ake Sake saita MySQL ko MariaDB Tushen Kalmar wucewa a cikin Linux

Idan kuna kafa uwar garken bayanai na MySQL ko MariaDB a karon farko, da alama za ku yi amfani da mysql_secure_installation nan da nan don aiwatar da saitunan tsaro na asali.

Ɗaya daga cikin waɗannan saitunan shine kalmar sirri don asusun tushen bayanai - wanda dole ne ku kiyaye sirri kuma ku yi amfani da shi kawai lokacin da ake buƙata sosai. Idan ka manta kalmar sirri ko buƙatar sake saita ta (misali, lokacin da mai gudanar da bayanai ya canza ayyuka - ko aka kashe!).

Wannan labarin zai zo da amfani. Za mu yi bayanin yadda ake sake saitawa ko dawo da kalmar sirrin tushen MySQL ko MariaDB da aka manta a cikin Linux.

Kodayake za mu yi amfani da uwar garken MariaDB a cikin wannan labarin, umarnin ya kamata yayi aiki don MySQL kuma.

Mai da MySQL ko MariaDB tushen kalmar sirri

Don farawa, dakatar da sabis ɗin bayanai kuma duba matsayin sabis, yakamata mu ga canjin yanayi da muka saita a baya:

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

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

Na gaba, fara sabis da --skip-grant-tables:

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

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

Wannan zai baka damar haɗawa zuwa uwar garken bayanai azaman tushen tushen ba tare da kalmar sirri ba (zaka iya buƙatar canzawa zuwa wani tasha na daban don yin haka):

# mysql -u root

Daga nan, bi matakan da aka zayyana a ƙasa.

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

A ƙarshe, dakatar da sabis ɗin, cire saita canjin yanayi kuma sake fara sabis ɗin:

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

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

Wannan zai sa canje-canjen da suka gabata suyi tasiri, yana ba ku damar haɗawa zuwa uwar garken bayanan ta amfani da sabon kalmar sirri.

A cikin wannan labarin mun tattauna yadda ake sake saita kalmar sirri ta MariaDB/MySQL. Kamar koyaushe, jin kyauta don amfani da fom ɗin sharhi da ke ƙasa don sauke mana bayanin kula idan kuna da wasu tambayoyi ko ra'ayi. Muna jiran ji daga gare ku!