Debian Codegraph @

mysql-test/suite/auth_sec/r/ssl_mode.result

raw
1 CREATE USER 'user1'@'%' require ssl;
2 grant all on *.* to 'user1'@'%' ;
3 # Testing of all clients with ssl mode PREFERRED
4 mysql.user OK
5 Database: mysql Table: user Wildcard: user
6 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
7 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
8 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
9 | User | char(32) | utf8mb3_bin | NO | PRI | | | select,insert,update,references | |
10 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
11 mysql.test: Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
12 # Testing of all clients with ssl mode REQUIRED
13 mysql.user OK
14 Database: mysql Table: user Wildcard: user
15 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
16 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
17 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
18 | User | char(32) | utf8mb3_bin | NO | PRI | | | select,insert,update,references | |
19 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
20 mysql.test: Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
21 # Testing of all clients with ssl mode VERIFY_CA
22 mysql.user OK
23 Database: mysql Table: user Wildcard: user
24 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
25 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
26 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
27 | User | char(32) | utf8mb3_bin | NO | PRI | | | select,insert,update,references | |
28 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
29 mysql.test: Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
30 # Testing of all clients with ssl mode VERIFY_IDENTITY
31 mysql.user OK
32 Database: mysql Table: user Wildcard: user
33 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
34 | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
35 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
36 | User | char(32) | utf8mb3_bin | NO | PRI | | | select,insert,update,references | |
37 +-------+----------+-------------+------+-----+---------+-------+---------------------------------+---------+
38 mysql.test: Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
39 # Tests related to deprecation of ssl options
40 # Tests related to invalid option of --ssl-mode
41 # Tests related to valid values of --ssl-mode
42 Variable_name Value
43 Ssl_cipher
44 Variable_name Value
45 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
46 Variable_name Value
47 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
48 Variable_name Value
49 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
50 Variable_name Value
51 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
52 # Check behavior when --ssl-mode is not passed explicitly
53 Variable_name Value
54 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
55 # Check behavior when multiple times --ssl-mode is passed
56 Variable_name Value
57 Ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
58 # Check the legacy options
59 # Cleanup
60 DROP USER 'user1'@'%';
61 DROP TABLE mysql.test;