Newbie Question

Sylvyr · #1 (**permalink**) 06-14-04, 12:54

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.

chrisranjana · #2 (**permalink**) 06-15-04, 03:25

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

Quote:

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