Shawn,
Many thanks for your very informative reply. It seems my server host will not allow remote direct access to the databases; access is only by using the cPanel software, which also gives access to a web interface of something called phpMyAdmin which works just about ok for very basic admin. Despite this they still have the facility to add 'access hosts' (which they then display as being added) giving the impression remote access is allowed, in fact this is redundant. Telnetting got no response from the 3306 port.
All rather tedious but hardly the end of the world.
Thanks and regards,
..matthew
[EMAIL PROTECTED] wrote:
You can test if you can "see" the server from your other user's machine by trying to connect to it with telnet. On the other user's machine, open a telnet session to the server's address on port 3306 and press ENTER a few times. You should be able to pick the server's executable name and version number out of the response. If you cannot make this connection, you have issues other than MySQL authentication. (http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html)
MySQL allows you to specify for which addresses a user account will be valid. If you grant permissions to "[EMAIL PROTECTED]" then someone can log in using that name only from that one address. To allow users to log in from multiple addresses MySQL, allows for wildcards in the "host" field of the "user" table. (http://dev.mysql.com/doc/mysql/en/Connection_access.html)
Here is a defacto FAQ about debugging various "access denied" problems: http://dev.mysql.com/doc/mysql/en/Access_denied.html
I have no experience with that particular product (cPanels interface) but it _should_ allow you to run the MySQL commands GRANT and REVOKE to let you manually work around any UI issue, if one exists.(http://dev.mysql.com/doc/mysql/en/GRANT.html)
Sorry I couldn't be more directly helpful, Shawn Green Database Administrator Unimin Corporation - Spruce Pine
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]