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...
Create a remote user for single DB access.
GRANT ALL PRIVILEGES ON new_db.* TO 'new_db_user'@'%' IDENTIFIED BY 'YourUserPassword';
FLUSH PRIVILEGES;
...