12 lines
352 B
Plaintext
12 lines
352 B
Plaintext
FLUSH PRIVILEGES;
|
|
SELECT USER(),CURRENT_USER();
|
|
USER() CURRENT_USER()
|
|
root@ skip-grants user@skip-grants host
|
|
CREATE USER u1@localhost;
|
|
ALTER USER u1@localhost IDENTIFIED BY 'pass1';
|
|
SET PASSWORD FOR u1@localhost = 'pass2';
|
|
SET PASSWORD = 'cant have';
|
|
ERROR 42000: Can't find any matching row in the user table
|
|
DROP USER u1@localhost;
|
|
End of 5.7 tests
|