root@vps27625:~# mysql -u root -pWelcome to the MySQL monitor.Your MySQL connection id is 4604但是,如果我使用任何sql客户端,则会引发错误1045,拒绝用户根的访问(使用密码: YES)
发生这种情况的可能原因是什么?
我在Azure上有一台mysql服务器(例如13.25.147.140)。= utf8default-character-set = utf8GRANT ALL PRIVILEGES ON *.* TO 'root'@'57.26.24.157' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql
Warning: mysqli_connect(): (HY000/1130): Host '123.202.164.45' is not allowed to connect to this MySQLserver in /Applications/XAMPP/xamppfiles/htdocs/data.php on line 16
Failed to connect to MySQL: Host'123.202.164.45' is not allowe