Yadda ake Gyara "MySQL ERROR 1819 (HY000):" a cikin Linux


Lokacin ƙirƙirar mai amfani da MySQL tare da kalmar wucewa mai rauni, zaku iya cin karo da kuskuren 'MySQL ERROR 1819 (HY000): Kalmar sirrinku ba ta wadatar da ƙa'idodin manufofin yanzu'. Ta hanyar fasaha, wannan ba kuskure bane, amma sanarwa ne cewa kuna amfani da kalmar wucewa wacce bata cika ƙa'idodin manufofin kalmar sirri ba.

A takaice dai, kuna amfani da kalmar wucewa mai rauni wacce za a iya fahimta ko a tilasta mata. Tsarin tsaro yana hana masu amfani ƙirƙirar kalmomin sirri marasa ƙarfi waɗanda zasu iya ba da bayanan ku damar fuskantar ɓarna.

Misali, Na shiga cikin kuskure lokacin ƙirƙirar mai amfani kamar yadda aka nuna

mysql> create user ‘tecmint’@’localhost’ IDENTIFIED BY ‘mypassword’;

Babu damuwa cewa kalmar wucewa tana da rauni matuka kuma yana iya kawo matsalar tsaro.

Yadda ake Warware MySQL ERROR 1819 (HY000) a cikin Linux

Jirgin bayanan MySQL yana jirgi tare da ingantaccen_password plugin wanda idan aka kunna shi, yana aiwatar da manufar tabbatar da kalmar sirri. Akwai matakai 3 na manufofin tabbatar da kalmar sirri waɗanda kayan aikin ke amfani da su.

  • LOW: Yana bawa masu amfani damar saita kalmar wucewa na haruffa 8 ko ƙasa da haka.
  • Matsakaici: Ba masu amfani damar saita kalmar wucewa na haruffa 8 ko werarami tare da maganganu masu gauraya da haruffa na musamman.
  • KARFI: Yana ba masu amfani damar saita kalmar wucewa wacce ke da dukkan halayen kalmar shiga matsakaici tare da haɗa fayil ɗin ƙamus.

Ta hanyar tsoho, an saita manufar kalmar sirri zuwa MEDIUM. Kuna iya tabbatar da matakin manufofin kalmar sirri, ta aiwatar da umarnin:

$ SHOW VARIABLES LIKE 'validate_password%';

Idan kun kunna umarni kuma kun sami fitowar komai saiti, to ba a kunna fulogi ba tukuna.

Don kunna ingantaccen_password plugin, gudanar da umarni a ƙasa.

mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'validate%';
mysql> install plugin validate_password soname 'validate_password.so';

Don tabbatar da cewa an kunna kayan aikin, kunna umarnin.

mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'validate%';

Ya kamata ku sami fitowar da aka nuna a ƙasa:

Don warware matsalar, kana buƙatar saita manufar tabbatar da kalmar sirri zuwa matakin mafi ƙanƙanci. Na san wannan ba shi da kyau kamar yadda yake haifar da hanya don saita kalmomin shiga marasa ƙarfi wanda a ƙarshe zai iya haifar da rutsawar bayanan ku ta hanyar masu fashin baki.

Koyaya, idan har yanzu kun nace kan samun hanyarku, ga abin da zaku iya yi.

Yadda Ake Canza Manufofin Tabbatar da Kalmar Sirrin MySQL

Don warware kuskuren MySQL ERROR 1819 (HY000), saita ƙananan kalmar tabbatar da kalmar sirri kamar yadda aka nuna.

mysql> SET GLOBAL validate_password_policy=LOW;
OR
mysql> SET GLOBAL validate_password_policy=0;

Bayan haka zaku iya tabbatar da matakin manufofin tabbatar da kalmar wucewa.

$ SHOW VARIABLES LIKE 'validate_password%';

Yanzu zaku iya ci gaba da sanya kalmar sirri mai rauni kamar yadda kuke fata.

mysql> create user ‘tecmint’@’localhost’ IDENTIFIED BY ‘mypassword’;

Don komawa zuwa matakin manufar kalmar sirri 'MEDIUM', kawai kira umarnin:

mysql> SET GLOBAL validate_password_policy=MEDIUM;

Da kaina, ba zan ba da shawarar saita ƙaramar matakin kalmar sirri don dalilai bayyanannu ba. Ko mai amfani ne na yau da kullun ko mai amfani da bayanai, ana ba da shawarar a koyaushe saita kalmar sirri ta MySQL mai ƙarfi tare da haruffa sama da 8 tare da haɗuwa da manyan abubuwa, ƙarami, lambobi da kuma haruffa na musamman.

Wannan jagorar saboda masu son sanin yadda ake kewaya irin wannan kuskuren ne, in ba haka ba, koyaushe ana ba da shawarar kafa kalmar sirri mai ƙarfi.