Hi, i’ve recently created a pmm-server ( monitoring system for server & mysql ). A pmm-server act as a server and client can connect to pmm-server to look on their information by using the command pmm-admin. For more info Click in this link https://www.percona.com/doc/percona-monitoring-and-management/deploy/server/index.html Setup SMTP server For this example you can refer to […]
How to add user in Linux
1.useradd {NAME} 2.passwd {NAME} 3.chage -d 0 {NAME} : To force user to change password when first login 4.create user home directory and chown to the user permission. EX: mkdir /home/{NAME} chown {NAME}.{NAME} /home/{NAME} How to List & Add user from a particular group in linux List $ grep ^{GROUPNAME} /etc/group Add User into Group […]
How to dump and import sql into mysql (Command Line)
#EXPORT mysqldump -u {USER} -h {IP} -p {DB_NAME} {DB_TABLE (OPTIONAL)} | gzip > dump.sql.gz #IMPORT CREATE DATABASE {DB_NAME} mysql -u {USER} -h {IP} -p {DB_NAME} < dump.sql option:- -d : to dump only table structure out only
How to install Gitlab
https://www.howtoforge.com/tutorial/how-to-install-gitlab-on-debian-8/
echo-ing json into array in terminal
echo ‘json_array’ | python -mjson.tool
Mysql root password change
1.Stop mysql service 2.then run this command mysqld_safe –skip-grant-tables & 3.mysql -u root 4.Run Below Command:- use mysql; update user set password=PASSWORD(“mynewpassword”) where User=’root’; flush privileges; quit 5.stop start mysql service and you’re good to go 🙂 Reference Link : https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords
Print Ram unit (byte) linux command
for i in $(seq 1 38); do echo “2^$i” | bc; done | more EX: 536870912 = 512MB bc is a terminal calculator
Master slave mysql configuration
https://www.stephenrlang.com/2016/08/setting-up-mysql-master-slave-replication-with-xtrabackup/
Openvpn configuration ( debian server & client)
Server apt-get install openvpn go into /etc/openvpn/, make a directory easy-rsa ( mkdir easy-rsa ), then run the below command accordingly to your release version :- Wheezy cp -R /usr/share/doc/openvpn/examples/easy-rsa/2.0* easy-rsa/ Jessie and above apt-get install easy-rsa cp -R /usr/share/easy-rsa/* easy-rsa/ Edit /etc/openvpn/easy-rsa/vars bottom according to your organization. Then execute the following command # cd […]
Cronjob
Cronjob is an application that auto run some script at the desired time . Cronjob’s script have to include full path either in script or in crontab -e Here is a quick tools that you can set your time range for running your script:- Crontab.guru