Server & Sql Monitoring (PMM-Server)
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...
Category: Linux
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 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...
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...
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...
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...
