Find the answer to your Linux question:
Results 1 to 4 of 4
Hi, I have a problem with mysql. I can't connect to the server from a remote host. After the command:#mysql -h 192.168.0.1 -u root The following error always appears: ERROR ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jan 2005
    Location
    Germany
    Posts
    69

    Mysql Connection Problem(ERROR 1130)


    Hi,
    I have a problem with mysql. I can't connect to the server from a remote host.

    After the command:#mysql -h 192.168.0.1 -u root
    The following error always appears: ERROR 1130: Host 'testserver' is not allowed to connect to this MySQL server


    I mention that I can connect from the localhost ( the host where mysql server is running) with root user or other users.

    What can I do? How can I configure which remote hosts are allowed to connect to my mysql server?


    Thanks,
    ddaas

  2. #2
    Linux Newbie
    Join Date
    Dec 2004
    Location
    Barrie, Ontario
    Posts
    219
    Read the docs...
    Blog - KB5UMQ - Linux User #272983
    3 Rules:
    1) "It doesn't work..." is simply not useful information.
    2) Don't cross post!
    3) If you are asking for help, start by telling us your distro/os and version.

  3. #3
    Just Joined!
    Join Date
    Jan 2005
    Location
    Germany
    Posts
    69
    so I did. Problem solved.

    ddaas

  4. $spacer_open
    $spacer_close
  5. #4
    Just Joined!
    Join Date
    May 2005
    Posts
    1

    The same problem...

    Please help. I'm a beginner, and I've read the docs you say. But I didn't find the solution. What did you do?

Posting Permissions

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