本文共 4941 字，大约阅读时间需要 16 分钟。

wget -O mysql80.sh https://*.*.*.*/mysql80.shsh mysql80.sh

看到下面提示，输入root@127.0.0.1用户密码，保存好一会使用。另外root@localhost密码为空

please input root@127.0.0.1 password, default bigops>输入你的密码

#!/bin/shwhich "/usr/bin/systemctl" >/dev/null 2>&1if [ $? == 0 ];then    systemctl stop mysqld.serviceelse    service mysqld stopfiif [ ! -z "$(ps aux|egrep mysqld|grep -v grep)" ];then    ps aux|egrep mysqld|grep -v grep|awk '{print $2}'|xargs kill -9fiif [ ! -d /opt/mysql-rpms ];then   mkdir -p /opt/mysql-rpmsfiinst(){    wget -O /etc/my.cnf https://*.*.*.*/my-80.cnf    chmod 644 /etc/my.cnf    rm -rf /var/lib/mysql/*    mysqld --user=mysql --lower-case-table-names=0 --initialize-insecure    chown -R mysql:mysql /var/lib/mysql        which "/usr/bin/systemctl" >/dev/null 2>&1    if [ $? == 0 ];then        systemctl start mysqld.service    else        service mysqld start    fi    echo    echo ----------------------------------    echo "press any key to continue"    read    echo ----------------------------------    echo -e "please input root@127.0.0.1 password, default bigops"    echo -e ">\c"    read mypass    if  [ -z "${mypass}" ];then        mypass='bigops'    fi    mysql -uroot -e "create user 'root'@'127.0.0.1' identified with mysql_native_password by '${mypass}'"    mysql -uroot -e "grant all privileges on *.* to 'root'@'127.0.0.1'"    if [ $? == 0 ];then        echo        echo ----------------------------------        echo "Installed successfully, root@127.0.0.1 password is ${mypass}"        echo "please running command testing: mysql -uroot -h127.0.0.1 -p${mypass}"        echo ----------------------------------    else        echo "Installed failure!"    fi}osver=`rpm -qi centos-release|egrep Version|awk '{print $3}'`cd /opt/mysql-rpms/if [[ "${osver}" == 6 ]] && [[ `arch` == x86_64 ]];then    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-client-8.0.16-2.el6.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-common-8.0.16-2.el6.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-devel-8.0.16-2.el6.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-libs-8.0.16-2.el6.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-libs-compat-8.0.16-2.el6.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-server-8.0.16-2.el6.x86_64.rpm    rpm -Uvh --force /opt/mysql-rpms/*-8.0*.el6.*.rpm       instelif [[ "${osver}" == 7 ]] && [[ `arch` == x86_64 ]];then    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-client-8.0.16-2.el7.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-common-8.0.16-2.el7.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-devel-8.0.16-2.el7.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-libs-8.0.16-2.el7.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm &    wget -N -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-community-server-8.0.16-2.el7.x86_64.rpm    rpm -Uvh --force /opt/mysql-rpms/*-8.0*.el7.*.rpm    instelse    echo "current system is not supported"fi

my-80.cnf

[client]default-character-set=utf8mb4port=3306socket=/var/lib/mysql/mysql.sock[mysql] default-character-set=utf8mb4[mysqld]character-set-client-handshake=FALSEcharacter-set-server=utf8mb4collation-server=utf8mb4_unicode_ciinit_connect='SET NAMES utf8mb4'datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockport=3306default_authentication_plugin=mysql_native_passworddefault_password_lifetime=0lower_case_table_names=0#skip-grant-tablesskip_sslexplicit_defaults_for_timestamp=1#open_files_limit=65535back_log=1024host_cache_size=0skip-external-lockingskip-name-resolvemax_allowed_packet = 512Mtable_open_cache = 1000table_definition_cache = 1024table_open_cache_instances = 64sort_buffer_size = 4Mjoin_buffer_size = 4Mread_buffer_size = 128Mread_rnd_buffer_size = 128Mthread_cache_size = 768thread_stack = 512Ktmp_table_size = 32Mmax_heap_table_size = 32Minteractive_timeout=2147483wait_timeout=2147483max_connections=5000max_connect_errors=100000expire_logs_days=2sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTIONinnodb_data_file_path=ibdata1:10M:autoextendinnodb_buffer_pool_size=2Ginnodb_log_file_size=512Minnodb_log_buffer_size=8Minnodb_log_files_in_group=3innodb_flush_log_at_trx_commit=1innodb_flush_method=O_DIRECTinnodb_file_per_table=1innodb_open_files=1000innodb_lock_wait_timeout=300innodb_thread_concurrency=0[mysqldump]quickmax_allowed_packet = 16M[myisamchk]key_buffer_size = 256Msort_buffer_size = 256Mread_buffer = 2Mwrite_buffer = 2M[safe_mysqld]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid