Centos7.x 安装MYSQL

  1. # 安装依赖包
  2. yum -y install libaio
  3. # 创建mysql 用户组和用户
  4. groupadd mysql
  5. useradd -g mysql mysql
  6. # 创建需要文件夹和文件
  7. mkdir -p /usr/local/resources/mysql-5.7.27/{data,log,etc,run}
  8. touch /usr/local/resources/mysql-5.7.27/log/{mysql_error.log,mysql_bin.log,mysql_slow_query.log}
  9. chown -R mysql:mysql /usr/local/resources/mysql-5.7.27
  10. chmod 750 /usr/local/resources/mysql-5.7.27/{data,log,etc,run}
  11. # 配置环境变量
  12. export MYSQL_HOME=/usr/local/resources/mysql-5.7.27
  13. export PATH=.:$MYSQL_HOME/bin:$PATH
  14. # 配置/etc/my.cnf文件
  15. [client]
  16. port = 3306
  17. socket = /usr/local/resources/mysql-5.7.27/run/mysql.sock
  19. [mysqld]
  20. port = 3306
  21. socket = /usr/local/resources/mysql-5.7.27/run/mysql.sock
  22. pid_file = /usr/local/resources/mysql-5.7.27/run/mysql.pid
  23. datadir = /usr/local/resources/mysql-5.7.27/data
  24. default_storage_engine = InnoDB
  25. max_allowed_packet = 128M
  26. max_connections = 2048
  27. open_files_limit = 65535
  29. skip-name-resolve
  30. lower_case_table_names=1
  32. character-set-server = utf8mb4
  33. collation-server = utf8mb4_unicode_ci
  34. init_connect='SET NAMES utf8mb4'
  36. innodb_buffer_pool_size = 128M
  37. innodb_log_file_size = 128M
  38. innodb_file_per_table = 1
  39. innodb_flush_log_at_trx_commit = 0
  41. key_buffer_size = 16M
  43. log-error = /usr/local/resources/mysql-5.7.27/log/mysql_error.log
  44. log-bin = /usr/local/resources/mysql-5.7.27/log/mysql_bin.log
  45. slow_query_log = 1
  46. slow_query_log_file = /usr/local/resources/mysql-5.7.27/log/mysql_slow_query.log
  47. long_query_time = 5
  49. tmp_table_size = 16M
  50. max_heap_table_size = 16M
  51. query_cache_type = 0
  52. query_cache_size = 0
  54. server-id=1
  55. # 初始化MYSQL
  56. mysqld --initialize --user=mysql --basedir=/usr/local/resources/mysql-5.7.27 --datadir=/usr/local/resources/mysql-5.7.27/data
  57. # 此时会生成一个root的临时密码,默认在mysql_error.log文件中
  58. grep 'temporary password' /usr/local/resources/mysql-5.7.27/log/mysql_error.log
  59. # 注：有可能并没有写进文件，直接在执行后的界面显示
  61. # 配置服务
  62. cp /usr/local/resources/mysql-5.7.27/support-files/mysql.server /etc/init.d/mysqld
  63. # 修改/etc/init.d/mysqld文件
  64. vim /etc/init.d/mysqld
  65. # 修改basedir和datadir参数值
  66. basedir = /usr/local/resources/mysql-5.7.27
  67. datadir = /usr/local/resources/mysql-5.7.27/data
  68. # 添加服务
  69. chkconfig --add mysqld
  70. # 设置开机自启和查看
  71. chkconfig mysqld on
  72. chkconfig mysqld --list
  73. # 启动服务
  74. service mysqld start
  75. # 查看服务状态
  76. service mysqld status
  78. # 注意： 如果是Centos8安装的话， 需要添加以下语句
  79. ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
  80. ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5
  82. # 修改root账户密码
  83. mysql -u root -p 初始化临时密码
  84. ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
  85. flush privileges;
  86. exit;
  87. # 重新登录mysql验证
  88. # 修改全网登录配置
  89. use mysql;
  90. update user set host='%' where host='localhost';
  91. flush privileges;
  92. quit;