Laravel : SQLSTATE[HY000] [2006] MySQL server has gone away

Asked Sep 17 '19 at 05:44

Active Sep 17 '19 at 06:22

Viewed 576 times

I use Laravel and XAMPP on Mac OS. here my .env file when I request the data from database I get this error SQLSTATE[HY000] [2006] MySQL server has gone away

here the screen shot

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=8443
DB_DATABASE=test
DB_USERNAME=rdxcft
DB_PASSWORD=rdxcft

and my database.php

'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

thank for your attention

edited Sep 17 '19 at 06:22

asked Sep 17 '19 at 05:44

sogatanco

Why setting `DB_PORT` to 8443 instead of 3306? – Koala Yeung Sep 17 '19 at 05:53
What happens if you ping 127.0.0.1:3306 & 127.0.0.1:8443? – Patrick Sep 17 '19 at 05:55
@KoalaYeung 8443 and 8080 is default port of my Xampp. and I have tried to use 3306 and I get error `no such file or directory` – sogatanco Sep 17 '19 at 06:01
@Patrick I get this error `ping: cannot resolve 127.0.0.1:8080: Unknown host` – sogatanco Sep 17 '19 at 06:03
8443 and 8080 should be the default port of your Apache web server as installed by XAMPP. Not your MySQL server. Do you know the correct port to your MySQL server, if not je default 3306 port? – Koala Yeung Sep 17 '19 at 06:04
@KoalaYeung I don't know. how to check it ?? – sogatanco Sep 17 '19 at 06:07
Please run ***** php artisan config:clear ***** command and also run this ****php artisan key:generate *****. – mukesh kumar Sep 17 '19 at 06:10
I think unless you set it otherwise, it should be 3306. Did you try setting your `DB_PORT` in your .env to 3306? – Koala Yeung Sep 17 '19 at 06:11
@mukeshkumar I still get the same error – sogatanco Sep 17 '19 at 06:12
@KoalaYeung I have tried and I get this error PDOException::("SQLSTATE[HY000] [2002] Connection refused") – sogatanco Sep 17 '19 at 06:13
If you encounter error with the 3306 port setting, please show us the full error message. Thanks. – Koala Yeung Sep 17 '19 at 06:13
Possible duplicate of [ERROR 2006 (HY000): MySQL server has gone away](https://stackoverflow.com/questions/10474922/error-2006-hy000-mysql-server-has-gone-away) – Patrick Sep 17 '19 at 06:15
@KoalaYeung here the screenshot https://ibb.co/cY4c7LH – sogatanco Sep 17 '19 at 06:16
Are you sure your MySQL has started correctly? Also is there any firewall setting that may block the connection? – Koala Yeung Sep 17 '19 at 06:16
@Patrick I have tried that solution but still error – sogatanco Sep 17 '19 at 06:20
@KoalaYeung it runs fine on native and codeigniter php – sogatanco Sep 17 '19 at 06:21
Please check your password and username is correct or not. – mukesh kumar Sep 17 '19 at 06:22
@mukeshkumar my password and username is set correctly – sogatanco Sep 17 '19 at 06:23
Can you show us the codeigniter config and code that works? – Koala Yeung Sep 17 '19 at 06:30
@KoalaYeung If I use Xampp link http://localhost:8080/pengajian/public/about it run correctly. but when I use 127.0.0.1:8000 (the default url of Laravel) I this error `SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from `info`)` here the screenshot :https://ibb.co/wzyCCQr – sogatanco Sep 19 '19 at 15:13
Do you mean your Laravel setup works on your XAMPP environment, but not in the test server started by the command `artisan serve`? – Koala Yeung Sep 20 '19 at 00:19
@KoalaYeung yes. not in the test server started by the command `artisan serve` when retrieving data from database. – sogatanco Sep 20 '19 at 12:56

Laravel : SQLSTATE[HY000] [2006] MySQL server has gone away

0 Answers0