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

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

Cara untuk fix isu ni..

1. Mula - mula check port mysql dulu. Check samada port duplicate atau tidak. 

mysql> SHOW GLOBAL VARIABLES LIKE 'PORT';

Rujukan : How to check what port mysql is running on

2. Allow connection from user and host

mysql> GRANT ALL ON *.* to root@'127.0.0.1' IDENTIFIED BY 'root'










Rujukan : Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

3. Change definer on view