title: Flutter mysql1 got packets out of order
body: <p>I have some troubles in setting up a connection with my VPS with the library <code>mysql1</code> on flutter. I get this error <code>Unhandled Exception: Error 1156 (08S01): Got packets out of order</code> when I perform a query.</p>
  <p>MySQL server version: 8.0.28</p>
  <p>This is my service in which I perform the connection with my database.</p>
  <pre><code>var settings = ConnectionSettings(
      host: 'MY_ADDRESS', 
      port: 3306,
      user: 'root',
      password: 'MY_PASSWORD',
      db: 'MY_DATABASE'
  );
    
  Future connect() async {
      return await MySqlConnection.connect(settings);
  }
  </code></pre>
  <p>And then I try to retrieve users information in another method in this way:</p>
  <pre><code>var connection = await mysqlService.connect();
  
  var res = await connection.query('select name from users');
  
  await connection.close();
  </code></pre>
  <p>The problem is in the connection.query function which generate the error:</p>
  <pre><code>[VERBOSE-2:ui_dart_state.cc(209)] Unhandled Exception: Error 1156 (08S01): Got packets out of order
  #0      Handler.checkResponse
  package:mysql1/…/handlers/handler.dart:77
  #1      QueryStreamHandler.processResponse
  package:mysql1/…/query/query_stream_handler.dart:50
  #2      ReqRespConnection._handleData
  package:mysql1/src/single_connection.dart:349
  #3      ReqRespConnection._handleHeader
  package:mysql1/src/single_connection.dart:318
  &lt;asynchronous suspension&gt;
  #4      ReqRespConnection._readPacket
  package:mysql1/src/single_connection.dart:303
  &lt;asynchronous suspension&gt;
  </code></pre>
  <p>I Am not sure if it is a problem with the database that I have on my VPS or is something else.</p>