2014年9月24日 星期三

[教學] Mysql install on Linux


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


沒有留言: