Grant remote user to database

The following command will grant an access to your remote server to connect to your preferred database server.

shell>mysql -u root -p
mysql>grant all on mydb.* to user@'ip.add.re.ss' identified by 'p455w0rd';