grant 用法的纠结 帮帮忙
mysql 中新增一个用户lfb 给新用户增加操作权限

grant all privileges on *.* to lfb@'%';

有错误,提示：ERROR 1045 (28000): Access denied for user 'lfb555'@'%' (using password: YES)
望高手指点！

[解决办法]
用root用户登陆mysql执行

grant all privileges on *.* to 'lfb'@'%' identified by 'password';
flush privileges;