Access Denied War File Question

Yogesh Patil

• December 11, 2015 23:56

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
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' typeException report messageRequest 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' descriptionThe server encountered an internal error that prevented it from fulfilling this request. exception 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) root cause 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'

• 

  24x7server

  • December 12, 2015 10:54

  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.

  0
• 

  cPanelMichael

  • December 14, 2015 12:48

  Hello :) Does the issue persist after changing the database user's password and updating that password in your script's configuration file? Thank you.

  0

Please sign in to leave a comment.