mysqldump with process

mysqldump -u username -p password some_database | pv | gzip > some_database.sql.gz

restore

mysql -u root -p kata_sandi servernesia < servernesia.sql

create new user

create user ‘db_user’@‘10.130.0.0/255.255.0.0’ IDENTIFIED by ‘pass’;

grant all privileges on nama_db.* to db_user@‘10.130.0.0/255.255.0.0’;

change password

ALTER USER ‘db_user’@‘10.130.0.0/255.255.0.0’ IDENTIFIED by ’new_pass’;

#list all user
select host, user, password from mysql.user;
#drop user
DROP USER 'username'@'host';