Bug #107555 [Deleted]

• Submitted: 14 Jun 2022 1:46
• Modified: 14 Jun 2022 2:04
• Reporter: Thomas Yip
• Status: Not a Bug
• Category: MySQL Server
• Severity: S7 (Test Cases)
• Version: 8.0.21
• OS: Any
• CPU Architecture: Any
• Tags: WBBugReporter

[14 Jun 2022 1:46] Thomas Yip

Description:
When attempting to connect to a MySQL database from a remote server in Ireland,  (even after verifying the connection string), the following error is returned:

CC.Share.SqlUtils.GetCredentials MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'fe450admin-ire.c1anl4gjgulx.eu-west-1.rds.amazonaws.com' for user 'readonly' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
   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.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   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 CC.Share.SqlUtils.GetCredentials(Credentials cres) in C:\Users\hpark\SVN\CC\LocalDbServer\LocalDbServer\Share\SqlUtils.cs:line 24

How to repeat:
Attempt to establish a connection to a remote MySQL database using Mysql.Data.MySqlClient library and the connection string.