Mysql

From AWVVO
Revision as of 06:40, 18 January 2025 by Admin (talk | contribs) (Create user)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Create user

CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'newuser'@'localhost';