Yadda ake Sake saita Tushen Kalmar wucewa a cikin MySQL 8.0

A cikin wani abin takaici na manta ko rasa kalmar sirri ta MySQL, tabbas za ku buƙaci hanyar da za ku dawo da ita ko ta yaya. Abin da muke buƙatar sani shi ne cewa kalmar sirri tana adana a cikin tebur masu amfani. Wannan yana nufin cewa muna buƙatar gano hanyar da za mu ketare amincin MySQL, don haka za mu iya sabunta rikodin kalmar sirri.

An yi sa'a akwai mai sauƙi don cimmawa kuma wannan koyawa za ta jagorance ku ta hanyar farfadowa ko sake saita kalmar sirri a cikin MySQL 8.0 version.

Dangane da takaddun MySQL akwai hanyoyi guda biyu don sake saita kalmar sirri ta MySQL. Za mu duba duka biyun.

Sake saita MySQL Tushen Kalmar wucewa ta Amfani da –init-file

Ɗaya daga cikin hanyoyin da za a sake saita tushen kalmar sirri shine ƙirƙirar fayil na gida sannan fara sabis na MySQL ta amfani da --init-file zaɓi kamar yadda aka nuna.

# vim /home/user/init-file.txt

Yana da mahimmanci ka tabbatar cewa fayil ɗin yana iya karantawa ta mai amfani da mysql. A cikin wannan fayil manna mai biyowa:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

A cikin sama canza new_password tare da kalmar sirri da kuke son amfani da ita.

Yanzu tabbatar da cewa an dakatar da sabis na MySQL. Kuna iya yin haka:

# systemctl stop mysqld.service     # for distros using systemd 
# /etc/init.d/mysqld stop           # for distros using init

Sa'an nan kuma gudanar da wadannan:

# mysqld --user=mysql --init-file=/home/user/init-file.txt --console

Wannan zai fara sabis na MySQL kuma yayin aiwatarwa zai aiwatar da init-fayil ɗin da kuka ƙirƙiri kuma ta haka za a sabunta kalmar sirri don tushen mai amfani. Tabbatar share fayil ɗin da zarar an sake saita kalmar wucewa.

Tabbatar dakatar da uwar garken kuma fara shi akai-akai bayan haka.

# systemctl stop mysqld.service        # for distros using systemd 
# systemctl restart mysqld.service     # for distros using systemd 

# /etc/init.d/mysqld stop              # for distros using init
# /etc/init.d/mysqld restart           # for distros using init

Ya kamata yanzu ku sami damar haɗi zuwa uwar garken MySQL azaman tushen ta amfani da sabon kalmar sirri.

# mysql -u root -p

Sake saita MySQL Tushen Kalmar wucewa ta Amfani da -skip-grant-tables

Zaɓin na biyu da muke da shi shine fara sabis na MySQL tare da zaɓi --skip-grant-tables zaɓi. Wannan bashi da tsaro kamar yadda aka fara sabis ɗin ta wannan hanyar, duk masu amfani zasu iya haɗawa ba tare da kalmar sirri ba.

Idan uwar garken ta fara --skip-grant-tables, zaɓi na --skip-networking yana kunna ta atomatik don haka ba za a sami haɗin kai mai nisa ba.

Da farko tabbatar da cewa an dakatar da sabis na MySQL.

# systemctl stop mysqld.service     # for distros using systemd 
# /etc/init.d/mysqld stop           # for distros using init

Sannan fara sabis ɗin tare da zaɓi mai zuwa.

# mysqld --skip-grant-tables --user=mysql &

Bayan haka, zaku iya haɗawa zuwa uwar garken mysql ta hanyar gudu kawai.

# mysql

Tun da an kashe sarrafa asusun lokacin da aka fara sabis tare da zaɓi --skip-grant-tables, dole ne mu sake shigar da tallafin. Ta haka za mu iya canza kalmar sirri daga baya:

# FLUSH PRIVILEGES;

Yanzu zaku iya gudanar da tambaya mai zuwa don sabunta kalmar wucewa. Tabbatar canza new_password tare da ainihin kalmar sirri da kuke son amfani da ita.

# ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_passowrd';

Yanzu dakatar da uwar garken MySQL kuma fara shi kullum.

# systemctl stop mysqld.service        # for distros using systemd 
# systemctl restart mysqld.service     # for distros using systemd 

# /etc/init.d/mysqld stop              # for distros using init
# /etc/init.d/mysqld restart           # for distros using init

Ya kamata ku iya haɗawa da sabon kalmar sirrinku.

# mysql -u root -p

Hakanan kuna iya son karanta waɗannan abubuwan masu amfani a bin labaran MySQL masu alaƙa.

Yadda ake Sanya MySQL 8 a cikin CentOS, RHEL da Fedora
15 Fa'idodin Gyaran Ayyukan MySQL da Nasihun Ingantawa
12 Ayyukan Tsaro na MySQL don Linux
4 Kayan Aikin Layi Mai Amfani don Kula da Ayyukan MySQL
Dokokin Gudanar da Database na MySQL

A cikin wannan labarin kun koyi yadda ake sake saita kalmar sirri ta ɓace don uwar garken MySQL 8.0. Ina fata tsarin ya kasance mai sauƙi.