> Hi,
>
> I am not able to connect mysql server through other
> machine in a
> network. I have already assign the user using the command of
> "Grant all on
> *.* to user@ipaddress identified by "password". Then, try to connect using
> "mysql -u user@ipaddress -h firstserver -ppassword". But, I got the
> following error.
>
> Warning: MySQL Connection Failed: Can't connect to MySQL server on
> 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on
> line 1
> Hi,
>
> I am not able to connect mysql server through other
> machine in a
> network. I have already assign the user using the command of
> "Grant all on
> *.* to user@ipaddress identified by "password". Then, try to connect using
> "mysql -u user@ipaddress -h firstserver -ppassword". But, I got the
> following error.
>
> Warning: MySQL Connection Failed: Can't connect to MySQL server on
> 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on
> line 1
You tried to connect using the mysql client, and got an error from... php...
Try "mysql -u user -h firstserver -ppassword", the @ipaddress is your own ip
address and is automatically detected, it is NOT part of the username.
> oh I forgot to tell, I have used a firewall "ipchains". what
> port do I have
> to open for mysql: tcp or udp
Port 3306, tcp.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
