例如：需要在/var/lib/mysql_3307下建一个3307端口


MYSQL_UNIX_PORT=/var/lib/mysql_3307/mysql_3307.sock
MYSQL_TCP_PORT=3307
export MYSQL_UNIX_PORT MYSQL_TCP_PORT
 
初始化数据库
mysql_install_db --user=mysql  --datadir=/var/lib/mysql_3307/
 
编辑my.cnf文件
/var/lib/mysql_3307/
 

  1. [client]  
  2. #password       = your_password  
  3. port            = 3307  
  4. socket          = /var/lib/mysql_3307/mysql_3307.sock  
  5. [mysqld]  
  6. port            = 3307  
  7. socket          = /var/lib/mysql_3307/mysql_3307.sock  
  8. datadir         = /var/lib/mysql_3307  
  9. skip-locking  
  10. key_buffer = 512M  
  11. #max_allowed_packet = 4M  
  12. max_allowed_packet = 8M  
  13. table_cache = 1024  
  14. sort_buffer_size = 8M  
  15. read_buffer_size = 8M  
  16. read_rnd_buffer_size = 12M  
  17. myisam_sort_buffer_size = 128M  
  18. thread_cache_size = 8  
  19. query_cache_size = 64M  
  20. # Try number of CPU's*2 for thread_concurrency  
  21. thread_concurrency = 8  
  22. back_log = 384  
  23. skip-name-resolve  
  24. max_connections=500  
  25. wait_timeout = 10  
  26. log-bin=mysql-bin  
  27. server-id       = 2  
  28. replicate-ignore-db = test  
  29. [mysqldump]  
  30. quick  
  31. max_allowed_packet = 16M  
  32. long_query_time = 3  
  33. log-slow-queries = /var/lib/mysql_3307/slow.log  
  34. log-queries-not-using-indexes  
  35.  
  36. [mysql]  
  37. no-auto-rehash  
  38. # Remove the next comment character if you are not familiar with SQL  
  39. #safe-updates  
  40. [isamchk]  
  41. key_buffer = 256M  
  42. sort_buffer_size = 256M  
  43. read_buffer = 2M  
  44. write_buffer = 2M  
  45. [myisamchk]  
  46. key_buffer = 256M  
  47. sort_buffer_size = 256M  
  48. read_buffer = 2M  
  49. write_buffer = 2M  
  50. [mysqlhotcopy]  
  51. interactive-timeout 


 

启动mysql

mysqld_safe --defaults-file=/var/lib/mysql_3307/my.cnf &

 

登录mysql

mysql -uroot --socket=/var/lib/mysql_3307/mysql_3307.sock