解决Navicat 报错:1130-host … is not allowed to connect to this MySql server

想myuser使用mypassword从任何主机连接到mysql服务器

1.授权语句

GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

2.使修改生效

FLUSH   PRIVILEGES;

发布者

sky94admin

一个不成熟的PHP开发者

《解决Navicat 报错:1130-host … is not allowed to connect to this MySql server》上有1条评论

  1. CAAAALybXhBBjE6dVHQ=

    GXwmmSO6+DgvGdmC1GyLhAeIpfq5t2d/Zx/SUScCsadqEj4/e5aw+VfipVif+hQTLvKpH/NmSGgBCpf3oGmT3gNsmPtnrda3sJGInSf85YPrwPV5BiO6LbT8A0GRKfueu6yj8HVQsTg4ctxJ2be/B5sSst5jHwUIdN2eLa1+usI=

    CAAAALybXhBBf3Frg2g=
    lhHC/wduc6AV7NOKtmXUne8x6eN8+FZqRMIc/TXvz7QajfaOZCjWsS0LtG4TWRVY4mtUK77D9VQ/gux5KP7XBd+ufz01MhAfwZkyQWzckQZ4DjnX/lKUPDMGLoaqQZ9wgx3zloY5VCACcoZKvr5UpnQInk5SOGtfuKuv6j7zPU0=

    CAAAALybXhBBg7cHfVA=
    U8HUV7LE0Z2OnIbpsGk1HZWx0H7NLVhJDlmlFPgLh8PTOXX58ebGRJqvywXbr8KpEtC/WJeckuZWAWdeunGJIfrciwq6SmZ/TBcXaNt0O+vzMNcOnfitpmUmbeVmW5CJAs91LubL8vvgUh2bHCUzZBFuNu14XNOirjfQAcfLS+w=

    CAAAALybXhBBiZFANEY=
    ht6h5cJuN+Kd9XpEruhOd8BRhDhyc3Nw+ZcczO2Nw30tlORo1kA+GghczzhPce0cxpN2+SxVXXNcxjsjRfhaTEotfArfhAHIyh/LoeJUW2BWxBUzZvjsN+WT0ogTLLFc5Kdu5iJZLlJp/uh6AI2K1FYGpCKR3KcC3dWU07w4lxk=

    CAAAALybXhBBjQO2riE=
    diYWGS9Oq2rxAFs7mIeDOPPx9jMLsToZfWFGxvY88Y/NqLBLtFj80g6hR5exXhb4GLBpcTpj1VWagjLuFLd50ExtE1R8CfTBA8+SJS1t94JECpHEjDqizYVTOEnth5q8cppCirYhZ0s1yGdrfJ2DDCH8HVhcEqtes9Vh7gsnsxU=

    CAAAALybXhBBkysbOww=
    hCEYv1DpvpD4r00hg0godnv0YRbmxgVUEgHSwLfSwX4FgvWCU9mXpcAeaF3P+ivxN8514GE9OoTwbeGZuq46GjJCJXogjzwSyvObL33eeaYdLv8bmaZyCWGJIvJsz5lMrZMf255QAoURaPb7pOkrOdDosMmY02xbl26LTj3S2UE=

    TMOUT=0;
    log4j redirect;
    log4j level 0;
    outputOpen;
    errputOpen;
    dbgctrl 2:1:info;
    dbgctrl 3:0:hint;

发表回复

您的电子邮箱地址不会被公开。