太郁闷了 ！
我安装了JDK1.5+Tomcat5.028,作为web应用服务器，然后安装了mysql4.1(原来安装了5.0，同样的问题后删掉了)
＊＊＊＊＊＊＊＊＊＊软件环境 ＊＊＊＊＊＊＊＊＊＊＊＊
jdk1.5.0_10
jakarta-tomcat-5.0.28
mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
tomcat服务器工作正常。。。
创建了mysql的系统用户用户，
$ sudo chown -R root /opt/mysql
$ sudo chown -R mysql /opt/mysql
$ sudo chown -R mysql /opt/mysql/data
$ sudo chown -R root /opt/mysql/bin
$ sudo chgrp -R mysql /opt/mysql
＊＊＊＊＊＊＊＊＊＊root密码和创建数据库 ＊＊＊＊＊＊＊＊＊＊
.$ sudo /opt/mysql/bin/mysqld_safe --user=mysql &
$ cd /opt/mysql
$ sudo ./bin/mysqladmin -u root password 123456
$ sudo ./bin/mysql -p
Enter password:
mysql> create database sampledb;
Query OK, 1 row affected (0.06 sec)
mysql> grant all on sampledb.* to root@localhost identified by "123456";
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on sampledb.* to root@192.168.1.100 identified by "123456";
Query OK, 0 rows affected (0.01 sec)
mysql> quit;
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
在web配置文件中，配置用户root，密码123456
使用Mysql administrator打开数据库一切正常，用户权限分配正确
但是在web 应用程序login的时候，提示出错，如下：
＊＊＊＊＊＊＊＊＊＊＊＊日志＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
$ cat catalina.out
.......
.......
Access denied for user 'root'@'localhost' (using password: YES)
WARN [http-8080-Processor22] (RequestProcessor.java:516) - Unhandled Exception thrown: class java.lang.NullPointerException on 2006.12.06 at 03:42:21 EST
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
测试防火墙是否阻挡3306端口
$ telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
=
4.1.22-standardubly9Qh<,/v*hQ<v^Se%%Connection closed by foreign host.
请高手帮忙分析原因！
常见的密码错误／root没有权限／防火墙都试过了，没有解决！
高手高手高手在哪里 ？
[讨论]看来只有请教高手了，Mysql Access Denied 密码正确，数据已授权，3306端口可以访问
-
toby.bian
- 帖子： 1
- 注册时间： 2006-12-06 15:55
