Debian Codegraph @

mysql-test/suite/interactive_utilities/r/mysql_config_editor.result

raw
1 #############################
2 # Creating 3 users #
3 #############################
4 CREATE USER 'user_1'@'localhost' identified by 'pass_1';
5 CREATE USER 'user_2'@'localhost' identified by 'pass_2';
6 CREATE USER 'user_3'@'localhost' identified by 'pass_3';
7
8 Invoking mysql_config_editor for user1 with correct password
9 Enter password:
10
11 USER() CURRENT_USER()
12 user_1@localhost user_1@localhost
13
14 Invoking mysql_config_editor for user2 with correct password
15 Enter password:
16
17 USER() CURRENT_USER()
18 user_2@localhost user_2@localhost
19
20 Invoking mysql_config_editor for user3 with correct password
21 Enter password:
22
23 USER() CURRENT_USER()
24 user_3@localhost user_3@localhost
25
26 Invoking mysql_config_editor for user3 with wrong password
27 Enter password:
28 WARNING : 'login_path_3' path already exists and will be overwritten.
29 Continue? (Press y|Y for Yes, any other key for No) :
30 USER() CURRENT_USER()
31 user_3@localhost user_3@localhost
32
33 Invoking mysql_config_editor for user2 and not changing the password
34 Enter password:
35 WARNING : 'login_path_2' path already exists and will be overwritten.
36 Continue? (Press y|Y for Yes, any other key for No) :
37 USER() CURRENT_USER()
38 user_2@localhost user_2@localhost
39
40 invoking mysql_config_editor for user2 and changing the password to wrong value
41 Enter password:
42 WARNING : 'login_path_2' path already exists and will be overwritten.
43 Continue? (Press y|Y for Yes, any other key for No) :
44
45 Invoking mysql_config_editor for user2 and changing the password to wrong value
46 Enter password:
47 WARNING : 'login_path_2' path already exists and will be overwritten.
48 Continue? (Press y|Y for Yes, any other key for No) :
49
50 Invoking mysql_config_editor for user2 and changing the password to wrong value
51 Enter password:
52 WARNING : 'login_path_2' path already exists and will be overwritten.
53 Continue? (Press y|Y for Yes, any other key for No) :
54
55 Invoking mysql_config_editor for user2 and changing the password to wrong value
56 Enter password:
57 WARNING : 'login_path_2' path already exists and will be overwritten.
58 Continue? (Press y|Y for Yes, any other key for No) :
59
60 Invoking mysql_config_editor for user2 and changing the password to wrong value
61 Enter password:
62 WARNING : 'login_path_2' path already exists and will be overwritten.
63 Continue? (Press y|Y for Yes, any other key for No) :
64
65 invoking mysql_config_editor for user2 and changing the password to wrong value
66 Enter password:
67 WARNING : 'login_path_2' path already exists and will be overwritten.
68 Continue? (Press y|Y for Yes, any other key for No) :
69
70 Invoking mysql_config_editor for user2 and changing the password to wrong value
71 Enter password:
72 WARNING : 'login_path_2' path already exists and will be overwritten.
73 Continue? (Press y|Y for Yes, any other key for No) :
74
75 Invoking mysql_config_editor for user2 and changing the password to wrong value
76 Enter password:
77 WARNING : 'login_path_2' path already exists and will be overwritten.
78 Continue? (Press y|Y for Yes, any other key for No) :
79
80 Invoking mysql_config_editor for user2 and changing the password to correct value
81 Enter password:
82 WARNING : 'login_path_2' path already exists and will be overwritten.
83 Continue? (Press y|Y for Yes, any other key for No) :
84 USER() CURRENT_USER()
85 user_2@localhost user_2@localhost
86
87 ############################################
88 # .mylogin.cnf file before cleanup #
89 ############################################
90 [login_path_1]
91 user = "user_1"
92 password = *****
93 host = "localhost"
94 [login_path_3]
95 user = "user_3"
96 password = *****
97 host = "localhost"
98 [login_path_2]
99 user = "user_2"
100 password = *****
101 host = "localhost"
102
103 #################################################
104 # empty .mylogin.cnf file after cleanup #
105 #################################################
106
107 ################################################
108 # Dropping users user1, user2 and user3 #
109 ################################################
110 DROP USER 'user_1'@'localhost';
111 DROP USER 'user_2'@'localhost';
112 DROP USER 'user_3'@'localhost';