[ArcEmu]: Account registration website issue

[CloudxEdge]

I have my own private server, non-hamachi and all and I've recently got an account creation page up. (www.frost-wow.servegame.com)

However, when you create an account there you receive a MySQL error, screenshot below.



"Error: Unable to connect to MySQL server. MySQL reported: Access denied for user 'root'@'192.168.1.1' (using password: YES).
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Users\colerussell\Desktop\Elite Blizzlike Repack\Server\htdocs\index.php on line 463"

Believe me when I say asking was my last resort.

[stoneharry]

You either have a invalid password or the IP 192.168.1.1 is not allowed to connect. Set the MySQL 'host' for the account root to % to allow all IP addresses.

[CloudxEdge]

Set the MySQL 'host' for the account root to % to allow all IP addresses.

I went into my server htdocs folder, checked the index file on line 463 as specified on the second line there in the error and this is what's there, minus the quotations.
"$logincheck = mysql_num_rows($uniqueuser);" Anything I need to do there? Other than that, I went into the MySQL db and added permissions and what not, not sure how to do as you suggested though here: "Set the MySQL 'host' for the account root to % to allow all IP addresses."

[CloudxEdge]

Nevermind, fixed it! Went into my DB (via navicat) and managed users, adding all permissions to [email protected]

[DoxramosPS]

Might I suggest switching to Heidisql and leaving navicat behind as well?