MySQL

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password'); SET PASSWORD FOR 'root'@'hostname' = PASSWORD('password');

CREATE USER 'user'@'host' IDENTIFIED BY 'password';

grant all privileges on *.* to 'user'@'host' with grant option;

flush privileges;

give root grant permissions from remote server grant all privileges on *.* to 'root'@'hostname' with grant option;