1. 1、 上传介质文件
    2. scp -P port 135.129.12.49:/usr/local/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz ./usr/local
    4. 2、 解压文件
    5. cd /usr/local/
    6. tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
    8. 3、创建软连接
    9. ln -s mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz mysql
    11. 4、更改权限
    12. chown -R mysql:mysql mysql
    14. 5、编辑参数文件
    15. vi /etc/my.cnf 
    17. [mysqld]
    18. datadir                            = /mysql/my3306/data
    19. socket                             = /mysql/my3306/mysql.sock
    20. pid_file                           = /mysql/my3306/mysql.pid
    22. server_id                          = 3299
    23. port                               = 3306
    25. binlog_format                      = ROW
    26. log_bin                            = mysql-bin
    27. log_bin_index                      = mysql-bin.index
    28. relay_log                          = relay-log
    29. relay_log_index                    = relay-log.index
    31. log_error                          = error.log
    32. general_log_file                   = general.log
    33. slow_query_log_file                = slow.log
    34. long_query_time                    = 1 
    35. slow_query_log                     = ON
    37. character_set_server               = utf8mb4
    38. collation_server                   = utf8mb4_unicode_ci
    39. explicit_defaults_for_timestamp    = ON  
    40. lower_case_table_names             = 1
    41. transaction_isolation              = READ-COMMITTED
    42. open_files_limit                   = 65535
    44. enforce_gtid_consistency           = ON
    45. gtid_mode                          = ON
    46. log_slave_updates                  = ON
    49. 6、创建文件目录及赋权
    50. mkdir -p /mysql/my3306/data
    51. mkdir -p /mysql/my3306/
    52. chown -R mysql:mysql /mysql/my3306/
    54. 7、初始化数据库
    55. /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize-insecure
    57. 8、启动数据库
    58. /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &
    60. 9、登录数据库
    61. /usr/local/mysql/bin/mysql -uroot -S /mysql/my3306/mysql.sock -p
    63. 10、修改root密码
    64. alter user root@'localhost' identified by '123';
    65. flush privileges;
    67. 11、重新登录数据库
    68. /usr/local/mysql/bin/mysql -uroot -S /mysql/my3306/mysql.sock -p
    69. 123