Access denied for user 'jg08llk8p534'

[sang-yantra]

Hi. can anyone help please?

I created rest api using ASP.NET and deployed in Heroku. I'm getting the below error after deployment when calling the endpoint.
P.S - the connection is valid in local env

Error:
Authentication to host 'zm42x1ncy7o5.ap-south-2.psdb.cloud' for user 'jg08llk8p534' using method 'mysql_native_password' failed with message: Access denied for user 'jg08llk8p534'
stack trace
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in //Dapper/SqlMapper.cs:line 1093
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable1 commandTimeout, Nullable`1 commandType) in //Dapper/SqlMapper.cs:line 734
at Jira.Ms.Controllers.TaskController.GetTasks() in /tmp/build_894840c2/Jira.Ms/Controllers/TaskController.cs:line 26

[jgreet]

Hi @sang-yantra, are you sure you're using a username/password for the correct branch? It doesn't look like you have a password with username jg08llk8p534 on your branch zm42x1ncy7o5 (dev).

[sang-yantra]

yes, I was using the correct username and password, checked locally. The username jg08llk8p534 got deleted after it threw error.

[Chigala]

How did you fix this? I'm currently facing the same issue

[fooforge]

@Chigala's reached out in a ticket and we were able to resolve this one.

[Xirider]

I have the same issue. I can't get access locally for some reason.