这个是错误异常:
为什么只能本机能够连接。我自己连接没问题,那客户端连接有问题,拿Hibernate连接也是这样的。同事连接也是这个样的?
为什么啊?
java.sql.SQLException: null, message from server: "Host 'Adminstrator' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1018)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2568)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:314)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1218)
at com.sangli.Util.HibernateUtil.(HibernateUtil.java:13)
at com.sangli.events.EventsManager.main(EventsManager.java:23)
[b]问题补充:[/b]
不是设置空是设置%哥们 刚解决了。。。。
哦
解决就好,我也没试 呵呵
运行:mysql> grant all on . to name@localhost identified by 'name' ;
如果希望这个mysql用户允许某个来自IP的访问,可以把localhost改成那个IP,如果希望允许某个主机名的访问,可以改为主机名,如果允许所有的远程访问,似乎置空就可以了(未测试)。