修改一下:
3.//结果出现如下问题.不知何故?
SQLExceptionInvalid authorization specification, message from server: "Access denied for user: 'test@UTest' (Using password: YES)"
3.//结果出现如下问题.不知何故?
SQLExceptionInvalid authorization specification, message from server: "Access denied for user: 'test@UTest' (Using password: YES)"
Class.forName("org.gjt.mm.mysql.Driver");
顺便问一句,你安装了mysql的驱动没有?
:)
我查了一下CLASSPATH;CLASSPATH=/home/Test/mysql-connector-java-3.0.14-production/mysql-connector-java-3.0.14-production-bin.jar::/usr/java/j2sdk1.4
.2_05/lib:/usr/java/j2sdk1.4.2_05/jre/lib:/home/xiu/UUWeather/content-engine.jar
也没问题呀!
登陆后,选好数据库,在手工敲入create table COFFEES
(COF_NAME varchar(32),
SUP_ID int,
PRICE float,
SALES int,
TOTAL int);
执行没问题,说明Test用户已经有CREATE权限,为何在java中执行确不行呢?
感谢各路大侠得帮忙!特别是 trampwind(随风) 大哥!一直坚持助人的精神让小弟我感动!