

Step-by-Step Guide to Install WordPress Manually On Any Web Hosting.How to update PHP version to PHP 7.4 on Ubuntu.Learn WordPress Installation on LEMP Server.How to Install LAMP Stack on Ubuntu 20.04 LTS.Learn to Install LEMP (Nginx, Mysql & PHP7.2) & Configure on Ubuntu.

# systemctl restart mysql apache2 # systemctl status mysql apache2 Finally, restart MySQL and Apache services to apply all settings and verify both services status by issuing the following commands.max_heap_table_size = 98M tmp_table_size = 64M join_buffer_size = 64M innodb_buffer_pool_size = 485M innodb_doublewrite = off innodb_flush_log_at_timeout = 3 innodb_read_io_threads = 32 innodb_write_io_threads = 16 # vi /etc/mysql//50-server.cnf # vi nano /etc/mysql//mysqld.cnf Īdd the following lines to the end of the 50-server.cnf or mysqld.cnf file.

# mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql # mysql -u root -p -e ‘grant select on mysql.time_zone_name to Next, open MySQL server configuration file and add the following lines at the end of the file. Also, issue the below commands to allow cacti user select permissions to MySQL data.timezone setting by issuing the below commands.# mysql -u root -p mysql> create database cacti mysql> grant all on cacti.* to identified by mysql> flush privileges mysql> exit Replace cacti database name, user and password to match your own configurations and choose a strong password for cacti database. Next, log in to MariaDB or MySQL database from your LAMP stack installation and create a database for installing Cacti by issuing the following commands.

# echo “date.timezone = Asia/Karachi” > /etc/php/7.4/apache2/php.ini
