在h9下?tomcat5.0+mysql4.0.12配置连接池问题:

在h9下?tomcat5.0+mysql4.0.12配置连接池问题:

在H9下?TOMCAT5.0+MYSQL4.0.12配置连接池问题:

授权--建库--建表
mysql> GRANT ALL PRIVILEGES ON *.* TO javauser@localhost
    ->   IDENTIFIED BY 'javadude' WITH GRANT OPTION;
mysql> create database javatest;
mysql> use javatest;
mysql> create table testdata (
    ->   id int not null auto_increment primary key,
    ->   foo varchar(25),
    ->   bar int);
可以看到记录
根据TOMCAT文档,配置好连接池/
运行时报错:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'javauser@127.0.0.1' (Using password: YES)
请高手指点指点,万分感激。。。。。。。      
搞定啦!!!
mysql> GRANT ALL PRIVILEGES ON *.* TO javauser@localhost
-> IDENTIFIED BY 'javadude' WITH GRANT OPTION;
改成:
mysql> GRANT ALL PRIVILEGES ON *.* TO javauser@192.168.0.200
-> IDENTIFIED BY 'javadude' WITH GRANT OPTION;
即KO啦。。