openvpn

Upgrade MySQL to Version 5.6 in CentOS

Backup all the database and stop mysql mysqldump -u (userid) -p (password) –all-databases > all-databases.sql service mysqld stop Download the Repo for MySql 5.6 wget http://dev.mysql.com/get/mysql-community-release-el6-3.noarch.rpm/from/http://repo.mysql.com/ Install the repository from the local file yum localinstall mysql-community-release-el6-3.noarch.rpm Install the latest MySql yum install mysql-community-server service mysqld start Configure MySQL to start automatically on Server Reboot chkconfig […]

Howto install sar & ksar system activity info in Centos / Redhat

The sar command collect, report, or save UNIX / Linux system activity information. It will save selected counters in the operating system to the /var/log/sa/sadd file. Fromlinux-logo the collected data, you get lots of information about your server: CPU utilization Memory paging and its utilization Network I/O, and transfer statistics Process creation activity All block […]

Password Validation Plugin in MySQL

The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable you to define password policy. First check the plugin directory of MySQL. mysql> show variables like “plugin%”; +—————+————————–+ | Variable_name | Value | +—————+————————–+ | plugin_dir | /usr/lib64/mysql/plugin/ | +—————+————————–+ 1 row in set (0.00 […]