[PHP] mysql_connect

[tattekudasai]

What are the parameters for mysql_connect?

mysql_connect($host,$user,$pass);

I've tried mysql_connect("localhost",$dbname,$dbpass) but authentication fails :(

[UnlimitedMB]

The server is mysql not localhost.

[ckpd]

I use "localhost" and it works fine for me. Well at least i think it does.

[Tyler]

I use "localhost" and it works fine for me. Well at least i think it does.
It wont work if you use localhost on our servers. It is not possible, there is no mysql server on "localhost".

[ckpd]

Okey doke i just found that out however, ive tried mysql and it still wouldnt work.

Example of my code:

$host = 'mysql'; $user = 'me'; $pass = 'me'; $db = 'mydb';
mysql_connect($host,$user,$pass)or die('Cannot connect');
mysql_select_db($db);

This returns the error "Cannot connect".

When i forced a MySQL ERROR eg:

mysql_connect(infoHere)or die(mysql_error());

i got:

Access denied for user 'mydb'@'localhost' (using password: YES)

[UnlimitedMB]

If you are getting an error that says localhost then you are not using the correct server.
The mysql server is "mysql" not "localhost"

[ckpd]

If you are getting an error that says localhost then you are not using the correct server.
The mysql server is "mysql" not "localhost"

I have tried both and neither have worked and even thought the error says:

@ 'localhost'

I havnt put localhost as the $host variable

[UnlimitedMB]

You must have, there is no way the error could say localhost if you put mysql.

[Victor01469]

Be sure you are not confusing host with database type.

Both should be defined as "mysql" without the quotes.