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
137
138
139
140
141
142
143
|
# Save the count of columns in mysql
# shut server down
# Server is down
#
# Try --initialize
#
# Run the server with --initialize
extract the root password
password found
# Restart the server against DDIR
# connect as root
# must fail due to password expiration
SELECT 1;
ERROR HY000: You must reset your password using ALTER USER statement before executing this statement.
# reset the password
SET PASSWORD='';
# Check the count of columns in mysql
# check the user account
SELECT user, host, plugin, LENGTH(authentication_string)
FROM mysql.user ORDER by user;
user host plugin LENGTH(authentication_string)
mysql.infoschema localhost caching_sha2_password 70
mysql.session localhost caching_sha2_password 70
mysql.sys localhost caching_sha2_password 70
root localhost caching_sha2_password 0
# Check the sys schema exists with the right object counts
#
# If this value differs, also update SYS_PROCEDURE_COUNT within ./client/upgrade/program.cc
SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'sys' AND ROUTINE_TYPE = 'PROCEDURE';
COUNT(*)
26
# If this value differs, also update SYS_FUNCTION_COUNT within ./client/upgrade/program.cc
SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'sys' AND ROUTINE_TYPE = 'FUNCTION';
COUNT(*)
22
# If this value differs, also update SYS_TABLE_COUNT within ./client/upgrade/program.cc
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sys' AND TABLE_TYPE = 'BASE TABLE';
COUNT(*)
1
# If this value differs, also update SYS_VIEW_COUNT within ./client/upgrade/program.cc
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sys' AND TABLE_TYPE = 'VIEW';
COUNT(*)
100
# If this value differs, also update SYS_TRIGGER_COUNT within ./client/upgrade/program.cc
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'sys';
COUNT(*)
2
CREATE DATABASE test;
# shut server down
# Server is down
# close the test connection
# remove the password file
# delete mysqld log
# delete datadir
#
# Try --initialize-insecure --init-file
#
# create bootstrap file
# Run the server with --initialize-insecure --init-file
# Restart the server against DDIR
# connect as root
# must pass: no password expiration
SELECT 1;
1
1
# Check the count of columns in mysql
# Take out the extra t1 column
# check the user account
SELECT user, host, plugin, LENGTH(authentication_string)
FROM mysql.user ORDER BY user;
user host plugin LENGTH(authentication_string)
mysql.infoschema localhost caching_sha2_password 70
mysql.session localhost caching_sha2_password 70
mysql.sys localhost caching_sha2_password 70
root localhost caching_sha2_password 0
# check the result of running --init-file
SELECT a FROM t1 ORDER BY a;
a
1
2
# shut server down
# Server is down
# close the test connection
# delete mysqld log
# delete bootstrap file
# delete datadir
#
# Try --initialize-insecure --init-file=empty_file for error handling
#
# Run the server with --initialize-insecure --init-file=empty
# delete mysqld log
# delete datadir
#
# Try --initialize-insecure --init-file=relative_path for error handling
#
# Run the server with --initialize-insecure --init-file=haha.sql
# delete mysqld log
# delete datadir
#
# Bug#22777039 - MYSQLD --INITIALIZE DOES NOT SUPPORT THE KEYRING_FILE_DATA OPTION
#
# delete mysqld log
# delete temp keyring file
# delete datadir
#
# Bug#29584642 DATABASE INITIALISATION FAILURE WITH INNODB_DEFAULT_ROW_FORMAT=REDUNDANT
#
# The database initialization would fail without the fix.
# delete mysqld log
# delete datadir
#
# Bug#29780434 MYSQLD --INITIALIZE FAILS IF LOST+FOUND FROM FILESYSTEM IS IN DATADIR
#
# Create the data directory and subdirectories.
# Add a sub-directory in it with a name that is not ignored.
# Add a sub-directory in it with a name that is ignored.
# Add a "hidden" sub-directory, starting with '.'.
# Run the server with --initialize. Should fail due to 'subdir'.
# Remove the subdirectory which is not accepted, and start the server with --initialize again.
# Remove data dir and log file.
#
# Bug#31496943: INITIALIZE WITH INNODB_PAGE_SIZE=4096 GETS
# "SPECIFIED KEY WAS TOO LONG" ERRORS
#
# Create bootstrap file which creates test schema (needed for
# wait_until_connected
# Run the server with --initialize-insecure and 4K pages.
# Look for error messages from my_message_stderr (there should be none)
# Restart the server against the 4k DDIR to make sure it can be started
SELECT * FROM information_schema.schemata;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
# Shut server down
# Server is down
# Remove 4k data dir, log, and bootstrap file.
#
# Cleanup
#
# Restarting the server
|
