set password = password('password');
use mysql;
update user set Host='%' where User='root';
flush privileges;
grant all privileges on *.* to 'user'@'host' with grant option;