1. mysqld

启动mysql服务器:

  1. ./mysqld --defaults-file=/etc/my.cnf --user=root

客户端连接：

  1. mysql --defaults-file=/etc/my.cnf
  2. or
  3. mysql -S /tmp/mysql.sock

2. mysqld_safe

启动mysql服务器：

  1. ./mysqld_safe --defaults-file=/etc/my.cnf --user=root &

客户端连接：

  1. mysql --defaults-file=/etc/my.cnf
  2. or
  3. mysql -S /tm/mysql.sock

3. mysql.server

  1. # 把mysql.server添加为服务
  2. cp -v /usr/local/mysql/support-files/mysql.server /etc/init.d/
  3. chkconfig --add mysql.server

启动mysql服务器：

  1. service mysql.server {start|stop|restart|reload|force-reload|status}

客户端连接：

  1. mysql --defaults-file=/etc/my.cnf
  2. or
  3. mysql -S /tm/mysql.sock

4. mysqld_multi

  1. mkdir $MYSQL_BASE/data2
  3. cat <<-EOF>> /etc/my.cnf
  5. [mysqld_multi]
  6. mysqld = /usr/local/mysql/bin/mysqld_safe
  7. mysqladmin = /user/local/mysql/bin/mysqladmin
  8. user = mysqladmin
  9. password = mysqladmin
  10. [mysqld3306]
  11. port = 3306
  12. socket = /tmp/mysql3306.sock
  13. pid-file = /tmp/mysql3306.pid
  14. skip-external-locking
  15. key_buffer_size = 16M
  16. max_allowed_packet = 1M
  17. table_open_cache = 64
  18. sort_buffer_size = 512K
  19. net_buffer_length = 8K
  20. read_buffer_size = 256K
  21. read_rnd_buffer_size = 512K
  22. myisam_sort_buffer_size = 8M
  23. basedir = /usr/local/mysql
  24. datadir = /usr/local/mysql/data
  25. [mysqld3307]
  26. port = 3307
  27. socket = /tmp/mysql3307.sock
  28. pid-file = /tmp/mysql3307.pid
  29. skip-external-locking
  30. key_buffer_size = 16M
  31. max_allowed_packet = 1M
  32. table_open_cache = 64
  33. sort_buffer_size = 512K
  34. net_buffer_length = 8K
  35. read_buffer_size = 256K
  36. read_rnd_buffer_size = 512K
  37. myisam_sort_buffer_size = 8M
  38. basedir = /usr/local/mysql
  39. datadir = /usr/local/mysql/data2
  40. EOF
  41. #mysql -S /tmp/mysql3306.sock
  42. mysql>GRANT SHUTDOWN ON *.* TO 'mysqladmin'@'localhost' identified by 'mysqladmin' with grant option;
  43. #mysql -S /tmp/mysql3307.sock
  44. mysql>GRANT SHUTDOWN ON *.* TO 'mysqladmin'@'localhost' identified by 'mysqladmin' with grant option;

启动服务器：

  1. ./mysqld_multi --defaults-file=/etc/my.cnf start 3306-3307

关闭mysql服务器：

  1. mysqladmin shutdown