1

rpm -Uvh mysql-shell-8.2.0-1.el7.x86_64.rpm --force --nodeps

1

mysqlsh --version

1

mysqlsh -uroot -p -S /var/lib/mysql/mysql.sock -e "util.checkForServerUpgrade()"

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

[root@zyl-server ~]# mysqlsh -uroot -p -S /var/lib/mysql/mysql.sock -e "util.checkForServerUpgrade()"

Please provide the password for 'root@/var%2Flib%2Fmysql%2Fmysql.sock': ********（zyl@2024）

Save password for 'root@/var%2Flib%2Fmysql%2Fmysql.sock'? [Y]es/[N]o/Ne[v]er (default No): Y

The MySQL server at /var%2Flib%2Fmysql%2Fmysql.sock, version 5.7.42 - MySQL

Community Server (GPL), will now be checked for compatibility issues for

upgrade to MySQL 8.2.0...

1) Usage of old temporal type

  No issues found

2) MySQL 8.0 syntax check for routine-like objects

  No issues found

3) Usage of db objects with names conflicting with new reserved keywords

  No issues found

4) Usage of utf8mb3 charset

  No issues found

5) Table names in the mysql schema conflicting with new tables in 8.0

  No issues found

6) Partitioned tables using engines with non native partitioning

  No issues found

7) Foreign key constraint names longer than 64 characters

  No issues found

8) Usage of obsolete MAXDB sql_mode flag

  No issues found

9) Usage of obsolete sql_mode flags

  Notice: The following DB objects have obsolete options persisted for

    sql_mode, which will be cleared during upgrade to 8.0.

  More information:

    https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals

  db_zyl.InsertMultipleUsers - PROCEDURE uses obsolete NO_AUTO_CREATE_USER

    sql_mode

  global system variable sql_mode - defined using obsolete NO_AUTO_CREATE_USER

    option

10) ENUM/SET column definitions containing elements longer than 255 characters

  No issues found

11) Usage of partitioned tables in shared tablespaces

  No issues found

12) Circular directory references in tablespace data file paths

  No issues found

13) Usage of removed functions

  No issues found

14) Usage of removed GROUP BY ASC/DESC syntax

  No issues found

15) Removed system variables for error logging to the system log configuration

  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary

  More information:

    https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13.html#mysqld-8-0-13-logging

16) Removed system variables

  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary

  More information:

    https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

17) System variables with new default values

  To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary

  More information:

    https://mysqlserverteam.com/new-defaults-in-mysql-8-0/

18) Zero Date, Datetime, and Timestamp values

  No issues found

19) Schema inconsistencies resulting from file removal or corruption

  No issues found

20) Tables recognized by InnoDB that belong to a different engine

  No issues found

21) Issues reported by 'check table x for upgrade' command

  No issues found

22) New default authentication plugin considerations

  Warning: The new default authentication plugin 'caching_sha2_password' offers

    more secure password hashing than previously used 'mysql_native_password'

    (and consequent improved client connection authentication). However, it also

    has compatibility implications that may affect existing MySQL installations.

    If your MySQL installation must serve pre-8.0 clients and you encounter

    compatibility issues after upgrading, the simplest way to address those

    issues is to reconfigure the server to revert to the previous default

    authentication plugin (mysql_native_password). For example, use these lines

    in the server option file:

    [mysqld]

    default_authentication_plugin=mysql_native_password

    However, the setting should be viewed as temporary, not as a long term or

    permanent solution, because it causes new accounts created with the setting

    in effect to forego the improved authentication security.

    If you are using replication please take time to understand how the

    authentication plugin changes may impact you.

  More information:

    https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatibility-issues

    https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-replication

23) Columns which cannot have default values

  No issues found

24) Check for invalid table names and schema names used in 5.7

  No issues found

25) Check for orphaned routines in 5.7

  No issues found

26) Check for deprecated usage of single dollar signs in object names

  No issues found

27) Check for indexes that are too large to work on higher versions of MySQL

Server than 5.7

  No issues found

28) Check for deprecated '.<table>' syntax used in routines.

  No issues found

29) Check for columns that have foreign keys pointing to tables from a diffrent

database engine.

  No issues found

Errors:   0

Warnings: 1

Notices:  2

NOTE: No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.

[root@zyl-server ~]#

1

2

3

4

5

6

7

8

9

mysql> select@@version;

+-----------+

| @@version |

+-----------+

| 5.7.42    |

+-----------+

1 row in set (0.00 sec)

mysql>

1

2

3

4

[root@zyl-server ~]#  cat /etc/redhat-release

CentOS Linux release 7.9.2009 (Core)

[root@zyl-server ~]#

[root@zyl-server ~]#

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

[root@zyl-server ~]# mysqldump -hlocalhost -uroot -p --all-databases > /home/db_back_2024.sql

Enter password:

[root@zyl-server ~]# ll

total 1317800

