mysql.sh

mysql -u root -p

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';


SELECT user();
SELECT user FROM mysql.user;
SELECT user,host FROM mysql.user;
SELECT host,user,authentication_string FROM mysql.user;

SHOW DATABASES;
CREATE DATABASE testDB;


GRANT ALL PRIVILEGES ON testDB . * TO 'newuser'@'localhost';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

FLUSH PRIVILEGES;

SHOW GRANTS FOR 'newuser'@'localhost';



quit