I am trying to connect to azure-mysql-db from non-azure vm but getting below error -
- It's being allowed through firewall, I checked the logs but refusing by database.
Connection verification failed for data source: mydatasource
java.sql.SQLException: Access denied for user 'mydatasource'@'18.104.22.168' (using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user 'mydatasource'@'22.214.171.124' (using password: YES).
Can anyone please help me with this.
Copy link to clipboard
You need to find out where the problem is. Otherwise, everyone will just be guessing.
(Update, I added points 3 and 4 right after initially submitting this reply. I hope you may see that before responding, if perhaps you saw the response as sent to you from this forum when I first posted it, as this update will also be sent.)
Let's hear your answers to those before making still more guesses. (Or maybe someone else will jump in seeing an answer already.)
Issue resolved .I figured it out, It was due to ' &serverTimezone=UTC ' parameter I was passing through jdbc connection string at coldfusion datasource configuration.
Removed this particular parameter and it could able to fetch the date as it is from the database as well as printing the correct now date as well.
So seems everything is perfect now.
Good to hear it's resolved. It's curious to hear that that conn string value alone would cause that error. But the steps in my points 1 and 2 would have helped confirm if it had to be something set in CF. 🙂
Thanks for the update.