Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    1,032

    Database restore help

    Hello,

    Does anyone have experience with why when a restore request from a 'dump' sql text file would generate the below error?

    Error 1130: Host "xxx.xxx.xxx.xxx" is not allowed to connect to this MySQL Server
    The user that I have tried are the assigned SQL DB user and also the root user but this message keeps coming up.

    I check the syntax but I don't see any errors.

    Errors generated when I enter line by line from phpmyadmin gives me an error message that has no error at all....

    Any ideas of how I could overcome this?
    -=- GQ Hong -=-
    GalacNet WebMaster

  2. #2
    Join Date
    Sep 2002
    Location
    Top Secret
    Posts
    11,686
    Are you using a control panel of any kind?
    The error you're seeing isn't a "user" error, this is a "host" error, there are differences. If you're using CPanel, you can enable the host connects, first in WHM, then in CPanel itself. If not, well, I forget the raw syntax for the sql tables, been too long since I looked at it.
    WHMCS Guru - WHMCS addons, management, support and more.
    WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
    Always looking for Linux, WHMCS, Support Desk work. PM for details

  3. #3
    Join Date
    Sep 2002
    Location
    Canada
    Posts
    452
    Enable remote access for that IP:

    Use the MySQL monitor to grant privileges.

    Start the MySQL monitor with this command:

    mysql

    or:
    /usr/local/mysql/bin/mysql

    Your shell prompt should now look like this:

    mysql>

    Run this command:

    GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY "PASSWORD";

    - USERNAME is the username that you would like to create.
    - IP is the public IP address of your remote connection. See examples
    - PASSWORD is the password you would like to use for this username.

    You now must flush MySQL's privileges. Run this command:

    FLUSH PRIVILEGES;

    Run this command to exit MySQL:

    exit;


    compliments of:
    http://help.hardhathosting.com/question.php/87
    Reliability Performance Integrity

  4. #4
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    1,032
    I am running this from SHELL as the ROOT user and also using a user with full access to all the commands.

    I also tried it over phpmyadmin but was also not able to even insert the lines one by one.
    -=- GQ Hong -=-
    GalacNet WebMaster

Posting Permissions

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