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;