GRANT ALL PRIVILEGES ON db.table TO 'user'@'%' IDENTIFIED BY 'password;'
GRANT ALL PRIVILEGES ON db.table TO 'user'@localhost IDENTIFIED BY 'password;'