Yadda za a gyara Kuskuren 1130 (HY000): Ba a yarda mai watsa shiri ya haɗa da wannan sabar ta MySQL ba

A cikin wannan labarin mai sauri, zaku koyi yadda ake warware\"ERROR 1130 (HY000): Ba a yarda mai karɓar xxxx ya haɗu da wannan kuskuren MySQL ɗin ba a cikin tura bayanan MySQL/MariaDB akan tsarin Linux. Wannan ɗayan ɗayan gama gari ne kurakuran haɗin haɗin keɓaɓɓun bayanan da masu amfani suka ci karo dasu.

• Sabis ɗin Aikace-aikacen IP: 10.24.96.5
• Database Server IP: 10.24.96.6

Mun sami kuskuren yayin gwajin haɗin bayanan daga ɗayan sabar aikace-aikacenmu zuwa uwar garken bayanai, ta yin amfani da mysql abokin ciniki kamar yadda aka nuna.

# mysql -u database_username -p -h 10.24.96.6

Kuskuren ya nuna cewa mai masaukin 10.24.96.5 cewa mai amfani da bayanan bayanan yana haɗawa ba a ba shi izinin haɗi zuwa uwar garken MySQL ba. A wannan yanayin, dole ne muyi wasu canje-canje ga sabar bayanan don bawa mai amfani damar haɗuwa da nesa.

A kan sabar bayanan, dole ne mu bincika mai masaukin da aka ba shi izinin haɗi daga.

# mysql -u root -p

Gudun waɗannan umarnin SQL don bincika rundunar mai amfani:

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

Daga fitowar umarnin, ana bawa mai amfani damar haɗi kawai zuwa uwar garken bayanai daga localhost. Don haka, muna buƙatar sabunta rundunonin mai amfani kamar haka.

Gudun wannan kyautar ta kyauta don bawa damar MySQL ga mai amfani daga nesa daga masaukin mai nisa. Tabbatar da maye gurbin\"10.24.96.6" tare da adireshin IP na tsarin nesa, da\"database_password" zuwa kalmar wucewa da kuke so\"database_username" don amfani:

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";

Don bawa mai amfani damar zuwa nesa daga duk mahaɗan akan hanyar sadarwa, yi amfani da rubutun da ke ƙasa:

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

Bayan yin canje-canjen da ke sama, yi ƙoƙarin haɗi da nesa zuwa uwar garken bayanan MySQL sau ɗaya. Haɗin haɗin ya zama mai nasara kamar yadda aka nuna a cikin hoton da ke gaba.

# mysql -u database_username -p -h 10.24.96.6

Muna fatan wannan maganin ya taimaka muku wajen warware kuskuren haɗin Mysql ɗinku na nesa. Idan kuna da kowace tambaya ta isa gare mu ta hanyar fom ɗin da ke ƙasa.