Driver driver = (Driver) Class.forName( ServerTreeNode.driverName ).newInstance();
DriverManager.registerDriver( driver );
connection = DriverManager.getConnection( connURL, userID, passWord);试一下,我一直用的就是那个org.gjt包,没问题的。而且也是2.0.4最好用了:)
DriverManager.registerDriver( driver );
connection = DriverManager.getConnection( connURL, userID, passWord);试一下,我一直用的就是那个org.gjt包,没问题的。而且也是2.0.4最好用了:)
Connection conn = null;
Statement stmt= null;
ResultSet rs = null;
String sql="select * from test";
Class.forName(driver);
conn = DriverManager.getConnection("jdbc:mysql://localhost/caac?user=root&password=12345678");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
你试试看!!!
java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.init(MysqlIO.java:446)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1605)
at com.mysql.jdbc.Connection.connectionInit(Connection.java:1056)
at com.mysql.jdbc.Driver.connect(Driver.java:297)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.touch.MysqlConn.getConnection(MysqlConn.java:88)
at com.touch.NewsConnBean.getNews(NewsConnBean.java:63)
at website.TestNews.getNews(TestNews.java:34)
at website.TestNews.main(TestNews.java:25)我检查过数据库mysql的 user表 记录root的 所有字段都是给予了y,按理说root就应该可以执行查询的权限的,我也不知道哪里出了问题.
你试试看在mysql下用root能否登陆!或者新建一个database用户
Enter Password://输入密码
mysql>usr mysql
database changed
mysql>select * from user
然后可以查询到所有的记录
,我的root用户还有什么问题吗?
2。你建立一个新的用户,记住要分配它localhost登陆的权限,在试!然后我也不知道了!
如:
grant all on databaseName.* to yanyan identified by "123456";
flush privileges;
就把databaseName数据库的权限赋给了yanyan用户,并刷新。然后修改
private static String MysqlJdbcURL = "jdbc:mysql://localhost:3306/caac?user=yanyan&password=123456";
就可以了!
grant all on databaseName.* to yanyan@localhost identified by "123456";
我觉得好像没问题了.java.sun.com上有人发贴,很多是我这个问题,
但是我还找不到什么原因,
有可能是这个问题吧
虽然很不好用,jsp,ejb,EJB写不了,很多jar包没有,但是application java文件还是可以
写的,而且可以运行,我在require library 中加了MysqlDriver( mm.msql-2.0.4-binjar)自定义的
库..我以前都是这样用的.
会不会是我 的mysql配置的问题,,但是我有不知道哪里错了?
shell>mysql -h 127.0.0.1 -u root -p
Enter password
果然登录不进去,我用了mysql> grant all privileges on *.* to [email protected] identified by 'some_pass' with grant option;
mysql> grant all privileges on *.* to root@host_name identified by 'some_pass' with grant option;
然后重启mysql就可以了,