My SQL SERVER CAN'T Connect

[answeriver]

Please need help ASAP. Cant connect already two weeks, and project already started

I need to connect to MySQL (on supplier side).  Connector installed (two months ago alreadry used this server). But in new project security team makes changes for security server.

So now i have:

login and password from My SQL Server

login and password from database (which i need) in this server

Port which i need to use.

But all of isn't work. And i get this error

What i can do?

[Greg_Deckler]

https://bugs.mysql.com/bug.php?id=75917

http://www.voidcn.com/article/p-phfoefri-bpr.html

https://stackoverflow.com/questions/26652833/reading-from-the-stream-has-failed-mysqlexception

There is a lot of information out there about bugs with this so may be an issue with your version of MySQL

[mwegener]

Hi @answeriver ,

enable tracing to get more information.

https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-sign-in#how-to-collect-a-trace-in-...

[answeriver]

@mwegener 

thanks for link, I have log file, but i dont understand all of this.

Actauly, if the srever has two step autentification, but i use only one. Maybe i need sql command which i need use firstly password from server&

[mwegener]

Hi @answeriver ,

I couldn't find anything in the log file.

I do not know the two step authentication, can you describe it further?

do you use SSL certificates?

https://community.powerbi.com/t5/Power-Query/How-to-connect-to-a-datasource-with-SSL/m-p/671941

[answeriver]

@mwegener ssl not use.
Data source has two steps of credentials (as supplier say)
First is for enter in server
Second is for the database which I need.
I think all of problem in my situation is the supplier dont know about power bi, that's why he don't help me in this

[mwegener]

Hi @answeriver 

can you share the log files with us?

[answeriver]

@mwegener yes.  Below

bjectCacheSessions/Data/CacheStats/Size {"Start":"2020-04-22T02:24:48.9996114Z","Action":"ObjectCacheSessions/Data/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001336"}
ObjectCacheSessions/Data/CacheStats/Access {"Start":"2020-04-22T02:24:49.0001835Z","Action":"ObjectCacheSessions/Data/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000342"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2020-04-22T02:24:49.1038888Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.4145351"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2020-04-22T02:24:49.5184469Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.1349693"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:24:49.9025998Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:00.0062782"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:25:49.9379593Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0002775"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:25:49.9382607Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000062"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:25:49.9741917Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9248355"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:26:49.8995732Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000339"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:26:49.8996452Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000141"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2020-04-22T02:24:49.1016097Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:02:00.7904630"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2020-04-22T02:24:49.0253167Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.6298648"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2020-04-22T03:23:42.5786061Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0114522"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2020-04-22T03:23:42.5903285Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001891"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:23:42.5933473Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9123595"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:24:42.5059085Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000142"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:24:42.5059301Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000108"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:24:42.5066378Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9998182"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:25:42.5068040Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000491"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:25:42.5068746Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000139"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2020-04-22T03:23:42.5785933Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:59.9285806"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2020-04-22T03:23:42.5781114Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0124273"}