Hi,

JUst installed LAMP on openSUSE. They all seem to be working well individuallu.
However, after i created a database, i created a PHP file to connect to it using


i get the error:



I have no idea who - wwwrun is. I created the database under the default root user. I created another user and gave all access priviledges, and i still get the same error - so ive ruled out username/password problem.

Anyone know what the problem might be please?

Those are just vars (and it looks like the one for host is missing); what are you actually passing to mysql_connect, or whatever db package you're using?

See this page from the php manual: http://us.php.net/mysql_connect

FWIW, though, sounds like wwwrun may be the user that php is running under via your http server.

Passing this?




But why/ how is it using that user? I didn't create it. How can i change it?

In the example text in your first post, you are missing the double-quote mark at the end of your username. If your PHP script is the same way, this would likely cause it to fail.

Looks like in SUSE that Apache runs as the wwwrun user, which presumably is the username that PHP tries to use for the MySQL connection if a username isn't provided.

Try putting the following before the line with mysql_connect():

error_log( "Connecting to MySQL with username: " . var_dump($username) . " , password: " . var_dump($password) . " , database: " . var_dump($database) );

and check your error log to see what you get for the variables.