| 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 |