MySQL
Install phpMyAdmin
phpMyAdmin is web-based PHP application for managing MySQL databases. It is fairly easy to install and configure.
Download the latest stable version from the phpMyAdmin web site, and extract it to a location of your choice. I prefer to keep the installation outside of the web root and use an apache alias to reference [...]
Backup and Restore Databases
The following steps can be executed as a non privileged user on the server, however, the username and password you use with the commands needs to be a database user that has r/w privileges within MySQL (think “sa” account for Microsoft SQL Server).
1. Export the database to a SQL file.
[user@host]$ mysqldump –opt –user=dbuser \
[...]
Set the Root Password
After installing MySQL, the first thing you’ll want to do is reset the root password for MySQL. You can achieve this using the following command:
[root@myhost]# mysqladmin -u root password new-password
Set MySQL to start automatically with the following command
[root@myhost]# /sbin/chkconfig mysqld on
Update:
A much better way to secure your installation of MySQL is to run the mysql_secure_installation [...]
