Wiki source for MySqlnstallation
===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}}
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}}