MySQL Not Working

[okiedoke]

Hi guys.

 

I am having a strange problem that I can't seem to get my head around.

 

The only special circumstances for my problem are that I have cPanel/WHM installed on the same machine as TCAdmin 2.0 and I am running CentOS 6.5 64Bit.

 

When I setup TCAdmin it asked me to provide MySQL details but I couldn't get it to work so I just chose SQLite instead which is fine.

 

I have migrated some GMod servers that we had running manually via SSH and they each connect to MySQL databases for player data and such.

 

I have noticed that they are now being refused access to the same databases they had previously been connecting to.

 

I tried running the 'Convert SQLite Database to MySQL' tool using the root login to a dedicated database (tcadmin). I use localhost as the host but I get an error 'Error - Access denied for user 'root'@'lin1.okiedoke.co.uk' (using password: YES)'. lin1.okiedoke.co.uk is the servers hostname but I provided 'localhost' as the host.

 

So I tried again using 127.0.0.1 and get the exact same error. So I decided to setup MySQL on my other server that is only used for DNS. I added a new user 'tcadmin' and a new database 'tcadmin'. I also made sure that my main box was allowed to connect to it remotely. Tried with these details and I get a similar error saying 'Error - Host 'lin1.okiedoke.co.uk' is not allowed to connect to this MySQL server ' even though I have allowed it in remote access on MySQL.

 

Does anybody have any ideas of what I could be doing wrong?

 

All my sites that need access to MySQL work fine and if I start one of the GMod servers from the command line manually, it connects to MySQL fine so it seems that TCAdmin is not doing something correctly.

 

Thanks in advance!

 

Tom.