没有指定3306端口
String url ="jdbc:mysql://localhost:3306/test?user=root&password=123&useUnicode=true&characterEncoding=8859_1";
String url ="jdbc:mysql://localhost:3306/test?user=root&password=123&useUnicode=true&characterEncoding=8859_1";
F:\>java DataTool
java.sql.SQLException: Server configuration denies access to data source
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at DataTool.<init>(DataTool.java:11)
at DataTool.main(DataTool.java:20)
你可以看看
use mysql
select * from user;
这里面由详细的权限表你要使用机器名必须分配权限