Re: external connection

[Daniel Kasak]

Lecul, Fred wrote:

Hmm...

Yeah, its not connecting!

Im getting:

ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server

Any idea's??

Fred
 

Have a look at http://www.mysql.com/doc/en/Adding_users.html

Note the example about a page down that says:

mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
   ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
This will set up a user 'monty' who can connect from 'localhost' with 
the password 'some_pass'.

You need to use the same syntax, but instead of 'localhost' use '10.%' 
or something like that.
The percentage sign (%) is a wildcard.

eg:

mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'10.%'
   ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
I think you need the quotes around the ip address part. I haven't used 
the grant commands for a while.

See how you go. If you still have problems, it really would help if you 
tell us what grant commands you've used so far.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]