[lylesback2]

Code:

  $server = "localhost";   // often localhost
$username = "krystalklear";    // Your MySQL server username
$password = "password";   // Your MySQL server password
$database = "";    // If you fill in nothing database 'members' will be used. If 'members' doesn't exist it will be created.
$DBprefix = "ALS";   // the prefix for the tables in the database (can be left blank)

password isn't really password, but for say

i get this error when viewing this page
http://www.krystalklear.info/login/login.php

Code:

Error while creating database (Errornumber 2002: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")

anyone tell me the problem im having :S i cant figure this out

[Stefan]

check with your host if localhost is indeed the database host. there are hosting providers that use seperate database servers, and there are certain control panels (for instance ensim) that require you to use 127.0.0.1 instead of localhost.

[lylesback2]

Originally Posted by Stefan

check with your host if localhost is indeed the database host. there are hosting providers that use seperate database servers, and there are certain control panels (for instance ensim) that require you to use 127.0.0.1 instead of localhost.

ok thank you, i checked the database section and it gave me
Host name: mysql5.secureserver.net
User namer: krystalklear

[lylesback2]

i found this page:
https://www.godaddy.com/gdshop/faq/f...=Web%20Hosting

Code:

 QUESTION:
What name servers do I use if I have a GoDaddy.com hosting account?
 
ANSWER:
GoDaddy.com's name servers are: WSC1.JOMAX.NET and WSC2.JOMAX.NET

this still doesn't work :S

[NeverMind]

these are used for DSN thingy !!
don't worry about them, they have nothing to do with MySQL !!
just change the server value into Mysql5.secureserver.net

PHP Code:

$server = "Mysql5.secureserver.net";   // often localhost

$username = "krystalklear";    // Your MySQL server username

$password = "password";   // Your MySQL server password

$database = "";    // If you fill in nothing database 'members' will be used. If 'members' doesn't exist it will be created.

$DBprefix = "ALS";   // the prefix for the tables in the database (can be left blank) 

I think you will also need a port for this remote connection !
your host can help you more about it ..

[lylesback2]

Originally Posted by NeverMind

these are used for DSN thingy !!
don't worry about them, they have nothing to do with MySQL !!
just change the server value into Mysql5.secureserver.net

PHP Code:

$server = "Mysql5.secureserver.net"; // often localhost
$username = "krystalklear"; // Your MySQL server username
$password = "password"; // Your MySQL server password
$database = ""; // If you fill in nothing database 'members' will be used. If 'members' doesn't exist it will be created.
$DBprefix = "ALS"; // the prefix for the tables in the database (can be left blank) 

I think you will also need a port for this remote connection !
your host can help you more about it ..

thank you, i e-mailed my host twice, but long weekend... so they won't be open this weekend

yes.. i changed it to what is above, and still getting the same error.
i guess i do need a port

this is what my MySQL looks like
http://www.krystalklear.info/login/database.GIF