by Anjani Phuyal | May 28, 2014 | Mysql
SET MYSQL root password mysqladmin -u root password NEWPASSWORD change mysql root password mysqladmin -u root -p’oldpassword’ password newpass Add MySQL users and assign privilege CREATE USER ‘newuser’@’localhost’ IDENTIFIED...
by Anjani Phuyal | May 26, 2014 | Linux, Mysql
apt-cache search zabbix sudo apt-get install zabbix-server-mysql zabbix-frontend-php zabbix-agent web interface: http://servername/zabbix default username/password is admin/zabbix
by Anjani Phuyal | May 26, 2014 | Mysql
http://sourceforge.net/projects/automysqlbackup/ mkdir automysqlbackup cd automysqlbackup wget http://sourceforge.net/projects/automysqlbackup/ tar -zxvf download ./install.sh mkdir /var/backup mkdir /var/backup/db vi /etc/automysqlbackup/myserver.conf...
