MySQL question

shmony

I have been having lots of problems with trying to connect to the MySql server through a PHP page, and I was just wondering if I have to upload MySQL to my host server? how do I get it to work?? I cant get this to work. Please help me.

shmony

here's the script I use to connect to MySQL that doesnt work:

<?php
$mysql_database="database";
$mysql_username="username";
$mysql_password="password";
$link = @mysql_connect("thehost.net",$mysql_username,$mysql_password) or die ("Unable to connect to SQL server");
mysql_select_db($mysql_database,$link) or die ("Unable to select database");
?>

Can you check that over to see if it's the right script? And also, do I put in the username and password for the host of my website for the username and password?

Anon

You are really, really, really out of your depth here. If mysql is running on your hosts server, then you should be connecting to localhost, not thehost.net. And you should know the password of who you're connecting to.

Chris

shmony

First of all, I'm only 13. And it's not that easy to learn all this stuff at 13. Second, thehost.net was just an example I put, and I do know the password of my host. You totally didnt understand a thing of what I asked!

Anon

No one is out of their depth with mysql ; )

<?php
$mysql_database="database"; // YOUR DATABASE NAME
$mysql_username="username"; // YOUR USERNAME!
$mysql_password="password"; // YOUR PASSWORD
$link = mysql_connect("localhost",$mysql_username,$mysql_password) or die ("Unable to connect to SQL server");
mysql_select_db($mysql_database,$link) or die ("Unable to select database");
?>

Anon

Au contrair - you're the one who doesn't understand what you asked? Upload MySQL - what the heck?

Chris