当前位置:Gxlcms > 数据库问题 > 一键安装MySQL5.6.43脚本

一键安装MySQL5.6.43脚本

时间:2021-07-01 10:21:17 帮助过:9人阅读

  1. [root@lamp ~]# cat /server/scripts/mysql-5.6.43_install.sh
  2. #!/bin/bash
  3. #卸载系统自带的Mysql
  4. /bin/rpm -e $(/bin/rpm -qa | grep mysql|xargs) --nodeps
  5. /bin/rm -f /etc/my.cnf
  6. #安装编译代码需要的软件包
  7. /usr/bin/yum -y install make gcc-c++ cmake bison-devel ncurses-devel
  8. #创建mysql用户及其用户组
  9. /usr/sbin/groupadd mysql
  10. /usr/sbin/useradd -g mysql mysql -M -s /sbin/nologin
  11. #编译安装mysql-5.6.43
  12. cd /usr/local/src
  13. wget -c -P ./ http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/mysql-5.6.43.tar.gz
  14. /bin/tar -zxvf mysql-5.6.43.tar.gz
  15. cd mysql-5.6.43/
  16. /usr/bin/cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
  17. make && make install
  18. #创建并修改/usr/local/mysql软件目录和mysql数据存放目录/data/mysql/data权限
  19. mkdir -p /data/mysql/data /usr/local/mysql
  20. /bin/chown -R mysql:mysql /usr/local/mysql
  21. /bin/chown -R mysql:mysql /data/mysql/data
  22. #执行初始化配置脚本,创建系统自带的数据库和表
  23. /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql
  24. #配置mysql配置文件/usr/local/mysql/my.cnf
  25. cat > /usr/local/mysql/my.cnf << EOF
  26. [client]
  27. port = 3306
  28. socket = /usr/local/mysql/var/mysql.sock
  29. [mysqld]
  30. port = 3306
  31. socket = /usr/local/mysql/var/mysql.sock
  32. basedir = /usr/local/mysql/
  33. datadir = /data/mysql/data
  34. pid-file = /data/mysql/data/mysql.pid
  35. user = mysql
  36. bind-address = 0.0.0.0
  37. server-id = 1
  38. sync_binlog=1
  39. log_bin = mysql-bin
  40. skip-name-resolve
  41. #skip-networking
  42. back_log = 600
  43. max_connections = 3000
  44. max_connect_errors = 3000
  45. ##open_files_limit = 65535
  46. table_open_cache = 512
  47. max_allowed_packet = 16M
  48. binlog_cache_size = 16M
  49. max_heap_table_size = 16M
  50. tmp_table_size = 256M
  51. read_buffer_size = 1024M
  52. read_rnd_buffer_size = 1024M
  53. sort_buffer_size = 1024M
  54. join_buffer_size = 1024M
  55. key_buffer_size = 8192M
  56. thread_cache_size = 8
  57. query_cache_size = 512M
  58. query_cache_limit = 1024M
  59. ft_min_word_len = 4
  60. binlog_format = mixed
  61. expire_logs_days = 30
  62. log_error = /data/mysql/data/mysql-error.log
  63. slow_query_log = 1
  64. long_query_time = 1
  65. slow_query_log_file = /data/mysql/data/mysql-slow.log
  66. performance_schema = 0
  67. explicit_defaults_for_timestamp
  68. ##lower_case_table_names = 1
  69. skip-external-locking
  70. default_storage_engine = InnoDB
  71. ##default-storage-engine = MyISAM
  72. innodb_file_per_table = 1
  73. innodb_open_files = 500
  74. innodb_buffer_pool_size = 1024M
  75. innodb_write_io_threads = 1000
  76. innodb_read_io_threads = 1000
  77. innodb_thread_concurrency = 8
  78. innodb_purge_threads = 1
  79. innodb_flush_log_at_trx_commit = 2
  80. innodb_log_buffer_size = 4M
  81. innodb_log_file_size = 32M
  82. innodb_log_files_in_group = 3
  83. innodb_max_dirty_pages_pct = 90
  84. innodb_lock_wait_timeout = 120
  85. bulk_insert_buffer_size = 8M
  86. myisam_sort_buffer_size = 8M
  87. myisam_max_sort_file_size = 10G
  88. myisam_repair_threads = 1
  89. interactive_timeout = 28800
  90. wait_timeout = 28800
  91. [mysqldump]
  92. quick
  93. max_allowed_packet = 16M
  94. [myisamchk]
  95. key_buffer_size = 8M
  96. sort_buffer_size = 8M
  97. read_buffer = 4M
  98. write_buffer = 4M
  99. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  100. port = 3306
  101. EOF
  102. #启动mysql服务
  103. cd /usr/local/mysql
  104. /bin/mkdir var
  105. /bin/chown -R mysql.mysql var
  106. cp support-files/mysql.server /etc/init.d/mysql
  107. /sbin/chkconfig mysql on
  108. service mysql start
  109. #设置mysql登陆密码,初始密码为123456
  110. /bin/mkdir -p /var/lib/mysql
  111. ln -s /usr/local/mysql/var/mysql.sock /var/lib/mysql/mysql.sock
  112. mysql -e "SET PASSWORD = PASSWORD(‘123456‘);"
  113. mysql -p123456 -e "GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;"
  114. mysql -p123456 -e "FLUSH PRIVILEGES;"

参考博客:http://www.cnblogs.com/kevingrace/p/6109679.html

一键安装MySQL5.6.43脚本

标签:client   mysql-bin   blank   password   base   var   代码   sub   bind   

人气教程排行