Monday, February 15, 2010

Changing mysql password

I was getting below error when I run jUnit tests:


WARN 2010-02-15 13:39:25.602 org.hibernate.util.JDBCExceptionReporter.logExceptions() 
        SQL Error: 0, SQLState: null 
ERROR 2010-02-15 13:39:25.627 org.hibernate.util.JDBCExceptionReporter.logExceptions() 
        Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) 
WARN 2010-02-15 13:39:25.629 org.hibernate.cfg.SettingsFactory.buildSettings() 
        Could not obtain connection metadata 
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

Solution:

I needed to change mysql server password using command line:

mysqladmin -u root -p'oldpassword' password newpass