Yadda ake Canja Tushen Kalmar wucewa na MySQL ko MariaDB a cikin Linux

Idan kuna shigar da MySQL ko MariaDB a cikin Linux a karon farko, da alama za ku aiwatar da rubutun mysql_secure_installation don tabbatar da shigarwar MySQL tare da saitunan asali.

Ɗaya daga cikin waɗannan saitunan shine, tushen kalmar sirrin bayanai - wanda dole ne ku ɓoye sirri kuma ku yi amfani da shi kawai lokacin da ake buƙata. Idan kana buƙatar canza shi (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 canza kalmar sirri ta MySQL ko uwar garken bayanan MariaDB a cikin Linux.

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

Canza MySQL ko MariaDB Tushen Kalmar wucewa

Kun san tushen kalmar sirri kuma kuna son sake saita shi, a wannan yanayin, bari mu tabbata MariaDB yana gudana:

------------- CentOS/RHEL 7 and Fedora 22+ ------------- 
# systemctl is-active mariadb

------------- CentOS/RHEL 6 and Fedora -------------
# /etc/init.d/mysqld status

Idan umarnin da ke sama bai dawo da kalmar active azaman fitarwa ko dakatar da ita ba, kuna buƙatar fara sabis ɗin bayanai kafin ci gaba:

------------- CentOS/RHEL 7 and Fedora 22+ ------------- 
# systemctl start mariadb

------------- CentOS/RHEL 6 and Fedora -------------
# /etc/init.d/mysqld start

Bayan haka, za mu shiga cikin uwar garken bayanai azaman tushen:

# mysql -u root -p

Don dacewa a cikin nau'ikan iri, za mu yi amfani da bayanin mai zuwa don sabunta teburin mai amfani a cikin bayanan mysql. Lura cewa kuna buƙatar maye gurbin Password anan tare da sabon kalmar sirri da kuka zaɓa don tushen.

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

Don ingantawa, fita zaman MariaDB na yanzu ta hanyar bugawa.

MariaDB [(none)]> exit;

sa'an nan kuma danna Shigar. Ya kamata yanzu ku sami damar haɗi zuwa uwar garken ta amfani da sabon kalmar sirri.

A cikin wannan labarin mun bayyana yadda ake canza kalmar sirri ta MariaDB/MySQL - ko kun san na yanzu ko a'a.

Kamar koyaushe, jin kyauta don sauke mana bayanin kula idan kuna da wasu tambayoyi ko ra'ayi ta amfani da fam ɗin sharhin da ke ƙasa. Muna jiran ji daga gare ku!