By VPFedoraguy
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?
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
