Setup a new database on a machine I didn't setup. I can from the local machine issue a;

mysql -u root -p <enter>, submit the password and I'm in.

I read through
http://dev.mysql.com/doc/refman/5.1/...ss-denied.html

and not sure on the issue. If I submit from the remote server;
mysql -u remote.server.ip -p <enter> I get prompted, I enter the root password and get the following;
ERROR 1045 (28000): Access denied for user 'root'@'' (using password: YES)

I try it using;
mysql -u root -h remote.server.ip -p <enter>
I get prompted, but regardless to a good or bad password it just sits there.

I did connect locally, and did a;
GRANT USAGE ON *.* to root@'myremoteIP' IDENTIFIED BY 'rootpassword';

and figured that was it, but I read on bind addressing, etc. but if I get the password prompt, does that rule that stuff out?

A ps on that box shows;
/bin/sh /usr/local/mysql/bin/safe_mysqld

So not sure if that helps at all either.

Thanks

Did you follow this guide and configure the 'my.cf' file for remote connections?

http://www.cyberciti.biz/tips/how-do...se-server.html

You will need to bind the server I.P. to the following entry in the file:

Almost got it. I did look at a similar page, have the bind-to set, but can't connect remotely due to firewall rules. I have 3306 open to the IP, but when I stop iptables I do get in, I start IPtables, I can't. So I am thinking it's an outbound rule, so will look more into that...

Thanks.

Sorry I'm not more familiar with IPtables or your specific Firewall but sounds like you're in the right direction.