Difference between revisions of "MySQL Databases"
(Created page with "Some MySQL handy oneliners: * List all users from running instance: SELECT User, Host, Password FROM mysql.user; * Create new user called <code>newuser</code> CREATE USER n...") |
(No difference)
|
Revision as of 14:12, 24 February 2019
Some MySQL handy oneliners:
- List all users from running instance:
SELECT User, Host, Password FROM mysql.user;
- Create new user called
newuser
CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';