mysql8.0.20使用教程（如何启动mysql8.0）

[root@VM_0_9_centos ~]# mysqlsh -- util checkForServerUpgrade yq01@127.0.0.1:3306 --target-version=8.0.28 --config-path=/etc/my.cnf Please provide the password for yq01@127.0.0.1:3306: ****** The MySQL server at 127.0.0.1:3306, version 8.0.24 - MySQL Community Server - GPL, will now be checkedfor compatibility issues forupgrade to MySQL 8.0.28... 1) Issues reported by check table x for upgrade commandNo issues found Errors:0 ## 没有错误 Warnings: 0 ## 没有告警 Notices: 0 ## 无其他信息No known compatibility errors or issues were found.# 未发现已知兼容性错误

# 查看是否配置加密 [root@mysql.sock][(none)]> show variables like %default_table_encryption%; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | default_table_encryption | OFF | +--------------------------+-------+ 1 row in set (0.00 sec) # 上面查询结果为ON的时候需要执行以下语句 ALTER INSTANCE ROTATE INNODB MASTER KEY;

# XA检查是否有值 mysql> XA RECOVER; Empty set (0.00 sec) # 若有值，则需要 COMMIT 或 ROLLBACK xid # mysql> XA COMMIT xid; # 或 # mysql> XA ROLLBACK xid;

mysql -h localhost -u root -p -P3306 --execute="SET GLOBAL innodb_fast_shutdown=0"

# 关闭MySQl service mysqld stop 或 mysqladmin -h 127.0.0.1 -u root -p shutdown

# 备份下数据文件，防止有问题需回滚,备份前注意看下容量是否足够，拷贝时长看数据大小 cp -rp /data/mysql3306 /data/mysql3306_bak

# cd 到安装文件目录下 tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz -C /usr/local # 删除原来的软链 cd /usr/local unlink mysql # 重建软链 ln -s mysql-8.0.28-linux-glibc2.12-x86_64 mysql # 新的软链，链接到了新版本 lrwxrwxrwx 1 root root 35 Apr 22 17:08 mysql -> mysql-8.0.28-linux-glibc2.12-x86_64

# 修改为最新的 mysqld rm -f /etc/init.d/mysqld cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld service mysqld start 或 mysqld_safe --defaults-file=/etc/my.cnf --user=mysql 2>&1

# 检查下是否当前客户端符合当前的版本，需要与当前升级到的版本相同 [root@VM_0_9_centos bin]# mysql --version mysql Ver 14.14 Distrib 5.7.37, for linux-glibc2.12 (x86_64) using EditLine wrapper [root@VM_0_9_centos bin]# mysql_upgrade --version mysql_upgrade Ver 2.0 Distrib 5.7.37, for linux-glibc2.12 (x86_64) [root@VM_0_9_centos bin]# mysql_upgrade -uroot -p Enter password: Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK The sys schema is already up to date (version 1.5.2). Checking databases. employees.departments OK employees.dept_emp OK employees.dept_manager OK employees.employees OK employees.salaries OK employees.titles OK sys.sys_config OK Upgrade process completed successfully. Checking if update is needed.

mysql -uroot -p mysql < /usr/local/mysql/share/fill_help_tables.sql

service mysqld restart