$username="username";
$password="password";
$database="your_database";
mysql_connect(70.85.132.34,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
In the Help Centre, under SQL database, it says "MySQL Host: your server name (this is the server listed in the Manage SQL Databases section of your web hosting control panel)" Well, quite simply, it is not listed there. There is no server listed there at all!
I did my best to fill in the values, and got..
Parse error: parse error in /home/www/mydomain.com/php/database/database.php on line 7
Line 7 is:
mysql_connect(70.85.132.34,$username,$password);
I'm not sure what host to write. In phpmyadmin, right at the top, it says,
Server: mybesthost.com
I thought maybe that was it but it seems not
Then i look in Server Information in the normal CP. It says:
MySQL host/server : 70.85.132.34
Maybe i am supposed to write in that IP? That didn't work either.
Then again maybe i have my username wrong. Can i get this confirmed.
$username="username";
$password="password";
$database="your_database";
Should i write the same for username and for database? And should i write for this the name of the database? I tried that and it didn't work
Why is this whole thing so non n00b friendly?
This is entire thing was made worse, by the fact that, from the normal CP, there are now no databases listed in SQL databases, despite the fact that i created one last night. *Sighs.
If i try to enter phpmyadmin from the CP, i just get a white screen. Maybe somehow i deleted my database? However, i looked through my broswer history and was able to find the link to login to phpmyadmin. When I logged in, the database i created yesterday was still shown. Does anyone know why there has been just a white screen when i click on phpmyadmin in the CP??
Help?
Thank you
Shears