Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (u

[jethro]

This is my first JSP application using mysql database connection. My application is reporting this error: "Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))".

This is what my script look like:

context.xml:
<Context antiJARLocking="true" path="/5GMODS"> <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
     maxActive="100" maxIdle="30" maxWait="10000" removeAbandoned="true"
     username="root" password="jethro" driverClassName="com.mysql.jdbc.Driver"
     url="jdbc:mysql://127.0.0.1:3306/erata" /> </Context>
 
 web.xml:
<resource-ref> <description>DB Connection Pool</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref>
 
 TestDBConnection java class:
public boolean isValid()
    {
 
        // Get a connection from the pool
 
 
         try
         {
              pool = (DataSource)ctx.lookup("java:comp/env/jdbc/TestDB");
              conn = pool.getConnection();
 
             if (pool != null)
             {
                return true;
 
             }
            else
            {
                 err="Unknown DataSource 'jdbc/TestDB'";
                 return false;
            }
        }
        catch(Exception e)
        {
            //System.out.println(e);
             err=e.getMessage();
             return false;
        } 
 
 
           //return status;
 
    }

I am actually using the mysql server in wamp. From the command prompt, i am successful connecting to the mysql server as root(username) and jethro(password). It just not working with my application. Please help me to forge ahead with this project.

[manageknowledge]

Is the port 3306 correct?