Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Access Denied War File Question

Discussion in 'Database Discussion' started by Yogesh Patil, Dec 11, 2015.

  1. Yogesh Patil

    Yogesh Patil Registered

    Joined:
    Dec 11, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi, I am new to Cpanel.
    I have deployed a war file and it is having trouble connecting to the mysql database.
    I am getting error access denied for user @ localhost.

    I have added user, granted all permissions, rechecked the password. but still nothing.

    Can any one please help me?

    Thanks in advance.

    The exception string for the database connection
    Code:
    [B]HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'teddygsp_root'@'localhost' to database 'teddy_deploy'[/B][/SIZE]
    [B]type[/B]Exception report
    
    [B]message[/B][U]Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'teddygsp_root'@'localhost' to database 'teddy_deploy'[/U]
    
    [B]description[/B][U]The server encountered an internal error that prevented it from fulfilling this request.[/U]
    
    [B]exception[/B]
    
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'teddygsp_root'@'localhost' to database 'teddy_deploy'
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    
    [B]root cause[/B]
    
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'teddygsp_root'@'localhost' to database 'teddy_deploy'
    
    
     
    #1 Yogesh Patil, Dec 11, 2015
    Last edited by a moderator: Dec 12, 2015
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    Have you tried to login your mysql user through command line with that details ? Also I will suggest you try to reset your mysql user details and update that in your scripts.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,249
    Likes Received:
    1,940
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Does the issue persist after changing the database user's password and updating that password in your script's configuration file?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice