Debian Codegraph @

mysql-test/suite/x/r/connection_local_scope.result

raw
1 #
2 ## Preamble
3 #
4 #
5 ## Testcase
6 #
7 call mtr.add_suppression("Hostname '.*' does not resolve to .*");
8 call mtr.add_suppression("IP address .* could not be resolved: .*");
9
10 # Using MySQL client
11 # Account user1 was created with interface name.
12 # The authentication must be succesful
13 mysql: [Warning] Using a password on the command line interface can be insecure.
14 USER()
15 user1@localhost
16 # Account user2 was created without interface name.
17 # The authentication must fail because account IP
18 # and client IP doesn't match
19 mysql: [Warning] Using a password on the command line interface can be insecure.
20 ERROR 1045 (28000): Access denied for user 'user2'@'localhost' (using password: YES)
21
22 # Using mysqlxtest
23 # Account user1 was created with interface name.
24 # The authentication must be succesful
25 RUN SELECT USER()
26
27 USER()
28 user1@localhost
29 0 rows affected
30 Mysqlx.Ok {
31 msg: "bye!"
32 }
33 ok
34 # Account user2 was created without interface name.
35 # The authentication must fail because account IP
36 # and client IP doesn't match
37 in main, line 0:ERROR: Authentication failed, check username and password or try a secure connection (code 2510)
38 not ok