Facing problem with connection on LAN

Hi all,
I have to implement a project for my college
placement information system. I chose mysql with php
on IIS. I am newbie with mysql. The design is allmost
over but I am facing a critical problem. my ip is
172.31.65.21 (hostname is ginie) on the college LAN.
When I try to access the database server
(mysql-5.0.0-alpha-nt) which is installed on my system
I get the following error
C:\mysql\bin>mysql -h 172.31.65.21 -u root -p
Enter password:
ERROR 1130 (): #HY000Host 'ginie' is not allowed to
connect to this MySQL server
Allthough it connects well with localhost. Can anyone
tell me what can be the problem. Is there a problem
with the server coniguration. Please help as my mid
term project is at stake.
any help and suggestions would be higly appreciated,
shatam

____________________________________________________________ ____________
Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Facing problem with connection on LAN

you are probably missing privileges for accessing the database remotely...
try this page:
http://dev.mysql.com/doc/mysql/en/GRANT.html

it's like: grant all priviledges on dbname.* for user@source-ip
identified by 'password';

good luck

dan
shatam bhattacharya wrote:

>Hi all,
> I have to implement a project for my college
>placement information system. I chose mysql with php
>on IIS. I am newbie with mysql. The design is allmost
>over but I am facing a critical problem. my ip is
>172.31.65.21 (hostname is ginie) on the college LAN.
>When I try to access the database server
>(mysql-5.0.0-alpha-nt) which is installed on my system
>I get the following error
>C:\mysql\bin>mysql -h 172.31.65.21 -u root -p
>Enter password:
>ERROR 1130 (): #HY000Host 'ginie' is not allowed to
>connect to this MySQL server
>Allthough it connects well with localhost. Can anyone
>tell me what can be the problem. Is there a problem
>with the server coniguration. Please help as my mid
>term project is at stake.
>any help and suggestions would be higly appreciated,
>shatam
>
>___________________________________________________________ _____________
>Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/
>
>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: Facing problem with connection on LAN

> -----Original Message-----
> From: shatam bhattacharya [mailto:mailshatam@yahoo.co.in]=20
> Posted At: Friday, April 16, 2004 1:04 PM
> Posted To: MySQL
> Conversation: Facing problem with connection on LAN
> Subject: Facing problem with connection on LAN
> Importance: Low
>=20


You need to GRANT permissions:

http://dev.mysql.com/doc/mysql/en/GRANT.html


-Kevin


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Facing problem with connection on LAN

grant all on *.* to root@172.31.65.21 identified by 'yourpassword'
----- Original Message -----
From: "shatam bhattacharya"
To:
Sent: Saturday, April 17, 2004 4:04 AM
Subject: Facing problem with connection on LAN


> Hi all,
> I have to implement a project for my college
> placement information system. I chose mysql with php
> on IIS. I am newbie with mysql. The design is allmost
> over but I am facing a critical problem. my ip is
> 172.31.65.21 (hostname is ginie) on the college LAN.
> When I try to access the database server
> (mysql-5.0.0-alpha-nt) which is installed on my system
> I get the following error
> C:\mysql\bin>mysql -h 172.31.65.21 -u root -p
> Enter password:
> ERROR 1130 (): #HY000Host 'ginie' is not allowed to
> connect to this MySQL server
> Allthough it connects well with localhost. Can anyone
> tell me what can be the problem. Is there a problem
> with the server coniguration. Please help as my mid
> term project is at stake.
> any help and suggestions would be higly appreciated,
> shatam
>
> ____________________________________________________________ ____________
> Yahoo! India Matrimony: Find your partner online.
http://yahoo.shaadi.com/india-matrimony/
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=eghkn03@engsvr.ust.hk
>
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Facing problem with connection on LAN

Thanks for this page ... It looks like this is what I need, however...

When I grant privileges, and then go to register the database I keep getting
the same error:

For example: Access denied for user XYZ@cfmx09.onlinecorp.com

