[SOLVED] Mysql Connection

[Dark]

hello guys, how give access other ip-s connect on my mysql? i have site and in need make registration
site is hosted

 

[Tommy]

hello guys, how give access other ip-s connect on my mysql? i have site and in need make registration
site is hosted

Can you paste us the PHP code? Would help to see if everything is correct via code.

http://emudevs.com/faq.php?faq=forumfaq#faq_givemoreinfofaq

 

[Dark]

config.php ? sorry for this post in this thread

<?php
// Database settings
define('DB_HOST', '46.49.76.72');
define('DB_USER', 'wowdbuser');
define('DB_PASS', 'wowdbpassword');
define('DB_NAME', 'auth');

// Soap settings
define('SOAP_IP', '46.49.76.72');
define('SOAP_PORT', '7878');
define('SOAP_USER', 'admins');
define('SOAP_PASS', '123456');

// Misc settings
define('CHECK_FOR_DUPLICATE_EMAIL', true);
define('SITE_TITLE', "Account Registration Page");
define('REALMLIST', "46.49.76.72");

 

[Hyperion]

Whatever username you're using for the mysql to connect from the web to your mysql server, needs to be added with it's remote host, or % for wildcard.

Example: 'webuser'@'website.host.ip' not web@localhost

 

[Dark]

registration need be on my CP
and wowdbuser i set %

 

[Hyperion]

registration need be on my CP
and wowdbuser i set %

If your webuser is set to % as a remote user, then it should be connecting.

Is the mysql port on 46.49.76.72 open to public?

 

[Dark]

that is my external ip and people can connect on this but i need make it on my website :/

 

[Anthonys-Toolbox]

Is your website ran on your own computer or from somewhere else? If it's on your own computer, also make the account's remote user IP to 127.0.0.1 , just having % isn't enough as that doesn't define localhost.

 

[Hyperion]

that is my external ip and people can connect on this but i need make it on my website :/

Not really what I asked

Is the MySQL port forwarded?

 

[Hyperion]

Is your website ran on your own computer or from somewhere else? If it's on your own computer, also make the account's remote user IP to 127.0.0.1 , just having % isn't enough as that doesn't define localhost.

I doubt he would be having a problem in general if it were on the same host. I assumed it was
the remote user too, but it would have given him a login error, not a server connection error.