mysql mireadb access denied

mysql 从命令行连接失败：

Warning: Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'hostbll'@'10.10.253.220' (using password: YES)

貌似在

mireadb只修改时，只能登录到相应的服务器上执行才行。

你虽然添加了用户：

CREATE USER user1@db1 IDENTIFIED BY 'pass1'

但还是需要给授权才能访问到：

GRANT all privileges ON db1.table1 to 'user1'@'1.2.3.4' IDENTIFIED BY 'pass1';

(注意后面一定要跟上密码 identified by )

FLUSH PRIVILEGES;