Results 1 to 10 of 15

Threaded View

  1. #1
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,021
    Plugin Contributions
    32

    Default Remote MySQL Access Error--STUMPED--HELP!!!

    I use SQLYog Enterprise 64 to manage many of my MySQL tasks.. I have NEVER had any issues using this tool with any host until now.. Client is hosted with SiteGround. When I initially took a backup of the client's site, I grabbed a copy of the DB using remote SQL as usual.. Now that I need to make some final changes to the live site in preparation for pushing my changes to the live site, I am unable to connect to the database using remote SQL.

    When I try to connect to a remote MySQL database from my mySQL client software, I get “ERROR 1130: Host is not allowed to connect to this MySQL server”

    The error I am getting appears to imply that something on Siteground's end needs to be modified.. Found this article which seems on point.. http://www.thegeekstuff.com/2010/08/...nt-connection/

    There are no leading spaces in any part of the authentication (user name, password, host name).. I've tried connecting on four different PCs in my house using both my own ISP and my next door neighbors ISP. I even tried from my neighbor's PC.. The result is the same..

    Finally I tried pinging the host name and am unable to ping the host name I am using to connect.. Siteground however maintains that the issue is local to my PC..

    I could use some help here because I am stumped..
    Last edited by DivaVocals; 12 Sep 2015 at 07:01 AM.
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

 

 

Similar Threads

  1. Remote MySQL database
    By arcticbit in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 2 Nov 2010, 02:18 PM
  2. stumped.. really stumped Error 500...again
    By rwslippey in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 1 Jul 2010, 02:40 AM
  3. remote access in zencart database
    By vr4indian in forum Installing on a Windows Server
    Replies: 1
    Last Post: 21 Nov 2006, 09:57 AM
  4. how about using a remote mySQL server
    By ericgu in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 7 Oct 2006, 04:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg