Results 1 to 2 of 2

Thread: Newbie Question

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Newbie Question

    You'll have to forgive me in advance for this one.. I'm really really new to the SQL world.

    Here's my question:

    How do I allow connections from specific, or all, addresses.

    I get the error:
    Error No. 1130
    Host 'my-host-24-172-0-45.my.isp.com' is not allowed to connect to this MySQL server


    How would I resolve that?


    Thanks for any help.

  2. #2
    Join Date
    May 2002
    Location
    chennai , tamil nadu , India
    Posts
    17

    mysql grant all privileges !

    Quote Originally Posted by Sylvyr
    You'll have to forgive me in advance for this one.. I'm really really new to the SQL world.

    Here's my question:

    How do I allow connections from specific, or all, addresses.

    I get the error:
    Error No. 1130
    Host 'my-host-24-172-0-45.my.isp.com' is not allowed to connect to this MySQL server


    How would I resolve that?


    Thanks for any help.
    http://dev.mysql.com/doc/mysql/en/Adding_users.html


    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    the @ option specifies from which host a particular user is allowed to connect to Mysql
    Chris, Developer, Chrisranjana.com,
    Ruby on Rails Developers,
    Php laravel Programmers,
    http://www.chrisranjana.com

Posting Permissions

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