Log in

View Full Version : MySQL Help (DJ Panel)



index.html
01-10-2006, 07:54 PM
For the second step, we will set up the MySQL tables. If you have not configured "staff/dj/sql.php", please do so now.
Warning: mysql_connect(): Unknown MySQL server host 'CHANGEME' (1) in /home/kinghab/public_html/staff/dj/sql.php on line 14
Couldn't select database.

I get that message , Help please? :) +rep for correct aswer
__________________

Remix
01-10-2006, 07:58 PM
ITS BECAUSE YOU HAVNT ENTERED THE RIGHT DETAILS FOR THE MYSQL.

ALSO, CHANGE URL OR WHATEVER TO LOCALHOST OTHERWISE IT WON'T WORK.

reindeer.
01-10-2006, 08:03 PM
server host 'CHANGEME'

change that to localhost in staff/dj/sql.php

Remix
01-10-2006, 08:07 PM
server host 'CHANGEME'

change that to localhost in staff/dj/sql.php

Thanks, I could'nt be bothered to look it up and get fed up of people asking these kind of questions :@

index.html
01-10-2006, 08:21 PM
Soz, im not exactly the best, Explain more? :)

nets
01-10-2006, 08:23 PM
You need to edit the PHP file to have the correct MySQL host address (if it's local, 127.0.0.1).


Unknown MySQL server host 'CHANGEME'
Lol..

Liam.1
01-10-2006, 08:24 PM
Change 'CHANGEME' to 'localhost'
and why do you close your threads when i mention that you try to sell my layout on here..

index.html
01-10-2006, 08:25 PM
Where do i change CHANGEME to LocalHost

and Liam, I Didnt think that was your layout? I Wasn't thinking.

Remix
01-10-2006, 08:26 PM
Where do i change CHANGEME to LocalHost

and Liam, I Didnt think that was your layout? I Wasn't thinking.

WHERE IT SAYS CHANGEME FFS.

nets
01-10-2006, 08:28 PM
Open the PHP file and just change it? :s


Where do i change CHANGEME
Give up. Now.

index.html
01-10-2006, 08:28 PM
But where the hell does it say Changeme? :l Plus rep if you help.

Remix
01-10-2006, 08:30 PM
Unknown MySQL server host 'CHANGEME' (1) in

Liam.1
01-10-2006, 08:31 PM
bloody hell someone needs glasses

index.html
01-10-2006, 08:33 PM
Im getting glasses on Friday actually ;] But is this in the MySQL Bit?

Liam.1
01-10-2006, 08:35 PM
just give up on your site thx

staff/dj/sql.php
Go to THAT FILE

Go to LINE 14

EDIT WHERE IT SAYS 'CHANGEME' and put 'localhost'

Remix
01-10-2006, 08:36 PM
NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOO

IN THE PHP CODE FGS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!

index.html
01-10-2006, 08:37 PM
<?php
//MySQL Hostname
$hostname = 'localhost';
//MySQL Database Username
$sqlname = 'kinghab_djpanel';
//MySQL Database Password
$sqlpass = 'kinghab_djpanel';
//MySQL Database Name
$mysqldb = 'kinghab_djpanel';
$connection = mysql_connect($hostname, $sqlname, $sqlpass) or die("Couldn't select database.");
$db = mysql_select_db($mysqldb, $connection) or die("Couldn't select database.");
?>

Alll i see :)

Remix
01-10-2006, 08:38 PM
Have you actually created a MySQL database?

index.html
01-10-2006, 08:40 PM
yes :S

Does anyone voulenteer to do it?

index.html
01-10-2006, 08:57 PM
Warning: mysql_connect(): Access denied for user 'LOCALHOST'@'localhost' (using password: YES) in /home/kinghab/public_html/staff/dj/sql.php on line 14
Couldn't select database.

Just doesnt seem to be wokring ive changed it to localhost aswell,

Liam.1
01-10-2006, 09:02 PM
your details for your database must not match the ones in the file.

index.html
01-10-2006, 09:36 PM
All done now thanks :)

Want to hide these adverts? Register an account for free!