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';