-rw-------. 1 root  root       1419 Aug 30  2023 anaconda-ks.cfg

-rw-------. 1 root  root  453727744 Mar 13 19:40 image_mysql.tar

-rwxrwxrwx. 1 mysql mysql        58 Mar 17 16:39 init-file

drwxr-xr-x. 2 root  root         88 Mar 11 10:59 mynginx-app

-rw-r--r--. 1 root  root  447283712 Mar 13 19:24 mysql-5.7-container02.tar

-rw-r--r--. 1 root  root  447283712 Mar 13 19:23 mysql-5.7-container.tar

drwxr-xr-x. 9 mfs   mfs         186 Feb 28 20:38 nginx-1.24.0

-rw-r--r--. 1 root  root    1112471 Feb 28 20:37 nginx-1.24.0.tar.gz

[root@zyl-server ~]# cd /home/

[root@zyl-server home]# ll

total 876

-rw-r--r--. 1 root  root  890551 Mar 17 16:58 db_back_2024.sql

drwx------. 2 mfs   mfs       99 Feb 29 21:49 mfs

drwx------. 2 redis redis     99 Mar  3 02:43 redis

drwx------. 3 zyl   zyl     4096 Mar 16 13:47 zyl

[root@zyl-server home]#

[root@zyl-server home]# cp /etc/my.cnf /home/5.7.37_my.cnf

[root@zyl-server home]#

[root@zyl-server home]#

[root@zyl-server home]# systemctl stop mysqld

1

2

3

mkdir mysql8.2.0-bundle

tar -xvf mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar

1

rpm -qa|grep -i mysql

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

[root@zyl-server mysql8.2.0-bundle]# rpm -Uvh mysql-community-server-8.2.0-1.el7.x86_64.rpm --force --nodeps

warning: mysql-community-server-8.2.0-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql-community-server-8.2.0-1.el################################# [ 50%]

Cleaning up / removing...

   2:mysql-community-server-5.7.42-1.e################################# [100%]

[root@zyl-server mysql8.2.0-bundle]# rpm -Uvh mysql-community-client-

mysql-community-client-8.2.0-1.el7.x86_64.rpm          mysql-community-client-plugins-8.2.0-1.el7.x86_64.rpm 

[root@zyl-server mysql8.2.0-bundle]# rpm -Uvh mysql-community-client-8.2.0-1.el7.x86_64.rpm --force --nodeps

warning: mysql-community-client-8.2.0-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql-community-client-8.2.0-1.el################################# [ 50%]

Cleaning up / removing...

   2:mysql-community-client-5.7.42-1.e################################# [100%]

[root@zyl-server mysql8.2.0-bundle]# rpm -Uvh mysql-community-libs-8.2.0-1.el7.x86_64.rpm --force --nodeps

warning: mysql-community-libs-8.2.0-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql-community-libs-8.2.0-1.el7 ################################# [ 50%]

Cleaning up / removing...

   2:mysql-community-libs-5.7.42-1.el7################################# [100%]

[root@zyl-server mysql8.2.0-bundle]#  rpm -Uvh mysql-community-common-8.2.0-1.el7.x86_64.rpm --force --nodeps

warning: mysql-community-common-8.2.0-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql-community-common-8.2.0-1.el################################# [ 50%]

Cleaning up / removing...

   2:mysql-community-common-5.7.42-1.e################################# [100%]

[root@zyl-server mysql8.2.0-bundle]#

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

systemctl start mysqld

mysql -u root -p

[root@zyl-server mysql8.2.0-bundle]# mysql -u root -p

Enter password: （zyl@2024）

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 12

Server version: 8.2.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

1

2

3

4

5

6

7

8

9

mysql> select@@version;

+-----------+

| @@version |

+-----------+

| 8.2.0     |

+-----------+

1 row in set (0.00 sec)

mysql>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| db_zyl             |

| information_schema |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

5 rows in set (0.00 sec)

mysql> use db_zyl;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql>

mysql>

mysql> show tables;

+------------------+

| Tables_in_db_zyl |

+------------------+

| users            |

+------------------+

1 row in set (0.00 sec)

mysql> select * from users;

+----+----------+----------------------+-------------+---------------------+

| id | name     | email                | password    | created_at          |

+----+----------+----------------------+-------------+---------------------+

|  1 | John Doe | john.doe@example.com | password123 | 2024-03-15 00:11:46 |

|  2 | John Doe | john.doe@example.com | password123 | 2024-03-15 00:11:50 |

|  3 | John Doe | john.doe@example.com | password123 | 2024-03-15 00:11:52 |

|  4 | John Doe | john.doe@example.com | password123 | 2024-03-15 00:11:55 |

|  5 | John Doe | john.doe@example.com | password123 | 2024-03-15 00:11:56 |

+----+----------+----------------------+-------------+---------------------+

5 rows in set (0.00 sec)

mysql>