| Author |
error 2003 - more info
|
|
| peterdawson_sa@yahoo.com 2005-04-27, 7:45 am |
| Hello,
The error 2003: Cant connect... is displayed if I try and run msql at
the server prompt.
Regards
Peter
| |
|
|
| peterdawson_sa@yahoo.com 2005-04-27, 5:45 pm |
| Dave,
Mysqld is loaded..and when I check in tcpcon port 3306 is listenning.
Regards
Peter
| |
| dabutler@riverview.nsw.edu.au 2005-04-27, 8:45 pm |
| are you trying to connect from a Windows XP machine with sp2?
As I'm having the same trouble. I can connect from a win xp sp1 machine
but not a sp2 machine. I've turned the firewall off(windows supplied) and
also tried with it on but with exceptions for the mysql port (3306) with
no joy.
I've looked on many forums and 'google' but no definate solution. I'd
love to get to the bottom of this one. Any other clues folks.....?
| |
|
|
| peterdawson_sa@yahoo.com 2005-04-28, 5:45 pm |
| Dave,
load mysql -u <name> -p result ins the same error 2003: Can't connect...
Regards
Peter
| |
| dabutler@riverview.nsw.edu.au 2005-05-01, 5:45 pm |
| > Does loading mysql on the same server work then ?
>
> load mysql -u <name> -p
>
> Cheers Dave
>
I can run mysql on my local machine and connect OK, but when I try to
connect to mysql on a different machine/server I get the 2003: can't
connect to mysql 'myHostName'(10060) error.
any clues on what settings I can change locally or on the mysql/apache
server.....?
very frustrated over this issue
| |
| peterdawson_sa@yahoo.com 2005-05-01, 8:45 pm |
| Dave,
originally I changed the address using inetcfg...this resulted in the
Mysql server indicating that it was listening for address 10.0.6.23 is
the correct address of the server.
But to get it to work I changed the address back using:
http://serveripaddress:8008 *remote manager and selecting the
ipaddress management link on the left. scrolled down to where the Mysql
server ipaddress was detailed. Clicked on it and changed it back to
0.0.0.0 .... It now works. Previously and without success I had changed
it back to the loopback address in the my.cnf file.
Regards
Peter
| |
| Dave Parkes 2005-05-02, 7:45 am |
| OK, I've never used that IP management bit in NRM myself, I stick to doing
the various apps individually. Just checked, I haven't actually got any IP
addresses in my.cnf ?
Cheers Dave
--
Dave Parkes [NSCS]
Occasionally resident at http://support-forums.novell.com/
You can register now for the EMEA GroupWise Summit - June 28/29 The
Hague, Netherlands
http://www.groupwiser.net/Summit
| |
| Dave Parkes 2005-05-02, 7:45 am |
| Not sure what you mean here, you can connect from the one workstation to
the server or connect from mysql loaded on the server running mysqld ?
Is the login you are using allowed to connect from hosts other than the
one running mysqld ?, that is set in the mysql security config
Cheers Dave
--
Dave Parkes [NSCS]
Occasionally resident at http://support-forums.novell.com/
You can register now for the EMEA GroupWise Summit - June 28/29 The
Hague, Netherlands
http://www.groupwiser.net/Summit
|
|
|
|