I permessi di mysql


CREATE USER 'root'@'172.21.3.35' IDENTIFIED BY '';
GRANT ALL ON *.* TO 'root'@'172.21.3.35' WITH GRANT OPTION;
FLUSH PRIVILEGES;


ATTENZIONE:

In 4.1.x, you don’t need to use CREATE USER. Simply using GRANT to
grant privileges to a user implicitly “creates” the user.

Quindi per la versione 4.1 e precedenti:

GRANT ALL ON *.* TO 'root'@'172.21.3.35' WITH GRANT OPTION;
SET PASSWORD FOR 'root'@'172.21.3.35' = PASSWORD('mypass');
FLUSH PRIVILEGES;