Setup for Remote Access

  1. Grant Privileges

    1. GRANT ALL ON <database>.* TO <user>@'%' IDENTIFIED BY '<password>';
  2. Testing Remote Access

    1. mysql -uroot -p -h <host/ip> <database>