help setting password for db created with PHPmyadmin

[boblan66]

I testing  my work using WAMP and phpMyAdmin. i have a question concerning on how tp establish a password. The code to open the db is shown below.

 

<?
error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);

$host = "localhost";
$dbName="membership;"
$user = "root";
$passWord="";

$cxn = mysqli_connect($host, $user, $passWord, $dbName );
	or die ("Could not make a connection. Please try again later..");

 

Ihope someone can help.

 

 

[ManiacDan]

Create a new user account using the Create User syntax and then use that user instead of "root" for your website.  "Root" should never be used as the web user, you should always use a more limited account so that if your site is ever compromised, the attacker cannot delete your entire database.

 

-Dan

[ttocskcaj]

lol I always use root

[ManiacDan]

Don't do that, and don't advertise that fact on a public forum. 

[ttocskcaj]

Only on my testing server.