我知道我可以在MySQL中关闭安全模式,所以我不想解决这个问题。
我有张简单的桌子:
create table rubbish(
id int auto_increment primary key,
stuff text,
nonsense text
);
这里,id是主键。
打开安全模式后,我尝试如下:
update rubbish set nonsense=stuff where id=id; -- fails
update rubbish set nonsense=stuff where id is not null; -- fails
upda
即使我将安全组设置为允许所有流量,仍然会显示以下错误。如何正确设置安全规则?
Warning: mysqli_connect(): (HY000/1130): Host '123.202.164.45' is not allowed to connect to this MySQL server in /Applications/XAMPP/xamppfiles/htdocs/data.php on line 16
Failed to connect to MySQL: Host '123.202.164.45' is not allowed to connec