Please help me on mysql_connect

[sirSam]

hello guys, im a newbie in php.
i have a line of code like the following
mysql_connect("localhost",...
i uploaded my page using my account under elementfx server.
my problem is this:
Unknown MySQL server host 'Starka.x10 '
i think i should change the "localhost" to an IP address, or should really I?
I hope you can help me on here..
thanks in advance.. more power x10hosting

 

[Silmaril]

Hi sam.

localhost is correct. Habe you made the database you are trying to access with your script? you should do this first in cpanel

 

[sirSam]

hello Silmaril, thanks so much for your reply.

i already made the database using the phpMyAdmin tool from cPanel.
did i create it the wrong way? should I have used the wizard?

thanks again..

 

[leafypiggy]

did you assign the user to the database the correct permissions?

 

[sirSam]

i am getting a new error here:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sirSam'@'localhost' (using password: YES) in...
Access denied for user 'sirSam'@'localhost' (using password: YES)
Edit:
hi leafypiggy...
i think i have not done that yet..
can you guide me pls?

 

[Silmaril]

i messed my post up!

okay, mine is like this

localhost
dbname = silmaril_nuke
user = silmaril_silmaril
pass = mypass

notice the silmaril_ part......... that is cpanellogin_dblogin which makes up your complete login.

As for the permissions bit, the permissions were set up when i set up the user on mine, but i didnt use myphpadmin i used the first icon in there called MySQL Databases

 

[sirSam]

i have already created the user for the database and set all the privileges

 

[xxll_martin_llxx]

Firstly, if you're looking to use databases then it's likely you'll be need PHP too - you've only got the Basic PHP level which usually creates more errors and stops sites functioning properly. You will need to login at http://x10hosting.com/account and request the INTERMEDIATE level of php.

Secondly, please refer to my post http://forums.x10hosting.com/free-hosting/95099-mysql-hostname.html#post522016 to sort your current problem out.

 

[sirSam]

thanks anyway Silmaril. i was so hopeless when i was waiting so your reply is already a help

 

[Silmaril]

LoL thats nice of you but really, i was of no help at all but look!!! the pro's are here

 

[sirSam]

i've read your post martin, i already did those.
may i just ask, if my database is db1 and username is hello, in the function mysql_connect, should the database name parameter be "hello_db1"? or just "db1"?
Edit:
haha yeah. they're here, and... they look really so pro
i know the solution is now much more nearer

 

[Silmaril]

i've read your post martin, i already did those.
may i just ask, if my database is db1 and username is hello, in the function mysql_connect, should the database name parameter be "hello_db1"? or just "db1"?
Edit:
haha yeah. they're here, and... they look really so pro
i know the solution is now much more nearer

It should be hello_db1 :happysad:

Note: This assumes that hello is your cpanel login and NOT your database login

should be;

database name "cpanellogin_dbname"
database user "cpanellogin_dblogin"

make sense?

 

[xxll_martin_llxx]

i've read your post martin, i already did those.
may i just ask, if my database is db1 and username is hello, in the function mysql_connect, should the database name parameter be "hello_db1"? or just "db1"?
Edit:
haha yeah. they're here, and... they look really so pro
i know the solution is now much more nearer

Your database name then will be "sirsam_db1"

Your database USER will be "sirsam_hello"

Then the password will be the one you chose.

 

[sirSam]

i still get this error
Access denied for user 'sirsam_sirSam'@'localhost' (using password: YES)

here is my code:
mysql_connect("LocalHost", $dbUsername, $dbPassword) or die(mysql_error());

 

[xxll_martin_llxx]

sirSam is your database user, yes? Which you made in the database area.

I'm not much of a whiz on coding.

Try mysql_connect('localhost', $dbUsername, $dbPassword) or die(mysql_error());


EDIT**:

Can you copy and paste ALL of the code you have in your index.php file.

Use [code*] PASTE YOUR CODE [/code*] (Don't use the *'s though.

 

[sirSam]

<?php
$dbUserName = "sirsam_sirSam";
$dbPassword = "password removed!!";
$dbName = "sirsam_dbSirSam";
mysql_connect("LocalHost", $dbUsername, $dbPassword);// or die("Could not connect: " .mysql_error());
//mysql_select_db($dbName)or die(mysql_error());
echo "db connected, rs connected";
?>

 

[xxll_martin_llxx]

<?php
$dbUserName = "sirsam_sirSam";
$dbPassword = "password removed!!";  [COLOR="Red"] *ADD YOUR PASSWORD BACK IN*[/COLOR]
$dbName = "sirsam_dbSirSam";
mysql_connect('localhost', $dbUsername, $dbPassword);// or die("Could not connect: " .mysql_error());
//mysql_select_db($dbName)or die(mysql_error());
echo "db connected, rs connected";
?>

 

[sirSam]

sorry?

 

[Silmaril]

ignore me..

 

[xxll_martin_llxx]

Try that code I posted but you'll need to put your password back into it?

If that doesn't work then either the database name/user area is being mixed up or the code is wrong somewhere and I have little knowledge of coding therefore can't help much more but I will look into it further - I will be gone now for around two hours so won't be able to reply.