Access denied for user in mysql_real_escape_string()

[mdvignesh]

I created a password in wamp server than i added that password in new mysqli("localhost","root","beam","lms")

 

Now iam getting error :

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user ''@'localhost' (using password: NO) in on line 169

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in  on line 169

 

(Before having password thatis without password it was working good)

 

 

[requinix]

You're mixing mysqli with mysql. Can't do that. Pick one extension and use it.

 

mysqli_real_escape_string

[ManiacDan]

Also, change your root database password to something that isn't a 4 letter english word.

 

edit:  and don't use the root user for your website in the first place.