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-ho...tml#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 ;)