[vecchiounno]

i have a premium account and the helpdesk isnt able to solve my problem

the final goal is to connect to remote mysql from my client (in VB.NET) into my pc, but first i want test with a STANDARD php script....


my ip on hosting24.com is 174.36.100.112

<?PHP
$db_server = mysql_connect('174.36.100.112','my db user','my db password');
if ($db_server){
	print "SERVER ok";
	$db_selez = mysql_select_db('my db name', $db_server);
	if ($db_selez){
		print "DB ok";
		$utente = mysql_query("SELECT * FROM users WHERE username = 'admin'", $db_server);
		if ($utente){
			while ($rec = mysql_fetch_array($utente)){
				$nome = $rec[3];
			}
			print $nome;
		}else{
			print "NO TABLE";
		}
	}else{
		die("Couldn't select database: ".mysql_error());
	}
}else{
	die ("Couldn't connect to server.");
}
?>

the connection to server it's OK
but the connection to my db NO...

HELP PLS!

[sizzlefire]

Did you add your IP in cPanel?

[Bad Karma[CORE]]

are you sure about the IP address?
And has remote mysql access been enabled in your cPanel?

[vecchiounno]

in remote access i have add % for all hosts

this IP 174.36.100.112 is reported in cpanel as "Dedicated Ip Address"

[sizzlefire]

Originally Posted by vecchiounno

in remote access i have add % for all hosts

this IP 174.36.100.112 is reported in cpanel as "Dedicated Ip Address"

No, you just have to add your computers IP address, http://findmyip.com

[vecchiounno]

but i want that all my customers can connect from remote
(i dont change or add anytime a new ip...)

p.s.
i'm a router at lan home

[vecchiounno]

this the result of php script

SERVER ok
Couldn't select database: Access denied for user 'scgmlegi_scgm'@'87.8.70.173' to database 'scgmlegi_scgm'

[vecchiounno]

ok
I have solved with php
I had not added the privilege to the user (sorry), but only create the user...

Now i try in VB.NET...

[chanh]

I don't understand why you would want to open up your site for remote attack to your database.

[sizzlefire]

Originally Posted by chanh

I don't understand why you would want to open up your site for remote attack to your database.

He just wanted to open it up so him and all his customers could access it, it many not be the best idea, but as long as you don't have many enemies you should be fine xD