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’; FLUSH PRIVILEGES;…
Blog
Enable FCGI cache in Nginx
To enable fcgi cache in Nginx, add the following code outside the server block. Inside your location for .php files, above the…
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 rsync –archive…
lvm
vgcreate pvdisplay lvdisplay lvcreate Resize EC2 file system with LVM pvcreate Device /dev/sdb excluded by a filter How to Remove a logical…
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 = /favicon.ico…
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 fix this,…
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 user=’root’; +————-+…
Configuring MySQL .my.cnf
vi ~/.my.cnf Add following content [client] user = root password = “DBPASSWORD” [mysqladmin] user = root password = “DBPASSWORD” [mysqldump] user =…
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 multiple network…
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. Go to…