[教學] Mysql install on Linux

Yen | 2014 年 9 月 24 日 2022 年 8 月 8 日 | Leave a Comment | 下午 8:57 上午 3:54

1.Install mysql
# rpm –i MySQL-server-VERSION.glibc23.i386.rpm

●

2.Change mysql home on the my.cnf

# vi /etc/my.cnf

[mysqld]

#datadir=/var/lib/mysql

datadir=/home1/mysql

And Add 6 line after “ log-long-format “

###20140811 add by Yen for performance issue Start

max_connect_errors=1844674407370954751

connect_timeout=20

skip-name-resolve

slave_net_timeout=30

###20140811 add by Yen for performance issue End

3.Copy /var/lib/mysql to /home1/mysql

# cp –pRP /var/lib/mysql /home1/mysql

4.Start mysql
# service mysqld start

5.Setting mysql auto start when boot
# chkconfig –level 2345 mysqld on