关于mysql数据库连接问题

Question

在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)

Answer 1

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

这里提示是你的密码没有设置成功，所以你用zabbix用户登录时会报错
mysql> grant all on zabbic.* to 'zabbix'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@localhost wwwroot]# mysql -u zabbix -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.50-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

这个就成功了。
后面的你可以把你的sql文件贴出来，报的都是sql文件的错。

追问

那我执行MySQL -uzabbix -p123456能够进入数据库啊？为哈

追答

这句本来就是对的啊，肯定能进入的啊

追问

那我现在该改什么呢

追答

你不是该解决下面两个导入sql的错误吗，是我理解错了你的意思吗？

追问

我想知道，是不是下面两个问题导致的上面第一个问题，就是日志报错那个。。。下面两个sql错误是啥原因呢

追答

near 'type=InnoDB' at line 6
，这个是你SQL创建表的时候在InnoDB附近有错误， 跟第一个报错应该没关系。
ERROR 1146 (42S02) at line 24: Table 'zabbix.config' doesn't exist，是说这个表不存在就是你前面没创建成功，把InnoDB附近的错误解决了，就这个错误应该不会存在了。还有权限问题你试试看吧。

追问

可能zabbix和mysql数据库版本冲突导致的。InnoDB
这个问题怎么解决呢

Answer 2

如果报错的话把错误贴出来，还有就是你倒没倒连接jar包,3个jar加在程序里了吗？
import java.sql.*;
Connection conn =null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost/mybbs", "root", "root");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
这样可以么？

追问

没看懂啊，我现在是导入数据库sql脚本报错，估计就导致了我启动zabbix_server报错了。虽然zabbi数据库已经付权了