MySQL create user and grant privilege for certain table

zencitta / 261854162

Notes

0 stars 0 forks source link

Open zencitta opened 8 years ago

zencitta commented 8 years ago

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
or (GRANT ALL PRIVILEGES ON {DataBaseName} . * TO 'newuser'@'localhost'; )
FLUSH PRIVILEGES;