MySQL User

Create a user For local mysql access CREATE USER ‘USERNAME-HERE’@’localhost’ IDENTIFIED BY ‘PASSWORD_HERE’; GRANT ALL PRIVILEGES ON DB_NAME_HERE.* TO ‘USERNAME-HERE’@’localhost’;

Enable FCGI cache in Nginx

To enable fcgi cache in Nginx, add the following code outside the server block. fastcgi_cache_path /var/run/nginx-fastcgi-cache levels=1:2 keys_zone=SOKCACHE:60m inactive=60m; fastcgi_cache_key

MongoDB

MongoDB is an open-source NoSQL database. https://www.mongodb.com Connecting to MongoDB with user/pass Install MongoDB Backup MongoDB Free MongoDB hosting

Rsync backup with X days retention

rsync is run on backup server, that login to remote servers and backup. vi /usr/serverok/rsync-backup.sh Add following code #!/bin/sh date

lvm

vgcreate pvdisplay lvdisplay lvcreate Resize EC2 file system with LVM pvcreate Device /dev/sdb excluded by a filter How to Remove

Nginx WordPress

Here is nginx configuration for wordpress server { listen 80; server_name serverok.in www.serverok.in; root /var/www/html; index index.php; client_max_body_size 100M; location

Cpanel Error NetworkManager is installed

When installing Cpanel on a dedicated server, i get error NetworkManager is installed and running, or configured to startup. To

Debian Allow MySQL root user to login using phpMyAdmin

On Debian/Ubuntu by default MySQL root user can only login from local accounts. MariaDB [(none)]> select plugin from mysql.user where

Configuring MySQL .my.cnf

vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump]

Install Cpanel DNS Only Server

To install Cpanel DNS only server, run wget http://layer1.cpanel.net/cpanel-dnsonly-install.sea sh cpanel-dnsonly-install.sea

iftop

iftop show bandwidth usage like top show cpu and memory usage. To see network usage, run iftop If you have

Cpanel Server Behind NAT – Amazon EC2

When your cpanel server is behind nat, for example Amazon EC2 where you have an internal IP and External IP.