And don't forget to use the -h flag to specify the host you are connecting to on mysql command line.
That might be different, having a FQDN or localhost. Try logging on your mysql database and very the mysql.user and mysql.dbtables. Orlando On 4/20/07, David Smith <[EMAIL PROTECTED]> wrote:
Seems pretty straight forward -- the user/host/password combo you provided isn't valid on your mysql server. Keep in mind mysql doesn't just check username and password, it also checks where you are logging in from (the host). You can test the login credentials by using the mysql command line client from a command shell on your system. --David peri wrote: > Hi, > I'm a new user on tomcat. I'm using tomcat on my local machine for some > application. I use tomcat version 4.1 MySql version 4.1.22 as database and > eclipse 3.2 as ide. while I start tomcat on eclipse I got this error > messsage: > INFO: Initializing, config='ApplicationResources', returnNull=true > 19-Apr-2007 23:00:16 org.apache.struts.action.ActionServlet > initModuleDataSources > SEVERE: Initializing application data source musiccollecton > org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Access denied for user > 'theDatabaseUserN'@'localhost' (using password: YES)) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource( BasicDataSource.java:1225) > at > org.apache.commons.dbcp.BasicDataSource.setLogWriter( BasicDataSource.java:959) > at > org.apache.struts.action.ActionServlet.initModuleDataSources( ActionServlet.java:1087) > at org.apache.struts.action.ActionServlet.init(ActionServlet.java :472) > at javax.servlet.GenericServlet.init(GenericServlet.java:212) > at > org.apache.catalina.core.StandardWrapper.loadServlet( StandardWrapper.java:879) > at org.apache.catalina.core.StandardWrapper.load( StandardWrapper.java:767) > at > org.apache.catalina.core.StandardContext.loadOnStartup( StandardContext.java:3483) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java :3709) > at > org.apache.catalina.core.ContainerBase.addChildInternal( ContainerBase.java:776) > at org.apache.catalina.core.ContainerBase.addChild( ContainerBase.java:759) > at org.apache.catalina.core.StandardHost.addChild( StandardHost.java:537) > at > org.apache.catalina.core.StandardHostDeployer.install( StandardHostDeployer.java:260) > at org.apache.catalina.core.StandardHost.install(StandardHost.java :730) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java :625) > at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:374) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java :784) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :330) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( LifecycleSupport.java:119) > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java :1155) > at org.apache.catalina.core.StandardHost.start(StandardHost.java :696) > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java :1147) > at org.apache.catalina.core.StandardEngine.start( StandardEngine.java:310) > at org.apache.catalina.core.StandardService.start( StandardService.java:449) > at org.apache.catalina.core.StandardServer.start( StandardServer.java:2212) > at org.apache.catalina.startup.Catalina.start(Catalina.java:458) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:345) > at org.apache.catalina.startup.Catalina.process(Catalina.java:129) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke( NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:150) > Caused by: java.sql.SQLException: Access denied for user > 'theDatabaseUserN'@'localhost' (using password: YES) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203) > at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572) > at com.mysql.jdbc.Connection.<init>(Connection.java:1485) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :266) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection( DriverConnectionFactory.java:38) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( PoolableConnectionFactory.java:294) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory( BasicDataSource.java:1247) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource( BasicDataSource.java:1221) > ... 32 more > Could anyone help me to solve this exception. Before installing MySQL I > didn't get this error messge. > Thank you very much > Perihan > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
