Skip to main content

Fix XAMPP or LAMPP Error establishing a database connection for localhost

Issue:

Cannot connect to the localhost DB from the local apache server running PHP. I've experienced this issue with a couple of machines and with LAMPP stack and XAMPP on both Linux and Ubuntu. 

This is assuming you have correctly provided the DB username, password, and the database to the application and still getting this error when connecting to the DB.

No matter what application you are trying to run Moodle, WordPress, or a PHP connection script you wrote, it doesn't connect if you give the localhost or 127.0.0.1 as the DB host.

PHP DB connection error

WordPress DB Connection error
WordPress DB Connection error



Solution:


Make sure you have proper privileges given to the DB user in MySQL or MariaDB.
Note that I'm trying to set up WordPress and my DB name is wordpress1.

To check this, you have to select your DB in the PhpMyAdmin and navigate to the Privileges tab.

Privileges 


Once you are there, check the users.

DB Users
DB Users




If you have already created a user account for the DB, make sure that you have an account for the localhost as well. Ideally, if you have the hostname for the user account as "any" with the percentage mark "%" it should be sufficient. But apparently, it doesn't allow you to connect with localhost, so you must create another user account by allowing to connect from the localhost.


Labels:

Comments

Post a Comment

Popular posts from this blog

Install Docker on Windows 11 with WSL Ubuntu 22.04

This is to install Docker within Ubuntu WSL without using the Windows Docker application. Follow the below steps. Install Ubuntu 22.04 WSL 1. Enable Windows Subsystem for Linux and Virtual Machine platform Go to Control Panel -> Programs -> Programs and Features -> Turn Windows features on or off 2. Switch to WSL 2 Open Powershell and type in the below command. wsl --set-default-version 2 If you don't have WSL 2, download the latest WSL 2 package and install it.  3. Install Ubuntu Open Microsoft Store and search for Ubuntu. Select the version you intend to install. I'd use the latest LTS version Ubuntu 22.04. Click on the Get button. It will take a couple of minutes to download and install. 4. Open up the installed Ubuntu version that was installed. If you get an error like the below image, make sure to install the WSL2 Kernel update .  If it's an older Ubuntu version the error message would be something like the image below. Error: WSL 2 requires an update to its ...
1 comment
Read more

How to fix SSLHandshakeException PKIX path building failed in Java

TL ; DR 1. Extract the public certificate of the website/API that you are trying to connect from your Java application. Steps are mentioned in this post 2. Use the Java keytool to install the extracted certificate into the "cacerts" file (Trust store) keytool -import -trustcacerts -alias <domain name> -file <public certificate>.cert -keystore /path_to_java_home/jre/lib/security/cacerts -storepass changeit 3. Restart your Java application Exception A typical exception stack trace would look like below. javax.net.ssl. SSLHandshakeException : sun.security.validator.ValidatorException: PKIX path building failed : sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302) at sun.security.ssl.Handshake...
Post a Comment
Read more

Automatically open Chrome developer tools in a new tab

Sometimes we need to check the console or the network transactions of a link that opens up in a new tab. By default, the Chrome developer tools are not opening in a new tab. So, by the time when we hit F12 and open the dev tools, part of the information we needed could be already gone.  There's a setting in dev tools where you can keep the dev tools open automatically in a new tab. To enable that, hit F12 and open up the dev tools. Click on the settings icon in the top right corner. In the Preferences section, scroll down to the bottom. You'll be able to find the option to Auto-open DevTools for popups. Select the checkbox and we're good to go!
Post a Comment
Read more