CentOS 7 Linux

Linux CentOS 7 Post Installation
MARIADB - https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-MariaDB-from-5-5-to-5-6-5-7-on-Linux-     MYSQL ACCESS     GRANT ALL ...
Thu, 8 Feb, 2018 at 7:55 PM
Useful PostgreSQL Commands
su postgres  psql  CREATE ROLE xxxx WITH LOGIN ENCRYPTED PASSWORD 'xxxxx';  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ahmed;  ...
Thu, 15 Mar, 2018 at 12:16 PM
Useful MYSQL Commands
BACKUP DATABASES  mysqldump --all-databases -u root -p > all_databases.sql.gz  RESTORE DATABASES  mysql --all-databases -u root -p < all_databas...
Thu, 8 Feb, 2018 at 8:04 PM
XFS Repair Corrupt File System
Boot into system rescue CD  mount /dev/sda1 /mnt  lvdisplay  vgchange -ay  xfs_repair /dev/centos/root  xfs_repair /dev/centos/home  IF REPAIR REQUIRES A MO...
Thu, 8 Feb, 2018 at 8:06 PM
Setting a service to start on boot
Put script at the end of /etc/rc.d/rc.local chmod +x /etc/rc.d/rc.local 
Thu, 8 Feb, 2018 at 8:13 PM
Resizing a virtual hard disk volume
RESIZE VM  RESIZE LINUX PARTITION  GParted Live CD  df -h  Resize Volume to 100 GB - lvextend /volume -L 100000  Resize filesystem - resize2fs /volume  EXT...
Thu, 8 Feb, 2018 at 8:14 PM
HTTPD SSL Setup
yum install mod_ssl mkdir /etc/httpd/ssl openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/httpd/ssl/apache.key -out /etc/httpd/ssl/apache....
Tue, 3 Apr, 2018 at 4:09 PM
Lets Encrypt SSL Creation for Laravel subdomain
certbot certonly --webroot --webroot-path="/home/domain/public_html/subdomain/public/" Add the SSL Virtual Host to your conf.d virtual host fi...
Tue, 27 Feb, 2018 at 9:40 PM