Question

Access denied for user 'admin'@'localhost' (using password: NO)

Posted February 17, 2015 16.3k views

First off I connect using this code here.

$mysqli = new mysqli("localhost", $username, $password, $database);

This works fine, I log in under root, (I know I should create a new user for security, but this so far is just a proof of concept)
However when I attempt to do a query such as

$sql = "SELECT 
                        user_id,
                        user_name,
                        user_level
                    FROM
                        users
                    WHERE
                        user_name = '" . mysql_real_escape_string($_POST['user_name']) . "'
                    AND
                        user_pass = '" . sha1($_POST['user_pass']) . "'";

            $result = mysql_query($sql);

It gives me the errors message Access denied for user ‘admin’@'localhost’ (using password: NO).
I don’t know why this is happening. Do I need to configure mysql a certain way?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

You’re connecting with MySQLi but you are using MySQL functions (which are also deprecated).

Submit an Answer