Otu esi edozi ERROR 1130 (HY000): A naghị ekwe ka onye ọbịa jikọọ na nkesa MySQL a.


N'ime akụkọ ngwa ngwa a, ị ga-amụta otu esi edozi \ERROR 1130 (HY000): anabataghị onye ọbịa x.x.x.x ka ọ jikọọ na ihe nkesa MySQL a na MySQL/MariaDB nchekwa data deployment na sistemụ Linux. ndị ọrụ zutere njehie njikọ nchekwa data dịpụrụ adịpụ.

  • IP nkesa ngwa: 10.24.96.5
  • IP nkesa nchekwa data: 10.24.96.6

Anyị zutere njehie ahụ ka anyị na-anwale njikọ nchekwa data site na otu sava ngwa anyị gaa na nkesa nchekwa data, na-eji onye ahịa mysql dị ka egosiri.

# mysql -u database_username -p -h 10.24.96.6

Njehie ahụ na-egosi na onye ọbịa 10.24.96.5 nke onye ọrụ nchekwa data na-ejikọta na anaghị ekwe ka ọ jikọọ na sava MySQL. N'okwu a, anyị ga-eme mgbanwe ụfọdụ na ihe nkesa nchekwa data iji mee ka onye ọrụ nwee ike jikọọ na anya.

Na nchekwa data nkesa, anyị ga-elele onye ọbịa onye ọrụ n'elu kwere ka jikọọ si.

# mysql -u root -p

Gbaa iwu SQL ndị a ka ịlele onye nnabata onye ọrụ:

MariaDB [(none)]> SELECT host FROM mysql.user WHERE user = "database_username";

Site na mmepụta nke iwu ahụ, a na-ahapụ onye ọrụ ka ọ jikọọ na ihe nkesa nchekwa data site na localhost. Yabụ, anyị kwesịrị imelite ndị ọbịa onye ọrụ dị ka ndị a.

Gbaa iwu GRANT na-esonụ iji mee ka MySQL nweta ohere maka onye ọrụ dịpụrụ adịpụ site na onye ọbịa dịpụrụ adịpụ. Jide n'aka na ị ga-eji adreesị IP nke sistemu dịpụrụ adịpụ dochie \10.24.96.6 yana database_password na paswọọdụ ịchọrọ iji:

MariaDB [(none)]> GRANT ALL ON database_name.* to 'database_username'@'10.24.96.5' IDENTIFIED BY 'database_password';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> SELECT host FROM mysql.user WHERE user = "database_username";

Iji nye onye ọrụ ohere ime anya site na ndị ọbịa niile nọ na netwọkụ, jiri syntax dị n'okpuru:

MariaDB [(none)]> GRANT ALL ON database_name.* to 'database_username'@'10.24.96.%' IDENTIFIED BY 'database_password';

Mgbe ịmechara mgbanwe ndị a dị n'elu, gbalịa jikọọ na MySQL nchekwa data nkesa ọzọ. Njikọ kwesịrị ịga nke ọma dị ka egosiri na nseta ihuenyo na-esonụ.

# mysql -u database_username -p -h 10.24.96.6

Anyị nwere olile anya na ngwọta a nyeere gị aka idozi njehie njikọ dịpụrụ adịpụ Mysql gị. Ọ bụrụ na ị nwere ajụjụ ọ bụla kpọtụrụ anyị site na mpempe nzaghachi n'okpuru.