MySQL grant user access


GRANT ALL ON databasename.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT ALL ON databasename.* TO 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Commenti

Post popolari in questo blog

Eclipse underscore not visible

Batch Convert CSV to XLSX with LibreOffice (OpenOffice)