先select user(); 然后show grants for 第一步打印出来的用户和host;
grant all privileges on *.* to root@'%' identified by "Passwd";
执行 SHOW GRANTS FOR root@localhost 显示 Grants for root@localhost GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*C2BD52860ACC98B2AEBA75DA5E0ACB63841C1BD6' WITH GRANT OPTION GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
让你贴 show grants,为什么你要贴SHOW GRANTS FOR root@localhost?!
然后show grants for 第一步打印出来的用户和host;
SHOW GRANTS FOR root@localhost
显示
Grants for root@localhost
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*C2BD52860ACC98B2AEBA75DA5E0ACB63841C1BD6' WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
让你贴 show grants,为什么你要贴SHOW GRANTS FOR root@localhost?!