Can u help me connect to my database?

[luke noob]

Hi i have just begun hosting my web site with a company Complia.com it has its own built in MySQL & phpmyAdmin, to create a database, im having a problem connecting to it.

This is the warning i get....

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'www.example.co.uk:2082' (1)
 

This is my code in php.....

$db_name = "myphotos";                           
$db_server = "www.example.co.uk:2082";     
$db_user = "luke";                                     
$db_pass = "somenumbers";                      
 
$mysqli = new MySQLi($db_server, $db_user, $db_pass, $db_name) or die(mysqli_error());
 

The thing that i am confused with aswell is that when i set up the username and the database name.... once i clicked save it added some things for example....

my database name went from myphotos to _myphotos (in the actual bit where you select what database you would like to view in phpmyadmin)

and in another part it says database names: john2479_myphotos in mysql manage databases

my username i typed in luke and got john2479_luke displayed on screen

so i dont know what i should write,

i have allowed full access to username luke, please help.

[mwasif]

I believe you are using cPanel as your hosting panel. cPanel append its username before every mysql user and mysql database to make it unique with other databases and uses on that server.

So you need to use john2479_myphotos and john2479_luke as database name and mysql user respectively. Use localhost instead of www.example.co.uk:2082 for $db_server.

[luke noob]

Thank you so much for your help mwasif, its all done at last thankyou.

[mwasif]

You are welcome.