MySQL remote access

[Afrow UK]

I'm the main developer at http://ecs.hiprmod.net (on of the sites under the hiprmod.net domain hosted by Apis Networks). We run a game server for Half-Life and we want players to register on our site before they can play on our server.

This has all been set up... I have written the code for the website and have written the code for the server plugin, except I've come to find that the MySQL database does not allow remote access!!

I've tried using MySQL Query Browser to connect and that fails with:

MySQL Error Number 1045
Access denied for user 'hipmod_ecs'@'88.104.146.108' (using password: YES)

I get the same if I try to connect the database through PHP on the same webserver (i.e. if I use hiprmod.net instead of localhost as the host)!

Help!

Stu

[Matt]

Add a new user with the host %. After adding that user, go back to the database section in MySQL Manager that you'd like to grant access. Tick the default permissions and save.

Also it's difficult to allow remote access to a user that doesn't exist in the grant table:

mysql> select * from db where user = 'hipmod_ecs';
Empty set (0.00 sec)

mysql> select * from user where user = 'hipmod_ecs';
Empty set (0.00 sec)

[Afrow UK]

Thanks

I knew something wasn't set up right. Now I've got to wait for the registrar (MarmaladeMan) to follow these instructions... I don't have access myself :(

Stu

[MarmaladeMan]

Doh, sorry Matt, I should have seen that in the MySQL Manager. Afrow reports that it's working, thanks!