数据库拒绝报错：

2019独角兽企业重金招聘Python工程师标准>>>

查看日志：less /var/log/zabbix/zabbix_server.log

926:20170911:104146.289 cannot set MySQL character set to "utf8"
   926:20170911:104146.289 database is down: reconnecting in 10 seconds
   926:20170911:104156.290 [Z3001] connection to database 'zabbix' failed: [1045] Access 
denied for user 'zabbix'@'localhost' (using password: YES)  //这句是重点，mysql拒绝zabbix访问
   926:20170911:104156.290 cannot set MySQL character set to "utf8"
   926:20170911:104156.290 database is down: reconnecting in 10 seconds
   926:20170911:104206.291 [Z3001] connection to database 'zabbix' failed: [1045] Access 
denied for user 'zabbix'@'localhost' (using password: YES)

[root@DasonCheng ~]# ps aux |grep zabbix
zabbix      926  0.0  0.3 255688  3832 ?        S    10:21   0:00 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
root       2722  0.0  0.0 112668   972 pts/0    S+   10:37   0:00 grep --color=auto zabbix
……
[root@DasonCheng ~]# netstat -lntp |grep 10051  //服务端是10051，客户端10050；发现zabbix端口没有启动！
[root@DasonCheng ~]# netstat -lntp |grep zabbix

我在想啊，之前创建用户的时候
grant all on zabbix.* to 'zabbix'@'127.0.0.1' identified by 'aming-zabbix'; 这不是已经赋予了权限了么？
网上搜了一下，估计还是权限的问题：
http://www.bubuko.com/infodetail-2040652.html
我没有按照搜索的执行，而是把创建用户赋予权限的语句，又执行了一遍；端口就启动了，一切就正常了；

转载于:https://my.oschina.net/u/3651233/blog/1534981