Error 'MySQL server has gone away' during installation
Details
During installation, the following message displays:
MySQL server has gone away
Solution
Set the value of table_open_cache to a value of at least 250 as follows:
-
As a user with
root
privileges, open the MySQL configuration file in a text editor.Ubuntu 16:
/etc/mysql/mysql.conf.d/mysqld.cnf
Ubuntu earlier than 16:
/etc/mysql/my.cnf
CentOS:
/etc/my.cnf
-
Search for an existing
table_open_cache
setting. If there is none, add one. -
Set the value to at least 250:
table_open_cache=250
-
Save your changes to
my.cnf
and exit the text editor. -
As a user with
root
privileges, restart the MySQL service:Ubuntu:
service mysql restart
CentOS:
service mysqld restart