skip-name-resolve

[elite90]

Hi,

 

When I uncomment skip-name-resolve in my.ini, basically MySQL breaks. Nothing is able to connect to it, including the mysql gui tools and the command line.

 

So I get this error on the TCAdmin log in page because it can't connect.

ExecuteReader requires an open and available Connection. The connection's current state is Closed. SQL Command: SELECT USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, TYPE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, COUNTRY, ZIP, HOME_PHONE, MOBILE_PHONE, EMAIL1, EMAIL2, STATUS, PARENT_ACCOUNT, EXTERNAL_ID, BILLING_ID, BILLING_STATUS, GROUP_ID, FILE_SERVER_ACCOUNT, ALLOWED_IPS, SUBUSER_ACCESS_SUPPORT, FILE_SERVER_CUSTOM_GAMES, MD5_PASSWORD FROM TC_USERS WHERE USER_ID = ''

 

Anyone have any experience with this?

 

Thanks

[Santino Cid]

Possible problem: Root by default is set to only be connected from localhost.

 

Because you are disabling DNS lookup, it does not know what 'localhost' is.

 

Simple solution: Grant permission for root to connect from 127.0.0.1.

Better solution: Don't use root for databases, only administration. And the above.

[elite90]

Thanks. I added 127.0.0.1 to all of the users and it works fine.

[jcroom]

Possible problem: Root by default is set to only be connected from localhost.

 

Because you are disabling DNS lookup, it does not know what 'localhost' is.

 

Simple solution: Grant permission for root to connect from 127.0.0.1.

Better solution: Don't use root for databases, only administration. And the above.

 

yea, you SHOULD really be creating tcadmin it's own user with only enough permissions to run tcadmin.

[elite90]

Each of the databases have their own user.