partition maintainance script for mysql

Visit my new wordpress blog to view this content :)

Mysql range partitioning on date column

Visit my new wordpress blog to view this content :)

Mysql Secure Installation for non default socket.

Visit my new wordpress blog to view this content :)

Mysql change/recover root password

If you already know the root password you can just update it using
# mysqladmin -u root -p oldpassword newpassword


If you forgot root password and need to restore, it can be done easily with following steps

Step # 1: Stop the MySQL server process.

# /etc/init.d/mysql stop or Kill mysqld and if exists mysqld_safe processes.