Virtual web hosting and mysql_connect

[packland]

Hi there!

I'm very new to all this. I've been holding off but I really need to ask some pretty dumb questions.

I've manage to string together some pages in my local domain and I want to try them on the web

I put the pages on my virtual site but when I try to connect with:

$connection = @mysql_connect("localhost","mysqlUser", "mypass") or die(mysql_error());

I get

Access denied for user: 'mysqlUser@localhost' (Using password: YES)

when I telnet my virtualsite.com and run

/usr/local/mysql/bin/mysql -u mysqlUser -p myVirtualSiteDatabasename

and enter my password I can access this database ok but only with the myVirtualSiteDatabaseName bit at the end.

otherwise i get:

ERROR 1045: Access denied for user: 'mysqlUser@localhost' (Using password: YES)
$

Is it the same issue and how to mysql_connect to myVirtualSite's dedicated database??

hints? - links?
please?

Also I'm running RH linux 8.0 - what is phpMyAdmin going to give me here. i've been thru hell getting this far i don't think i could deal with another configuration problem. Not that i'm unhappy - i'm overjoyed with the whole linux apache php mysql and mozilla .... thing.
- it's has been challenging however and i'd really like to get my site up on the web and learn some php and mysql.

[Kerry_Kobashi]

Perhaps you setup your password to be your database name by mistake?

Just guessing here... if you telnet into it and used that as the password and it worked, why not try below:

$connection = @mysql_connect("localhost","mysqlUser", "myVirtualSiteDatabasename")

How about checking access rights to the directory your database is in?

Kerry Kobashi
Kobashi Computing

[packland]

Thanks but the command and the passwords and usernames are ok

The command line syntax is:

Usage: mysql [OPTIONS] [database]

so the following also works for me using the details supplied.

mysql -u mysqlUser -pPassword mydatabaseName

this doesn't:

mysql -u mysqlUser -pPassword

and I am assuming the mysql_connect issue is related to this??

[packland]

ahhhhhhhh!!!!

typo

ahhhhhhhh!!!

sorry

ahhhhhh