Archive for the ‘mysql’ Category

Installing the MySQL server on FreeBSD

Posted: 8th May 2010 by Valkyrka in freebsd, mysql

The last post written was referring to the install of PHP5 on a FreeBSD box. I am going to install the MySQL server on my FreeBSD box. Please do keep in mind that you will have to install the same version of the MySQL daemon as your MySQL client. If you try to install a [...]

Shell script to backup all MySQL databases

Posted: 1st April 2010 by Valkyrka in bash, mysql, shell

This is a script which I wrote that backs up all of your databases in /home. If this is a cPanel / Plesk box, it automatically logs in and creates the dump. If this is a non-cPanel / non-Plesk box, the script will ask you for the MySQL root password. The backups are archived using [...]

Reset MySQL's root password

Posted: 24th March 2010 by Valkyrka in cpanel, mysql, one-liner, plesk

I think a lot of people needed to reset the MySQL root password for multiple reasons ( they have forgotten the password, an employee left the job without giving the MySQL root password to the new sysadmin etc. ). Resetting the MySQL root password is very simple however, it would require you to kill the [...]