Configure LAMP on VPS

• LAMP (APACHE & MYSQL & PHP):
  Now, instead of the combined articles (i.e. install-lamp-1 or install-lamp-2 ) I advise more specific oriented articles:
  – install apache
  – install mysql
  – install php: 1) Install phpbrew  2) try  blog/docker-php-8-zts-apache-swoole-parallel & gmp install 3) might need to add AddType application/x-httpd-php .php in /etc/apache2/mods-available/php.load
• WordPress (with mysql):
  – ubuntu tutorial
  – do.com/wordpress-on-ubuntu

• [PHP]:
  – Install Redis Cache
  – Install MBstring : sudo apt-get install php-mbstring php8.1-mbstring php-gettext libapache2-mod-php8.1
• Install & Configure mail: article1 | article2

### MYSQL ###

• Add/Create user: CREATE USER ‘myuser1’@’192.168.1.123’ IDENTIFIED BY ‘password123’;
  GRANT ALL PRIVILEGES ON dbnamee.* TO ‘myuser1’@’192.168.1.123’;
  FLUSH Privileges;
• reset root pass;
• user password change : 
  ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxx';
• disable mysql-logs : se.com/delete-mysql-bin-files & se.com/disable-mysql-logging
  /etc/mysql/my.cnf – >
  [mysqld]
  max_allowed_packet = 512M
  skip-log-bin
  binlog_expire_logs_seconds=1600 In mysql:  SHOW VARIABLES LIKE ‘max_allowed_packet’;
  SET @@global.max_allowed_packet = 16777215;
  SHOW VARIABLES LIKE ‘max_allowed_packet’;