Failed to connect to MySQL database


#1

Hello,

I get the following error when connecting to a MySQL database. I’m using credentials and port that work successfully on MySQL Workbench. Any debugging suggestions?

Alan

12-24 18:48:24 e[1mINFO metabase.dbe[0m :: Verifying mysql Database Connection …
12-24 18:48:25 e[1mERROR metabase.drivere[0m :: Failed to connect to database: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘sjpcbak2_alanwbaker’@‘c-73-41-59-22.hsd1.ca.comcast.net’ to database ‘sjpcbak2_casp’
12-24 18:48:25 e[1mERROR metabase.coree[0m :: Metabase Initialization FAILED
java.lang.AssertionError: Assert failed: Unable to connect to Metabase mysql DB.


#2

Hi @alanwbaker
It says Access denied for user, so you probably have some permissions set on the user sjpcbak2_alanwbaker like specific host.