Skip to content

Latest commit

 

History

History
24 lines (20 loc) · 406 Bytes

File metadata and controls

24 lines (20 loc) · 406 Bytes

Getting Started with MySQL

Start MySQL

sudo mysql # start MySQL

Create user

CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword';

Show all users

SHOW GRANTS FOR 'someuser'@'localhost';

Grant permissions

GRANT ALL PRIVILEGES ON * . * TO 'someuser'@'localhost'; FLUSH PRIVILEGES;

Delete user

DROP USER 'someuser'@'localhost';