db connection

Anon

hi,
i have got a question about db connection between mysql db server and php.
the following is my line of code:

$conn = @mysql_connect("http://hostaddress", "username", "password") or die("can't connect");

it either executed this page continuously or came up with can't connect message.
what's wrong with the above code? is it correct?
pls if anyone can reply me asap!
thank you very much for your help!! 🙂

regards,
swan

sepodati

Try taking out the http:// and see if it works...

---John Holmes...

Anon

I'm not sure but I think that trying to connect to the database over HTTP isn't going to work. The HTTP protocol specifically looks at port 80 on a machine, and the only thing running on port 80 should be the Web server. The database that you are connecting to should be listening on another port (can't recall which one off the top of my head), so I bet it will work if you just put in the hostname, with no http://

Anon

thanks for your advice.
i have taken out the http:// before i put the message on the forum. i have managed to get the connection with mysql db server now.
however, i have got the problem with the db connection.
the following is my code:

$connection = mysql_connect("hostname","","") or die("sorry, can't connect server! please try again later.");
$db = mysql_selectdb("test") or die("can't connect db! please try again later.");
$sql = "SELECT * FROM tablename";
$result = mysql_query($sql,$connection) or die("couldn't execute query, db problem??");

i have been getting the message that i set up in the code : "can't connect db! please try again later."

it has been working in the morning, and suddenly, it lost the connection with the db.
until now i can't get any connection back with the db. (note that i don't have support from the hosting company).

please give me some advice asap!! thank you very much for your help!!
🙂)

swan

Anon

Can you login to the server that has the mysql database? If so run "mysql" from the command line. Maybe the service has crashed on the server.

Other than that you are trying to access the mysql server above without any username/password (I'm hoping that you just deleted that information for privacy).

Anon

thanks rob.
i did put the username and password in, and i got this message:
Warning: MySQL Connection Failed: Access denied for user: 'admin@hostname.net' (Using password: YES)

Suppose 'admin' is the username and i have provided the password. i use this username and password to login the db server, with no problem. i have created the tables and uploaded the data.
note that the code was working yesterday without using username and password for a while, then till now, it doesn't work.
please if you have any idea of what the problem is, please advice me asap.
thanks.
swan

Anon

Ok it sounds like you have an admin user who has his hostname field set to localhost or null, which would prevent the admin user from connecting to the database from outside the box the database resides on.

To fix this you need a new admin user who has his hostname field set to the hostname of the system that the database resides on.

The command for this is basically:

GRANT insert, update, select, delete ON table TO admin@hostname IDENTIFIED BY password

Check the MySQL manual to get the correct syntax. You will have to have permission to run the GRANT command, if you don't then you need to get someone to create the account for you.

Anon

hi rob,
thanks for your advice.
i tried to grant a username and password to access mysql db and insert details into both mysql.host and mysql.db. i did manage to get the connection up for a while, but it's a very unstable connection. esp. when i update the php pages, it takes a while to get the connection back. and also, i have to keep on pressing refresh to check when the connection is up again.
it looks like something is caching the page or it needs manually refresh. is it something to do with the hosting company or the development tool/page editor (dreamweaver2) that i am using??
if you have any idea, pls do advice me..
thanks,
swan phung

Anon

I've never worked with Dreamweaver, so I don't know if it tries to do caching or not, but you can put the "No Cache" header (I don't remember it off the top of my head, just search for it and you'll find it) in your scripts to try and keep the browser from caching your pages. As for something that the server is doing I'm not sure. Many hosting companies do try to cache/proxy there pages to speed up the performance, but I don't know what can be done about it.