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
|
#############################
# Creating 3 users #
#############################
CREATE USER 'user_1'@'localhost' identified by 'pass_1';
CREATE USER 'user_2'@'localhost' identified by 'pass_2';
CREATE USER 'user_3'@'localhost' identified by 'pass_3';
Invoking mysql_config_editor for user1 with correct password
Enter password:
USER() CURRENT_USER()
user_1@localhost user_1@localhost
Invoking mysql_config_editor for user2 with correct password
Enter password:
USER() CURRENT_USER()
user_2@localhost user_2@localhost
Invoking mysql_config_editor for user3 with correct password
Enter password:
USER() CURRENT_USER()
user_3@localhost user_3@localhost
Invoking mysql_config_editor for user3 with wrong password
Enter password:
WARNING : 'login_path_3' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
USER() CURRENT_USER()
user_3@localhost user_3@localhost
Invoking mysql_config_editor for user2 and not changing the password
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
USER() CURRENT_USER()
user_2@localhost user_2@localhost
invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to wrong value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
Invoking mysql_config_editor for user2 and changing the password to correct value
Enter password:
WARNING : 'login_path_2' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) :
USER() CURRENT_USER()
user_2@localhost user_2@localhost
############################################
# .mylogin.cnf file before cleanup #
############################################
[login_path_1]
user = "user_1"
password = *****
host = "localhost"
[login_path_3]
user = "user_3"
password = *****
host = "localhost"
[login_path_2]
user = "user_2"
password = *****
host = "localhost"
#################################################
# empty .mylogin.cnf file after cleanup #
#################################################
################################################
# Dropping users user1, user2 and user3 #
################################################
DROP USER 'user_1'@'localhost';
DROP USER 'user_2'@'localhost';
DROP USER 'user_3'@'localhost';
|
