# Setup for Remote Access

1. Grant Privileges
    
    
    1. ```
        <span class="pln">GRANT ALL ON </span><span class="str"><database></span><span class="pun">.*</span><span class="pln"> TO </span><span class="str"><user></span><span class="pun">@</span><span class="str">'%'</span><span class="pln"> IDENTIFIED BY </span><span class="str">'<password>'</span><span class="pun">;</span>
        ```
2. Testing Remote Access
    
    
    1. ```
        <span class="pln">mysql </span><span class="pun">-</span><span class="pln">uroot </span><span class="pun">-</span><span class="pln">p </span><span class="pun">-</span><span class="pln">h </span><span class="pun"><</span><span class="pln">host</span><span class="pun">/</span><span class="pln">ip</span><span class="pun">></span> <span class="str"><database></span>
        ```