mysql –u root -p
Grant all privileges on *.* to root@”%” identified by “rootpassword” with grant option;
Grant all privileges on mysitedb.* to root@localhost;