怎么授权? GRANT ALL PRIVILEGES ON *.* TO'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; 这样么? 但是不管用啊..
确实是授权问题。localhost和ip被MySQL认为是两个不同的权限。你的Navicat for MySQL主机名或IP地址改成ip估计也不能访问。 单引号换双引号,用户名不加引号呢?GRANT ALL PRIVILEGES ON *.* TO aa@"%" IDENTIFIED BY "bb";
GRANT ALL PRIVILEGES ON *.* TO'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
这样么? 但是不管用啊..
单引号换双引号,用户名不加引号呢?GRANT ALL PRIVILEGES ON *.* TO aa@"%" IDENTIFIED BY "bb";