Some useful mysql commands.
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *. * TO 'ssuser'@'localhost';
GRANT ALL PRIVILEGES ON [database name].[table name] TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
show databases;
show tables;
describe tables;
use [databaseName];
Back To Top