配置yum源

  1. wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
  2. rpm -ivh mysql57-community-release-el7-11.noarch.rpm
  3. yum makecache

安装mysql

  1. yum install mysql-community-server -y
  2. systemctl enable mysqld
  3. systemctl start mysqld
  4. mkdir /var/log/mysql
  5. chown -R mysql.mysql /var/log/mysql

获取mysql初始密码

  1. grep 'temporary password' /var/log/mysqld.log
  1. [root@template-centos7 src]# grep 'temporary password' /var/log/mysqld.log
  2. 2021-11-10T08:48:12.717987Z 1 [Note] A temporary password is generated for root@localhost: fp?GPt&wM2ij

配置文件

  1. [client]
  2. port        = 3306
  3. socket        = /var/log/mysql/mysql.sock
  4. #default-character-set = utf8
  6. [mysql]
  7. prompt=\\u@\\d>
  9. [mysqld]
  10. server-id = 2
  11. port        = 3306
  12. bind-address    = 0.0.0.0
  13. socket        = /var/log/mysql/mysql.sock
  14. skip-name-resolve
  15. datadir = /data/mysql
  16. character-set-server = utf8_bin
  17. max_connections = 1000
  18. open_files_limit = 65535
  19. log-error = /var/log/mysql/error.log
  20. pid-file = /var/log/mysql/mysql.pid
  21. back_log = 256
  22. max_connect_errors = 256
  23. table_open_cache = 2048
  24. max_allowed_packet = 64M
  25. binlog_cache_size = 2M
  26. max_heap_table_size = 128M
  27. sort_buffer_size = 8M
  28. join_buffer_size = 8M
  29. thread_cache_size = 256
  30. #thread_concurrency = 8
  31. query_cache_size = 256M
  32. query_cache_limit = 2M
  33. thread_stack = 192K
  34. transaction_isolation = REPEATABLE-READ
  35. tmp_table_size = 64M
  36. expire_logs_days=30
  37. max_binlog_size = 512M
  38. slow_query_log = 0
  39. long_query_time = 0.5
  40. key_buffer_size = 256M
  41. read_buffer_size = 8M
  42. read_rnd_buffer_size = 8M
  43. bulk_insert_buffer_size = 64M
  44. myisam_sort_buffer_size = 128M
  45. myisam_max_sort_file_size = 10G
  46. myisam_repair_threads = 1
  47. explicit_defaults_for_timestamp=true
  48. log_timestamps=SYSTEM
  49. innodb_file_per_table=ON
  50. innodb_buffer_pool_size = 13G
  51. innodb_thread_concurrency = 16
  52. innodb_flush_log_at_trx_commit = 1
  53. innodb_log_buffer_size = 18M
  54. innodb_log_file_size = 512M
  55. innodb_open_files = 65535
  56. innodb_log_files_in_group = 2
  57. innodb_lock_wait_timeout = 120
  59. [mysqldump]
  60. quick
  61. max_allowed_packet = 64M
  63. [mysql]
  64. no-auto-rehash
  65. prompt=\\u@\\d>
  67. [myisamchk]
  68. key_buffer_size = 512M
  69. sort_buffer_size = 512M
  70. read_buffer = 8M
  71. write_buffer = 8M

修改密码

  1. # 第一次修改密码
  2. ALTER USER 'root'@'localhost' IDENTIFIED BY 'New_password1';
  4. # 之后修改密码
  5. update mysql.user set authentication_string=password('New_password1') where user='root' ;