MYsql数据库ERROR总结 Mysql导入zabbix的sql语句时报错:ERROR 1045 ,28000


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

#ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: YES)

Mysql导入zabbix的sql语句时报错:ERROR 1045 (28000)


描述:2016-08-02 17:30:26 17374 [Warning] 'user' entry '@losnau-223.com' ignored in --skip-name-resolve mode.

2016-08-02 17:30:26 17374 [Warning] 'proxies_priv' entry '@ root@losnau-223.com' ignored in --skip-name-resolve mode.

查看错误日志发现有两个警告(ignored in --skip-name-resolve mode)


描述:忘记密码或者密码错误

mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'(2016-09-05 00:03)


Unknown/unsupported storage engine: InnoDB