cPanel and MySQL Access Hosts | A Small Orange Support

<p>Let's say you're developing a script on your PC at home, and you need to connect to your database remotely using a&nbsp;MySQL&nbsp;admin program. No problem. This procedure is a little quirky, but here are the steps to grant remote access to your database.<br />
<em><strong>Note:</strong> if you don't have a database yet, start here.</em><br />
<br />
We'll assume you are using the following information:<br />
<br />
<em>&nbsp; &nbsp;database: example_mydb&nbsp;</em><br />
<em>&nbsp; &nbsp;database user: example_dbuser</em><br />
<em>&nbsp; &nbsp;IP address given to your computer from your ISP: 1.2.3.4</em><br />
<em>&nbsp; &nbsp;server name: server.asmallorange.com (get the IP of your server <a href="https://www.asmallorange.com/help/article/aso-find-the-ip-address-of-your-server" rel="noopener" target="_blank">here</a>)</em></p>

<h2 id="hn_Access_Hosts">Access Hosts</h2>

<ol>
	<li>Log in to cPanel and click&nbsp;MySQL&nbsp;Databases</li>
	<li>Scroll down to Access Hosts</li>
	<li>Enter your IP address (eg, 1.2.3.4) in the field next to&nbsp;Host (% wildcard is allowed):&nbsp;</li>
	<li>Click&nbsp;Add Host</li>
	<li>You can enter something like 1.2.3.% if you want to allow a range if IP addresses<br />
	<em><strong>Note:</strong> this is not safe; it will allow anyone in that entire network range to have access to your database if they are able to obtain your password.</em></li>
</ol>

<h2>Notify Us of IP</h2>

<p class="p1">We take MySQL security very seriously, so in addition to the standard cPanel procedure we also need to add the remote IP to the firewall. Please&nbsp;<a href="https://chat.asmallorange.com/" rel="noopener" target="_blank">contact Support</a> and notify us of the IP address so that we can make sure it has access to MySQL.</p>

<h2 id="hn_Remove_User_from_Database">Remove User from Database</h2>

<p>Currently, the database user only has access through localhost, so you need to force it to recognize the IP address.</p>

<ol>
	<li>Scroll up to the&nbsp;Current Databases&nbsp;and look for the database 'example_mydb'</li>
	<li>You'll see two delete buttons, one next to the database name (example_mydb) and one under that next to the username (example_dbuser).</li>
	<li>Click the Delete&nbsp;next to the database username<br />
	<br />
	The next screen says:<br />
	<em>Account Removed from Access List</em><br />
	<em>Deleted the user example_dbuser from the database example_mydb.&nbsp;</em></li>
</ol>

<h2 id="hn_Add_User_to_Database">Add User to Database</h2>

<ol>
	<li>Scroll back down to&nbsp;Add Users to Your Databases</li>
	<li>Select the user 'example_dbuser' from the dropdown menu on the left and the database 'example_mydb' from the dropdown menu on the right.</li>
	<li>Click&nbsp;Add User to Database</li>
</ol>

<h2 id="hn_Testing_your_Connection">Testing your Connection</h2>

<p>Now, using your PC and remote&nbsp;MySQL&nbsp;client, enter the connection information for your database, database user, and the server name or IP address.</p>

<div class="indent">If you run into problems with any of this, double-check the steps above or contact our Support team for assistance.</div>

<div class="indent">&nbsp;</div>

<div class="indent">&nbsp;</div>

<div class="indent"><em>See also <a href="https://www.asmallorange.com/help/article/aso-find-the-ip-address-of-your-server" rel="noopener" target="_blank">Find the IP Address of Your Server</a>, <a href="https://www.asmallorange.com/help/article/aso-find-your-ip-address" rel="noopener" target="_blank">What's My IP Address?</a></em></div>