How to Install NGINX and PHP 7.3 with PHP-FPM on RHEL/CentOS 7

Basic Server Setup

Setup Default PHP Version

Setup NGINX and PHP-FPM

Update Configuration

Create Virtual Hosts

Setup Firewall (Optional)

SELinux Settings (Optional for SELinux enabled)

Reboot after Setup

How to Install MySQL 8.0 on RHEL/CentOS 7

Basic Server Setup

Setup MySQL 8.0

Setup Firewall (Optional)

Reboot after Setup

Optional Settings for MySQL 8.0

Disable MySQL Strict Mode

Reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

Fix MySQL Password Expired

To establish a global policy such that passwords never expire.

Update /etc/my.cnf

Reference: https://dev.mysql.com/doc/refman/8.0/en/password-management.html#password-expiration-policy

How to enlarge CentOS 7 persistent disk size in Google Cloud

Update Disk Size

Update Partition Size

Update Volumn Size

OR

References

Auto Launch Chrome in Kiosk Mode/Fullscreen Mode with specified URL on macOS Startup

Setup Steps:

  1. Start Automator.app
  2. Select Application
  3. Click Show library in the toolbar (if hidden)
  4. Add Run shell script (from the Actions/Utilities)
  5. Paste the script into the script window
  6. Test run
  7. Save somewhere (for example you can make an Applications folder in your HOME, you will get an your_name.app)
  8. Go to System Preferences -> Accounts -> Login items
  9. Add this app
  10. Try reboot

Kiosk Mode Script

Fullscreen Mode Script

References

Install and Secure Redis on CentOS 7

 

Redis Installation

Add the EPEL repository, and update YUM

 

Install Redis

 

Start Redis and setup automatically start Redis on boot

 

Verify the Installation

If Redis is running, it will return: PONG

 

Redis Configuration

Password settings

find and uncomment the requirepass line in the configuration file, and replace master_password with a secure password

 

Firewall settings

 

Local Benchmark Test

 

Check Redis Version

 

Setup PHP session to Redis

 

 

How to fix MySQL connection error: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

The problem is some MySQL clients not yet support new password encryption method.

 

Just change the user password encryption back to legacy version, then problem will be fixed.

The following SQL update specific user to legacy encryption:

 

Also, you can change the default authentication plugin to legacy version.

Update /etc/my.cnf and add the following line after [mysqld]:

 

 

Install wkhtmltopdf & wkhtmltoimage to CentOS with Chinese & Asian fonts support

Install dependencies

 

Install wkhtmltopdf and wkhtmltoimage

p.s. you can find more versions in the following link:

https://github.com/wkhtmltopdf/wkhtmltopdf/releases

 

Install  Chinese & Asian fonts support

 

References

https://wkhtmltopdf.org/

Add swap to CentOS without reboot

Add 4G swap