Email: inbox [at] sysadmin.lk
LinkedIn: https://www.linkedin.com/in/prabatht
Facebook: https://www.facebook.com/prabath.hinoize
Related Articles
Install and configure LSYNCD on Centos 7
Enviroment: – Server01.192.168.30.201 – Server02.192.168.30.202 – Directory to be Sync : “/opt/web/htdocs/prompt and /opt/vxml ” 2.Step Key based authentication Configuration -Login to Master server & generate the public and Private keys using the following command: [root@server01 ~]# ssh-keygen -t rsa [root@server01 ~]# ssh-copy-id -i /root/.ssh/id_rsa.pub root@192.168.30.202 2.Step Installation Lsyncd [root@server01 ~]# yum install epel-release [root@server01 […]
Gitlab reset Password for root
You will need to do the following: SSH into your Droplet where GitLab is installed. ssh [your-user]@[your-droplet-ip-address] Open the GitLab Rails console. If you installed GitLab via the Omnibus package, you can open the Rails console with: sudo gitlab-rails console Locate the root user and change the password. Once in the console, enter the following commands: user = […]
Useful MySQL Commands
Database with size SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Create a database. mysql> create database [databasename]; List all databases on the server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the […]