Otu esi edozi MySQL ERROR 1819 (HY000): na Linux

Mgbe ị na-eke onye ọrụ MySQL nwere okwuntughe adịghị ike, ị nwere ike izute njehie 'MySQL ERROR 1819 (HY000): Okwuntughe gị anaghị egbo ihe iwu chọrọ ugbu a'. Na teknụzụ, nke a abụghị mperi, mana ọkwa na ị na-eji okwuntughe na-ezuteghị iwu paswọọdụ akwadoro.

N'ikwu ya n'ụzọ ọzọ, ị na-eji okwuntughe na-adịghị ike nke enwere ike ịkọwa ngwa ngwa ma ọ bụ ịmanye mkparị. Usoro nchekwa arụnyere n'ime na-akụda ndị ọrụ ka ha mepụta okwuntughe adịghị ike nke nwere ike ime ka nchekwa data gị nwee ike ịdaba.

Dịka ọmụmaatụ, agbabara m n'ime njehie ahụ mgbe ị na-emepụta onye ọrụ dịka egosiri

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

Ọ bụghị echiche na okwuntughe adịghị ike nke ukwuu ma nwee ike weta ihe egwu nchekwa.

Otu esi edozi MySQL ERROR 1819 (HY000) na Linux

MySQL nchekwa data na-eji ngwa mgbakwunye validate_password na-ebufe nke mgbe enyere ya aka, na-akwado amụma nkwado paswọọdụ. Enwere ụkpụrụ nkwado paswọọdụ 3 nke ngwa mgbakwunye na-akwado.

• ALA: Na-enye ndị ọrụ ohere ịtọ paswọọdụ mkpụrụedemede 8 ma ọ bụ ole na ole.
• OGE: Na-enye ndị ọrụ ohere ịtọ paswọọdụ nke mkpụrụedemede 8 ma ọ bụ ole na ole nwere agwa agwakọta na mkpụrụedemede pụrụ iche.
• STRONG: Na-enye ndị ọrụ ohere ịtọ okwuntughe nwere njirimara niile nke okwuntughe dị larịị yana ntinye faịlụ ọkọwa okwu.

Site na ndabara, edobere amụma okwuntughe ka ọ bụrụ MEDIUM. Ị nwere ike kwado ọkwa amụma okwuntughe, site na ịme iwu a:

$ SHOW VARIABLES LIKE 'validate_password%';

Ọ bụrụ na ị na-agba ọsọ iwu ahụ wee nweta mmepụta ihe efu, mgbe ahụ, agbanyebeghị ngwa mgbakwunye ahụ.

Iji mee ngwa mgbakwunye validate_password, mee iwu ndị dị n'okpuru.

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

Iji gosi na agbanyere ngwa mgbakwunye ahụ, mee iwu ahụ.

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

Ị ga-enweta nsonaazụ egosiri n'okpuru:

Iji dozie esemokwu ahụ, ịkwesịrị ịtọọ amụma nkwado okwuntughe na ọkwa kacha ala. Amaara m na nke a na-ada ada ka ọ na-emepụta ụzọ maka ịtọ okwuntughe adịghị ike nke nwere ike ime ka ndị hackers mebie nchekwa data gị n'ikpeazụ.

Agbanyeghị, ọ bụrụ na ị ka na-ekwusi ike na ị ga-enweta ụzọ gị, nke a bụ ihe ị nwere ike ime.

Otu esi agbanwe iwu nkwado paswọọdụ MySQL

Iji dozie njehie MySQL ERROR 1819 (HY000), tọọ amụma nkwado okwuntughe dị ala dịka egosiri.

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

Ị nwere ike mechaa kwado ọkwa nkwado paswọọdụ.

$ SHOW VARIABLES LIKE 'validate_password%';

Ugbu a ị nwere ike ịga n'ihu wee kenye paswọọdụ adịghị ike dịka ịchọrọ.

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

Ka ịlaghachi na ọkwa amụma okwuntughe 'MEDIUM', kpọkuo naanị iwu a:

mysql> SET GLOBAL validate_password_policy=MEDIUM;

Onwe m, agaghị m akwado ịtọ ụkpụrụ okwuntughe dị ala maka ebumnuche doro anya. Ma ọ bụ onye ọrụ nkịtị ma ọ bụ onye ọrụ nchekwa data, a na-atụ aro ka ịtọọ paswọọdụ MySQL siri ike yana ihe karịrị mkpụrụedemede 8 nwere ngwakọta nke mkpụrụedemede ukwu, obere obere, ọnụọgụ na mkpụrụedemede pụrụ iche.

Ntuziaka a bụ maka ndị chọrọ ịma ka esi emegharị njehie dị otú ahụ, ma ọ bụghị ya, a na-atụ aro ịtọ paswọọdụ siri ike mgbe niile.