mysql数据库访问问题吗_关于mysql数据库连接问题

在mysql下创建了个zabbix库。也给他负了权限：mysql-uroot-pzhao@123createdatabasezabbix;grantallonzabbix.*tozabbix@localhostidentifiedby'123456';flushprivileges;可是启动应用...

在mysql下创建了个zabbix库。也给他负了权限：

mysql -uroot -pzhao@123

create database zabbix;

grant all on zabbix.* to zabbix@localhost identified by '123456';

flush privileges;

可

是启动应用还是报错 15355:20140820:132920.362 [Z3001] Connection to database

'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost'

(using password: YES)

另，执行这个几条命令报错是啥原因

cat ./create/schema/mysql.sql |mysql -uroot -pzhao@123 zabbix

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

ERROR

1064 (42000) at line 1: You have an error in your SQL syntax; check the

manual that corresponds to your MySQL server version for the right

syntax to use near 'type=InnoDB' at line 6

cat ./create/data/data.sql |mysql -uroot -pzhao@123 zabbix

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

ERROR 1146 (42S02) at line 24: Table 'zabbix.config' doesn't exist

这是完整都日志

Starting Zabbix Server. Zabbix 1.8.2 (revision 11211).

**** Enabled features ****

SNMP monitoring: YES

IPMI monitoring: NO

WEB monitoring: YES

Jabber notifications: NO

ODBC: NO

SSH2 support: NO

IPv6 support: NO

**************************

[Z3001] Connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)

展开