Cannot call the mysql database in php

Anon

Dears,

The following php statement still cannot connect to the specific database mydb,

                          line 4: $db=mysql_connect("local","root"); 
                          line 5: mysql_select_db("mydb",$db);

the error message prompts out

Warning: Supplied argument is not valid mysql result resource in
/home/simon/public_html/first.php on line 5.

Before that,I have tested the existence of the database, mydb, in the computer under linux terminal by using the following commands.

shell > mysql
mysql> use mydb;
mysql> select * from employees

the data are then displayed out.

Please give me some solutions on the configuration setting, thanks.

Sincerely yours,
Simon

Anon

You're sure local works? Usually it's localhost. Is $db valid (non-zero)?

Anon

Dears,

We run the php webpage in the same computer under Redhat 7.0 OS, How to check the local work and validation of $db

Thanks
Simon

Anon

use localhost and take root out like this

$db=mysql_connect("localhost","","");

hopefully this will qork

Anon

Dears,

It's not OK
Please give another solution, thanks

Simon

Anon

Dears,

The warning message is given as follows:

Warning: Supplied argument is not valid mysql-link resource in /home/simon/public_html/first on line 4

Please give me helping hand, thanks

Simon

skips

It is $db that is the problem, it is either reserved or gets munged or something. Change the variable name!

That is as long as 'local' is valid for a host. Mine only likes 'localhost'.

Anyhow, it is the $db that creates that specific error, a bad hostname pops a different error.

Anon

Dears,

It's not OK if the variable is changed to $db1.

Simon

Anon

Hello

Don\'t try mysql with no parameters.

Try:
mysql -u root -h local [-p]

Go on trying with the parameters you supply in your php code.

Does the user under you run your web server (or php) have the privileges to access to mysql.sock?

Have you checked the existance of /tmp/mysql.sock ? Have you tried to restart mysql?

If it\'s all ok, then by sure it\'s a problem of privileges.

Note: I hope your root user don\'t get a null password.

Good luck !!

skips

Sorry, My Bad!

It was my close staement in the next line that was trying to close a connection which was never opened, which was springing the error.

I don't know what the problem is.

Good luck!