• notice
  • Congratulations on the launch of the Sought Tech site

MySQL bug finishing

Sorted out some error messages encountered

  1. Remote connection server database error:

    Host'XXXXXX' is blocked because of many connection errors.

    Sol:

    show  global variables like ' % max_connect_errors % ';set global max_connect_errors=1000000;

    But this is not the fundamental solution to the problem, it can only be effective for a while, and it is effective forever.You can refer to the following article:
    https://blog.csdn.net/li_li_l...

  1. Errors related to permissions

    ERROR 1290 (HY000): The MySQL server is running with the â€”skip-grant-tables option so it cannot execute this statement.

    Sol:

    Refresh the list of permissions flush privileges;
    grant permissions: grant all privileges on . To USER@'%'identified by'password';

  2. The SQL statement is too long and the execution fails
    Sol:

    Change the maximum limit

  3. set  global max_allowed_packet =  6 * 1024 * 1024 ;


    Tags

    Technical otaku

    Sought technology together

    Related Topic

    1 Comments

    author

    buy lipitor sale & lt;a href="https://lipiws.top/"& gt;cost lipitor 80mg& lt;/a& gt; order atorvastatin 20mg online cheap

    Qqlftm

    2024-03-08

    Leave a Reply

    +