PHP MySQL authentication error

Question

I have created an html form (demo.html) & POST it's value to a php file (demo1.php). Then i created database in MySQL & wrote connection code in the php file (demo1.php) but it gives the following error

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\demo1.php on line 8 Error connecting to mysql

<?php
// contact to database
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
//$conn = mysql_connect("localhost","root","password") or die ('Error connecting to mysql');

$dbname = 'test';
mysql_select_db($dbname,$conn);

//$connect = mysql_connect("localhost", "root", "pass") or die ("Error , check your server connection.");

//mysql_select_db("test");



//Get data in local variable

$v_name=$_POST['name'];

$v_email=$_POST['email'];

$v_msg=$_POST['msg'];



// check for null values

if ($v_name==""  or $v_msg=="")

echo "All fields must be entered, hit back button and re-enter information";

else{

$query="insert into contact(name,email,msg) values('$v_name','$v_email','$v_msg')";

mysql_query($query)  or die(mysql_error());

echo "Your message has been received";

mysql_close($conn);

}

?>

Is the MySQL server running? Are you sure the username and password are correct? — TuteC
– TuteC, Commented Feb 24, 2011 at 5:51

delphist · Accepted Answer · 2011-02-24 05:53:52Z

2

Password for user root is incorrect.

Default password on local (home) server is empty, so I think this can help:

$dbpass = '';

answered Feb 24, 2011 at 5:53

delphist

4,5591 gold badge24 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

prodigitalson · Accepted Answer · 2011-02-24 05:58:48Z

1

The error is pretty explicit - the username/password combination youre using is incorrect. IF thisis a fresh install you need to set a password and/or create a new user.

answered Feb 24, 2011 at 5:58

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

Comments

Karthik · Accepted Answer · 2011-02-24 06:00:44Z

0

For Local Xampp username-root password --''

<?php
// contact to database
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
?>

answered Feb 24, 2011 at 6:00

Karthik

1,4983 gold badges17 silver badges29 bronze badges

Comments

Gatonye · Accepted Answer · 2011-02-24 06:05:22Z

0

The main reason for this is that the password is wrong. Did you specify the root password when setting up xampp? If not, then leave the password blank as delphist states above

answered Feb 24, 2011 at 6:05

Gatonye

815 bronze badges

Collectives™ on Stack Overflow

PHP MySQL authentication error

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related