[SOLVED] db connection problem

[jsucupira]

I keep getting the error cannot connect. i was wondering if someone could tell me how to do it right.

on the port part.  I've tried putting the port and doing without it.  I appreciate any help

 

this is the address to my connection:

Server=pmysql53..net.; Port=3306; Database=members; Uid=login; Pwd='my password';

 

my php code is :

<?php
$host="pmysql53..net.:3306"; // Host name
$username="login"; // Mysql username
$password="my password"; // Mysql password
$db_name="login"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from signup form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

[revraz]

What is your actual MySql server name?

 

pmysql53..net.:3306

 

You have two periods before net and one after.  Also, drop the port.

[jsucupira]

the server is p50mysql53.secureserver.net:3306.  I have tried with the port and without it.

[darkfreaks]

drop the port variable and put it in the connect like so:

<?php

mysql_connect("p50mysql53.secureserver.net:3306", 
$username, $password)or die("cannot connect");?>

[jsucupira]

this is what I have now, but still doesn't work. it says cannot connect

 

this is what I have now

<?php
$username="wow"; // Mysql username
$password=""; // Mysql password
$db_name="wows"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("p50mysql53.secureserver.net:3306", 
$username, $password)or die("cannot connect");

// username and password sent from signup form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?></body>

[darkfreaks]

try adding

<?php
or  die('Could not connect: ' . mysql_error());?>

[jsucupira]

it said "Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[darkfreaks]

might want to upgrade your MYSQL version its prolly outdated

[jsucupira]

its 5.0 and its on godaddy. weird uhm?

[darkfreaks]

weird ???

[jsucupira]

thanks anyways

[darkfreaks]

you need ot upgrade your PHP to 5.0 or it wont work just found this