Error: Unable to connect to MySQL server: : '' :

[pac457]

I get this error when I try to access the mysql database. I installed mysql and php both from source on a redhat 7 machine. I have tested both mysql and php, they seem to work fine after testing them. When I list processes they are both running... If mysql_safe is running, does that mean I am in safe mode? Do I need to specify a user in the php.ini? When I install mysql and php from source does the user "nobody" that php uses get created or do I have to create it using mysqladmin?

I almost have this web running... can antone give me advice?

Thanks

[Skunk]

Have you set up an account on your mySQL database with a username and password yet?

[pac457]

The only account I've setup is the root user account

[pac457]

also there is the mysqlusr account that the mysql deamon user to start mysql. Do I need to setup another user account so people can access the database via php pages?

[petesmc]

IN your php script add:

print mysql_error();

That will tell you what the problem is so you can easily correct it. Also, make sure that you have mysql started.

[pac457]

Thanks guys... I figured it out, all I needed to do was specify a user in my php script to connect to mysql... cool.
I wish I could post a link to the site, but it's an internal only website. I am working on a customer information web for HP. I'll be building my own database project after this one.