Sql commands

From James's Wiki
Revision as of 00:42, 20 December 2021 by Ractive (talk | contribs)
SHOW DATABASES;
DROP DATABASE <database name>;
CREATE DATABASE <database name>;
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database_name>.* TO 'username'@'localhost';
SHOW GRANTS FOR 'username'@'localhost';
DROP USER 'username'@'localhost';
FLUSH PRIVILEGES;