Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Kevin Barry
I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306 port. The error I receive is: Could not

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Richard Whitney
Quoting Kevin Barry [EMAIL PROTECTED]: I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Adam
Kevin, Could be a few things causing problems. Lets look at the most obvious. First, make sure you can login locally as root. Second, MySQL authenticates based on user, password, and host. If you have a know user with the right password coming from an unknown host MySQL will bounce you.