Contributor
Kyle
October 23
Edit

Create a MySQL user to have both local and remote access for all databases

Create a mysql user:  
CREATE USER 'myUser'@'localhost' IDENTIFIED BY 'YourNewPassword'; 
CREATE USER 'myUser'@'%' IDENTIFIED BY 'YourNewPassword';
Then
GRANT ALL ON *.* TO 'myUser'@'localhost'; 
GRANT ALL ON *.* TO 'myUser'@'%';
Optional: limit user to single database:
GRANT ALL ON name_of_database.* TO 'myUser'@'localhost';
GRANT ALL ON name_of_database.* TO 'myUser'@'%';
Don't forget to flush: 
FLUSH PRIVILEGES;
Tips: optional for MySQL 8.0 if using 3rd party remote access with error "Authentication plugin 'caching_sha2_password' cannot be loaded"
ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword'; 
Send us a message. We will reply as soon as we can.