ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

自己总结一下：

先用  show grants root@localhost;

然后，用  grant all  加上  with option

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 

//本地操作的权限

mysql> GRANT ALL PRIVILEGES ON *.* TO ' root '@'%'

->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;