new password will not be effective for connection immediately

2006-04-04 Thread NanFei Wang
Hi, I want to change the password of the User( which is root) in the table 'user' from the database 'mysql'. I use the String sql = update user set Password=password('somePassWord') where User='root'; I see from MySql Query Browser the password really changed ! Before I stop the mysql from

java.net.BindException: Address already in use: JVM_Bind

2006-03-07 Thread NanFei Wang
Dear all: I use Tomcat 5.5.9 and Mysql Server 5.0 (with the driver mysql-connector-java-3.1.12-bin.jar) to run my Application on Windows XP. It run smoothly many times throughout the whole Application without any problem ! But in an unexpected time, I get the following Error messages. I

Stored Procedure in mysql 5.0 failure!

2004-04-06 Thread NanFei Wang
Hi, somebody can help me! my database is: mysql-5.0.0a-alpha the connection driver is:mysql-connector-java-3.1.1-alpha-bin.jar I want to test stored procedure of the new feature in MySQL version 5.0. A I can call the stored procedure procPara in Window Console as next show, but when I run in