It seems that the usual 'grant all on *.* to .....' does not work on this version of mysql, so I am finding it difficult to set up a user who can access my database server remotely. I altered the user table in the mysql database to have % as host, but it makes no diff. I note that I *can* access the 'test' database locally with any username and no password though, but this does not work remotely. Is it possible that mysqld is blocking remote hosts at a lower level than the user table? I don't have any problems with a later version of mysql, but I really don't want to move versions on this server as uptime is very important.
TIA
Garry
TIA
Garry