想myuser使用mypassword从任何主机连接到mysql服务器
1.授权语句
GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
2.使修改生效
FLUSH PRIVILEGES;
解决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;
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;