Monthly Archive: July 2017
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...