use mysql; UPDATE user SET Password=PASSWORD('<PASSWORD>') WHERE User='root'; FLUSH PRIVILEGES; exit; flush privileges;
CREATE USER '<USERNAME>'@'%' IDENTIFIED BY '<PASSWORD>'; flush privileges;
GRANT ALL PRIVILEGES ON <DBNAME>.* TO '<USERNAME>'@'%' WITH GRANT OPTION; flush privileges;
SHOW GRANTS FOR '<USERNAME>'@'%'