I added the IP Address 97.90.129.25 earlier in the article (yours will be different). You should see the IP Address you added earlier. Log into cPanel and locate the Remote MySQL icon. To remove an Access Host you’ll want to follow the same steps you took to add an Access Host. Click the carrot next to your database name and it will expand with the tables inside of that database. By default, the database is not expanded so you won’t see the database tables. If your settings are correct, you will see a new screen with your database in the left hand column. Password: Your cPanel password OR Your DB username passwordĪTTENTION: If you created a new DB User, don’t forget to assign that DB User privileges to the database you wish to grant access to.Īfter configuring your settings in the Session Manager, you’ll want to click the Open button at the bottom of the screen. User: Your cPanel username OR Your DB username Hostname/IP: Your server’s Shared IP Address If you do not know your server’s Shared IP Address you’ll want to log back into cPanel, click the Server Information link (right sidebar), and you’ll see a row for Shared IP Address. In this example, I’m using the Shared IP Address of the server this particular account is on. You can use the Hostname or IP address of your server. This is where you’ll configure HeidiSQL to connect to your database.Įnter in your information into the session manager. HeidiSQL will open with the Session Manager. Remember, you will not be able to connect to your database remotely until you have put in a request to our support team to add your IP address to your server’s allow list.Īfter adding your IP address as an Access Host in cPanel you’ll want to open HeidiSQL. The host “97.90.129.25” was added to the access list. An easy way to find out your IP is by simply searching Google for “what’s my ip” and it should return your public IP address.Īfter clicking the Add Host button you’ll see a message similar to the one shown here In the blank field box you’ll want to add your IP Address as an Access Host, which will allow you to connect to your database remotely. You’ll then be taken to the next page to Add an Access Host. Once you’ve logged into cPanel you’ll want to look for the DATABASES section where you’ll find the Remote MySQL icon. Now that you’ve downloaded HeidiSQL you’ll want to log into cPanel. HeidiSQL is compatible with Windows and newer MacOS X versions according to their website. In this article we’re going to use HeidiSQL ( Official Site | Download Link), which is a free Open Source project that’s been in active development for over 9 years. How to Connect Remotely to Your Databaseĭownload HeidiSQL, phpMyAdmin, or Sequel ProĪny of the three MySQL tools will allow you to connect remotely and manage your databases.Download HeidiSQL, phpMyAdmin, or Sequel Pro.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |