10 MySQL settings to tune after installation

GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.webhost.net' IDENTIFIED BY 'root-password-here';

STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 2G innodb_log_file_size…