[RESOLVED] More efficient way to change user connection

[Nightwalker83]

Hi,

What is a more efficient way to change user access to a database? At the moment I use:

//connect to server or exit
$conn = @mysql_connect("localhost", "root", "");
if (!$conn) {
die("Connection failed: " .mysql_error());
} 

and just replace "root" with whatever the new user account is called. However, this means I have a lot of connections to my databases. What would be the best way to achieve this?