problem with MySQL connection in free webserver

[wireshark]

does anybody have try [LINK REMOVED]?
i cant connect with mysql in that server. event i was ask the support. dont give me a good solution. i was have twice answer with same answer,and i have do anything that give me.still cant connect. anybody know? what webserver that's free n really good to try? i was a newbie in PHP. thanx for all

[ronverdonk]

Welcome to The Scripts!

What do you expect from our members when you don't suppply any information except 'it doesn't work'?

How did you setup MySQL, can ytou use phpAdmin to connect, (in case) what is the userid/password that the provider gave you, etc. etc. Please specify anything you did with samples and responses. Only then we can try to help.

Ronald

[wireshark]

so...the admin give me cpanel account a2840013 and the name of database i make is "Database".i have make a user account to that database. with name "a2840013_guest" with no password to for that user.

<?
$host="64.191.112.53";
$user="a2840013_guest";
$password="";
$con= mysql_connect($host,$user,$password) or die ("Cannot Connect
1");
mysql_select_db("a2840013_Database",$con) or die ("Cannot Connect
2");
?>
and the result is i cant used that database,i was denied.
please help me.... thank you...

[wireshark]

another information...
i setup mysql from cpanel. and cpanel id= a2840013 with password ="richman196681". is there anything more u need to know to help me? please confirm me... thank you...

[nomad]

another information...
i setup mysql from cpanel. and cpanel id= a2840013 with password ="richman196681". is there anything more u need to know to help me? please confirm me... thank you...

what permissions did you give to a2840013_guest.

nomad

[wireshark]

what permissions did you give to a2840013_guest.

nomad

thanks for your reply
i give select,delete,update,insert,index,and create a temporary tables permisions...
maybe i suggest u try the webserver...its free... i really confuse to use it...
thank again...

[ak1dnar]

I tried the same Service provider. and the mySQl server is working fine there. why don't you try "localhost" instead of the IP "64.191.112.53". and make sure to grant the permissions to the created user first.

[wireshark]

I tried the same Service provider. and the mySQl server is working fine there. why don't you try "localhost" instead of the IP "64.191.112.53". and make sure to grant the permissions to the created user first.

i have make a grant the permissions. and change it to "localhost" but still having this problem. this the result at now.
Access denied for user 'a2840013_guest'@'localhost' (using password: NO) in /home/a2840013/public_html/a28400113/test.php on line 5

this my script...please tell me if i have something wrong with my script.
<?
$host="localhost";
$user="a2840013_guest";
$password="";
$cipai= mysql_connect($host,$user,$password) or die ("Cannot Connect 1");
mysql_select_db("a2840013_Database",$cipai) or die ("Cannot Connect 2");
?>

thank for all your reply and try helping me...

[wireshark]

thanks for all your reply...
i have solve this thing...hehehe....
please help me again next time if i confuse Again... thanks for all...

[Markus]

thanks for all your reply...
i have solve this thing...hehehe....
please help me again next time if i confuse Again... thanks for all...

What was the problem?

[ak1dnar]

Sure he has added the PASSWORD instead of the blank password this time.
anyway hope to see you again. ;)

[wireshark]

Sure he has added the PASSWORD instead of the blank password this time.
anyway hope to see you again. ;)

hehehe... that was true... cause i want to try add new user with blank password. and it not work. so i realize...that user,must have a password. so i try it...and get a good result....:)
thank for all who help me.... :)
really great have a new experience... usual i use a Visual Basic.... and new in PHP. thank again....