MySQL Remote connection database

Today a friend of mine for many years found me and said MySQL how remote database, our general case. The business system server and the database server are separated. So it involves a remote connection to the MySQL server. Let me show you how to solve this problem.

1. Authorization law. You want the user to connect to the MySQL server with a password from any host.
GRANT All privileges on * * to ' user ' @ '% ' identified by ' password ' with GRANT OPTION;
2. If you want to allow the specified user to connect to the MySQL server from the IP-192.168.90.101 host and use the password as the password
GRANT All privileges on * * to ' root ' @ ' 192.168.90.101 ' identified by
' 123 ' with GRANT OPTION;

MySQL Remote connection database