mysql> GRANT USAGE ON *.* TO root@'%' IDENTIFIED BY '123456'; 会提示“ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)” 我就重新设个用户,但还是错的呀~~ ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)
mysql>grant all on *.* to lap11@'%' identified by '123456';
grant all on *.* to root@'%' identified by '123456'; 还是一样的提示: ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)
你需要以root用户登陆,才可以grant。mysql -uroot -p enter password: ...
OK了,谢谢 mathematician(数学家) grant all on *.* to root@'%' identified by ''; 密码要为空就可以, 不过我发现一个很奇怪的问题, 另外也试了几个别的密码,其他的密码都不行,只能空密码和1的密码才行, 也可以多位的1,比如11111,但111110什么的就不行,
会提示“ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)”
我就重新设个用户,但还是错的呀~~
ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)
还是一样的提示:
ERROR 1045:Access denied for user:'[email protected]' (Using password:YES)
enter password:
...
Query OK, 0 rows affected<0.00 sec>
grant all on *.* to root@'%' identified by '';
密码要为空就可以,
不过我发现一个很奇怪的问题,
另外也试了几个别的密码,其他的密码都不行,只能空密码和1的密码才行,
也可以多位的1,比如11111,但111110什么的就不行,
mysql>flush privileges;