===MySQL Installation=== After you have installed MySQL make sure you : ==Secure== Secure your mysql root account(s) by setting a root password, delete anonymous users and test databases 0) %% # /usr/bin/mysql_secure_installation %% 1) localhost %% $ /usr/bin/mysqladmin -u root password 'new-password' %% 2) yoursvr.yourdom %% $ /usr/bin/mysqladmin -h yoursvr.yourdom -u root -p password 'new-password' %% ==Tune== Chose an appropriate my.cnf from /usr/share/doc/mysql-server %% # pwd /usr/share/doc/mysql-server-5.0.77 # ls -l total 52 -rw-r--r-- 1 root root 4972 Jan 29 2010 my-huge.cnf -rw-r--r-- 1 root root 20970 Jan 29 2010 my-innodb-heavy-4G.cnf -rw-r--r-- 1 root root 4948 Jan 29 2010 my-large.cnf -rw-r--r-- 1 root root 4955 Jan 29 2010 my-medium.cnf -rw-r--r-- 1 root root 2526 Jan 29 2010 my-small.cnf %% ---- REFERRERS {{backlinks}}