MySQL 赋予用户权限

Question

MySQL 赋予用户权限

The user specified as a definer ('root'@'%') does not exist
我给其赋权限

mysql> grant all privileges on *.* to root@"%" identified by ".";
报错：
ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)

Answer 1

grant all privileges on *.* to root@"%"

这样才是空密码