Title rewritten to: Fatal error: Unreachable mysqli_sql_exception for user 'Adeleke'@'localhost' (using password: yes)

Question

I'm trying to test my php software using XAMMP (localhost) but after clicking on the URL I keep getting:

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'Adeleke'@'localhost' (using password: YES)

I thought it was coming from xammp PhpMyAdmin so I installed Laragon and tried to test the software on it and here is what it showed

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'Adeleke'@'localhost' (using password: YES) in C:\laragon\www\MyQueerDate\ install\index.php:47 Stack trace: #0 C:\laragon\www\MyQueerDate\install\index.php(47): mysqli_connect('127.0.0.1', 'Adeleke', 'Badvibe019!', 'Laragon. MySQL') #1 {main} thrown in C:\laragon\www\MyQueerDate\install\index.php on line 47

This is lines 46 - 49 of MyQueerDate\install\index.php:

if (!empty($_POST['install'])) {
   $con = mysqli_connect($_POST['sql_host'], $_POST['sql_user'], $_POST['sql_pass'], $_POST['sql_name']);
   if (mysqli_connect_errno()) {
       $ServerErrors[] = "Failed to connect to MySQL: " . mysqli_connect_error();

I tried checking the output of the software and looking at the dashboard and admin panel but it kept showing;

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'Adeleke'@'localhost' (using password: YES) in C:\laragon\www\MyQueerDate\ install\index.php:47 Stack trace: #0 C:\laragon\www\MyQueerDate\install\index.php(47): mysqli_connect('127.0.0.1', 'Adeleke', 'Badvibe019!', 'Laragon. MySQL') #1 {main} thrown in C:\laragon\www\MyQueerDate\install\index.php on line 47

I tried it on cPanel and it worked, but I don't want to test the program on cPanel, I can't afford hosting right now, I want to try localhost.

Answer 1

Create a new user and use it to access your database.

Inquire: Create user 'user'@'localhost'; Grant all permissions on urdatabase.* to "user" identified by "password"@"localhost";