thanhntmany / js-basic Goto Github PK

CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';

ALTER USER 'user'@'localhost' ACCOUNT UNLOCK;

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

or all database

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

SHOW GRANTS FOR 'username'@'localhost';

SELECT 
    u.User AS 'Username',
    u.Host AS 'Host',
    d.Db AS 'Database'
FROM 
    mysql.user u
LEFT JOIN 
    mysql.db d 
ON 
    u.User = d.User AND u.Host = d.Host
WHERE
    u.User = 'username';

SELECT User, Host FROM mysql.user;

SHOW DATABASES

CREATE DATABASE name_db;