script doesnt work unless access as root

[Anon]

We recently had to change over to another server for our php/mysql project, and on this machine, we can not access the database as root, but have created another user to access the database called 'beta'. before we had:

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

and our scripts work great, now we must use this to access our database:

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

and now everytime the $db variable is referrenced we get an Warning: Supplied argument is not a valid MySQL result resource message. Why should using the database as a different user have effects on script performance? We were granted access to everything on mysql this account?

[knight]

It is most likely when you created the database you forgot to declare permissions on it for the user beta to access it. So try this and it should work:

GRANT ALL PRIVILEGES ON beta TO beta@localhost IDENTIFIED BY "yourpass";

FLUSH PRIVILEGES;

then in $db line do this:

$db = mysql_connect("localhost", "beta", "yourpass") or die(mysql_error());