cfmx09@onlinecorp.com resolves via DNS to the machine root IP 209.50.136.21

The only account that can access my databases is the root account. WHY?


Online Corporation of America
Sales Support & Customer Service
=========================================
Sales:1-570-686-2300
Fax:1-570-686-9090
ICQ#:149075399
http://www.OnlineCorp.com
COLDFUSIONHOSTING.COM
COLDFUSION HOSTING & DEDICATED SERVERS
http://www.ColdFusionHosting.com
QUICKCART.COM
ADVANCED E-COMMERCE SHOPPING SYSTEM
http://www.QuickCart.com
BULK DOMAIN HOSTING
Wholesale Bulk Hosting for Resellers
http://www.BulkDomainHosting.com

-----Original Message-----
From: PF: MySQL [mailto:ml.mysql@in-genius.com]
Sent: Friday, April 16, 2004 4:20 PM
To: win32@lists.mysql.com
Subject: RE: Facing problem with connection on LAN

> -----Original Message-----
> From: shatam bhattacharya [mailto:mailshatam@yahoo.co.in] Posted At:
> Friday, April 16, 2004 1:04 PM Posted To: MySQL
> Conversation: Facing problem with connection on LAN
> Subject: Facing problem with connection on LAN
> Importance: Low
>


You need to GRANT permissions:

http://dev.mysql.com/doc/mysql/en/GRANT.html


-Kevin


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=ek@onlinecorp.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Facing problem with connection on LAN

What did your grant statement look like exactly? To add a username that
can access the databases (depending on the level of access you want to
give) you need to specify either the host name (ie;
'computer.onlinecorp.com') or specify '%' which is the same as saying
'allow user this access from all hosts' (except for localhost).

So for instance you want to grant select access to a particular user on
ALL your databases from ANY host (except for localhost), you would use
this command:

grant select on *.* to user@'%' identified by 'your_password';

Do not specify IP addresses for the host, they must be the host name of
the computer, usually the FQDN of the PC. Cheers.

Armando

-----Original Message-----
From: Elliott Kayne [mailto:ek@onlinecorp.com]
Sent: April 19, 2004 12:59 PM
To: 'PF: MySQL'; win32@lists.mysql.com
Subject: RE: Facing problem with connection on LAN
Importance: High


Thanks for this page ... It looks like this is what I need, however...

When I grant privileges, and then go to register the database I keep
getting the same error:

For example: Access denied for user XYZ@cfmx09.onlinecorp.com

cfmx09@onlinecorp.com resolves via DNS to the machine root IP
209.50.136.21

The only account that can access my databases is the root account. WHY?


Online Corporation of America
Sales Support & Customer Service
=========================================
Sales:1-570-686-2300
Fax:1-570-686-9090
ICQ#:149075399
http://www.OnlineCorp.com
COLDFUSIONHOSTING.COM
COLDFUSION HOSTING & DEDICATED SERVERS
http://www.ColdFusionHosting.com
QUICKCART.COM
ADVANCED E-COMMERCE SHOPPING SYSTEM
http://www.QuickCart.com
BULK DOMAIN HOSTING
Wholesale Bulk Hosting for Resellers http://www.BulkDomainHosting.com

-----Original Message-----
From: PF: MySQL [mailto:ml.mysql@in-genius.com]
Sent: Friday, April 16, 2004 4:20 PM
To: win32@lists.mysql.com
Subject: RE: Facing problem with connection on LAN

> -----Original Message-----
> From: shatam bhattacharya [mailto:mailshatam@yahoo.co.in] Posted At:
> Friday, April 16, 2004 1:04 PM Posted To: MySQL
> Conversation: Facing problem with connection on LAN
> Subject: Facing problem with connection on LAN
> Importance: Low
>


You need to GRANT permissions:

http://dev.mysql.com/doc/mysql/en/GRANT.html


-Kevin


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=ek@onlinecorp.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=dijital@shaw.ca


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org