Mysql Server Has Gone Away Xampp

MysqlMysql Server Has Gone Away Xampp

If you are working on XAMPP then you can fix the MySQL Server has gone away issue with following changes. Open your my.ini file my.ini location is (D: xampp mysql bin my.ini) change the following variable values maxallowedpacket = 64M innodblockwaittimeout = 500. I am using XAMPP 1.7.4 and I have setup MySQL to run as a service. I am often receiving the 'MySQL Server Has gone away' message and I understand that it is as a result of the waittimeout or interactivetimeout being low.

Related

App Platform: Run PHP apps without managing servers Product
PHP Error Log: authz_core:error - For files that don't exists on my server Question

Xampp #2006 - Mysql Server Has Gone Away

Question

I got these 2 error

  1. “Packets out of order. Expected 0 received 45. Packet size=4739923” &
  2. “SQLSTATE[HY000] [2006] MySQL server has gone away” HELP MESame application working other server but it’s not working here, please help me.

Related

App Platform: Run PHP apps without managing servers Product

Mysql Server Has Gone Away Xampp How To

Mysql Server Has Gone Away Xampp
PHP Error Log: authz_core:error - For files that don't exists on my server Question

Mysql Server Has Gone Away Xampp Download

Mysql Server Has Gone Away Xampp

Mysql Server Has Gone Away Xampp Error

  • Mohsen47March 30, 2018

    How are you connecting to the database? Please post the code.

    You can also post the last few lines of mysql error log to help you solving the problem.

  • gdlcMarch 30, 2018

    My PHP is in 167.99.59.63 server and database is in 45.55.34.229 server, and also added
    bind-address = 45.55.34.229

    Connection COde
    ‘mysql’ => [
    'driver’ => 'mysql’,
    'host’ => env('DBHOST’, '45.55.34.229’),
    'port’ => env('DB
    PORT’, '25000’),
    'database’ => env('DBDATABASE’, 'g#######’),
    'username’ => env('DB
    USERNAME’, 'g*******’),
    'password’ => env('DBPASSWORD’, ’m########’),
    'charset’ => 'utf8’,
    'collation’ => 'utf8
    unicode_ci’,
    'prefix’ => “,
    'strict’ => false,
    'engine’ => null,
    'timezone’ => ’+05:30’,
    ],
    //DBNAME, USERNAME, PASSWORD hide in this code

    For Error Log, Check this link
    http://167.99.59.63/application/backend/public/

  • gdlcMarch 30, 2018

    Waiting for your valuable suggestion, please suggest me

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Mysql Server Has Gone Away Xampp Free

×