How to connect remote mysql database?

MySQL stores permissions based on a literal 'user'@'host' format. If you would like a user to be able to connect from everywhere, you would put the literal wild card in the GRANT command:

GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' identified by 'userpass';

You now have separate privileges for:
'user_name'@'ip address'
'user_name'@'oldservername'
'user_name'@'localhost' and
'user_name'@'%'. (and maybe others)

Here are some articles with different ways of looking at grants:

• https://www.thegeekdiary.com/how-to-list-users-and-privileges-in-mysql/

• https://dba.stackexchange.com/questions/23265/mysql-show-grants-for-all-users

• https://stackoverflow.com/questions/22501105/mysql-grant-all-privileges-to-a-user-on-everywhere