Many years ago I was working at a university and had to create
accounts for students every semester. Each account needed a
random password and there were several hacks used to do
that. One of the new features in MySQL 8.0.18 is the
ability to have the system generate a random password.
Example
SQL > create user 'Foo'@'%' IDENTIFIED BY RANDOM
PASSWORD;
+------+------+----------------------+
| user | host | generated password |
+------+------+----------------------+
| Foo | % | Ld]5/Fkn[Kk29/g/M;>n |
+------+------+----------------------+
1 row in set (0.0090 sec)
Another Example
SQL > ALTER USER 'Foo'@'%' IDENTIFIED BY RANDOM
PASSWORD;
+------+------+----------------------+
| user | host | generated password |
…
Showing entries 1 to 1
Oct
31
2019
Showing entries 1 to 1