Error establishing a database connection with XAMPP

Did you start the MySQL process?
Were you at localhost/wordpress or localhost/wordpress/wp-admin/install.php ?

Yes, MySQL and Apache are both running.

Both localhost/wordpress and localhost/wordpress/wp-admin/install.php redirect to localhost/wordpress/wp-admin/setup-config.php, which is the page that I was entering the credentials on.

• This reply was modified 5 years, 6 months ago by HashimA.

In phpMyAdmin, did you give the db user the permissions to access the database? That’s what the page is asking you also.

Does the user Hashim have permission to use the hashim_wordpress database?

Yes, as mentioned in the post, I followed every step of the instructions in the WordPress codex – step 8 deals with granting privileges.

Create test.php

<?php
$mysqli = new mysqli("127.0.0.1", "hashim", "password", "hashim_wordpress", 3306);
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

echo $mysqli->host_info . "\n";
$mysqli->close();
?>

https://yourdomain.com/test.php
Your default port is 3306?
Now delete test.php

if this also doesn’t work in the host field select localhost instead of any host .. first you have to delete the user and then recreate it

It’s not entirely clear what I’m meant to do , but if I’ve understood you correctly, here’s what I did:

– Created a file called test.php in XAMPP/htdocs, with the content above, replacing with my username and password

– Navigated to localhost/test.php in my browser

Here’s the output of test.php displayed by the browser:

Warning: mysqli::__construct(): (HY000/1045): Access denied for user ‘Hashim’@’localhost’ (using password: YES) in B:\Users\Hashim\Desktop\Charity Website\XAMPP\htdocs\test.php on line 2
Failed to connect to MySQL: (1045) Access denied for user ‘Hashim’@’localhost’ (using password: YES)
Warning: main(): Couldn’t fetch mysqli in B:\Users\Hashim\Desktop\Charity Website\XAMPP\htdocs\test.php on line 7

Warning: mysqli::close(): Couldn’t fetch mysqli in B:\Users\Hashim\Desktop\Charity Website\XAMPP\htdocs\test.php on line 8

Success! Thanks a lot autotutorial, your last post was what turned out to be the problem. I needed to change the dropdown in PHPMyAdmin for the user’s “Host name” field (under the Login Information tab) from “Any Host” to “Local”, which automatically changed % to localhost. I looked into why this is, and apparently it’s because % does not include localhost – see this StackOverflow answer.

The fact that the WordPress Codex doesn’t reflect this, however, considering how common it is to work on WordPress locally, seems to me a huge oversight, and something that should be amended as soon as possible.

Once again, thanks for your help autotutorial.

• This reply was modified 5 years, 6 months ago by HashimA.

any host indicates remote access to any ip while the server is blocked on the local ip. I’m glad you solved it and after reading that a charity site I can claim to have done something good for today ??
https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/