php sql connection

[akulkarni]

Hello.

I am using Easy php

i am trying to connect with the following code

<?php
$con = mysql_connect("localhost","admin","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code
?>

getting error as follows

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'localhost' (using password: NO) in C:\Program Files\EasyPHP 2.0b1\www\test1.php on line 2
Could not connect: Access denied for user 'admin'@'localhost' (using password: NO)

[pritaeas]

Apparantly you need to provide a password to connect to mysql. It is missing on line 2.

[rajarajan2017]

Goto

http://localhost/phpmyadmin/

And check the privileges tab for the user and password.

[akulkarni]

yes i got it through the admin page ..i used "root" instead of "admin"

[rajarajan2017]

Yes root without password will work. Please mark it as solved if solved.

[vaultdweller123]

the username should be root if you use the default
mysql_connect("localhost","root","")

[akulkarni]

a question..how to set the password

[rajarajan2017]

See the attachment

[sam023]

you can update the password also...

run this query in database 'mysql'->table 'user'

update user set Password = md5('12345') where user = "root";

above query update the user 'root' with password '12345'

[akulkarni]

Thanks