Modcraft - The community dedicated to quality WoW modding!
Wrath of the Lich King Modding => Miscellaneous => Topic started by: Domminust on February 20, 2015, 09:05:11 pm
-
hi, been struggling with making an account registration page. First I had errors with mysql connection and then I realized I couldn't connect to mysql server except on my host machine and so I needed to specify profiles to which this rule applies in firewall settings. - selected all of them.
Now i can connect to mysql on my rdp from my Mac.
I've tried a few websites now using
http://www.ac-web.org/forums/showthread.php?155157-TrinityCore-Simple-Registration-Site
and I get this error:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user '‘Domminust’'@'31.170.160.86' (using password: YES) in /home/a5582059/public_html/index.php on line 28
wtf thats not even my ip address and its not whats set in the config.php
it started happening after I re-configured the firewall and actually its happening with every registration pack I've tried.
-
Check in your user's privilege (with phpmyadmin) if the host of your user account is on "%".
-
ok I am trying to figure out how to install myphpamin :]
also I found that the i.p 31.170.160.86 is the address of the php 000webhost.com..
-
I suggest to try out azer cms or fusion cms instead of writing config files.
-
'‘Domminust’'@'31.170.160.86'
Domminust = login
@ = separator
31.170.160.86 = IP where account is connecting to MySQL server FROM
Check in your registration web function config and in MySQL account manager:
Login (does it exist?)
Password (is it set correctly?)
IP
If your password is correct I would advice you to take a look especially at IP. When you create MySQL account, you can set if your account will be free to use from any connecting IP (you enter % as value) or if it will be bound to one IP, meaning that your account won't be accesible from any other IP address (you enter IP address).
-
Hey thanks for the tips, I got fusion cms up. Good stuff.
-
nevermind