MySQL Add User Remote Access Permission
GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY '' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;The first statement adds a user and password, the second statement elevates permissions. Just change the highlighted text to what you need and you’re done.