MySQL Databases
Jump to navigation
Jump to search
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';
- Creat new UTF-8 database called
mydatabase
CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;