Error establishing a database connection

Hey @johnhardy ,

Could you please share me the following details :

define('DB_NAME',     '…');
define('DB_USER',     '…');
define('DB_HOST',     'localhost');

Then, open phpMyAdmin and go to User accounts, look for the user named exactly as your DB_USER and host as “localhost”. If It exists then drop me the details related to it.

It’s been a while the last time I used phpMyAdmin but you can check this YouTube video tutorial on how to find or reset your MySQL username and password: https://www.youtube.com/shorts/wLHGTvhw-lw

Check it out and see if that can help you in your local

Cheers!

Hi,

Sorry but it’s bit confusing. Is your database issue fixed now? I assume there’s no more support needed there?

I can enter the text OK but cannot see how to include some images. Can someone please explain. – Can you give us more details? Are you referring to a post, a page, or something else?

Cheers!

Hey @johnhardy ,

You can insert the images to this thread by simply going to image ImageKit.io and click on the option “Copy Direct CDN URL”.

Now you have a link on your clipboard, that you can insert here the following way. Click on the Blue + icon on your editor and add an image block.

After you add an image block you will see an option to “Insert URL” like this.

Simply paste the CDN URL that you just copied from imagekit. Your image will be inserted in this thread.

Hey @johnhardy,

I see your user and localhost now. Can you paste the following code in wp-config.php and replace your password with your own user password.

/** Database username */
define( 'DB_USER', 'root' );

/** Database password */
define( 'DB_PASSWORD', 'your_password' );

/** Database hostname */
define( 'DB_HOST', 'localhost' );

In case, you don’t remember password for your user root. Use one of the following code to change your password.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;

If above doesn’t work then try this one.

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

Hey @johnhardy ,

Here’s how you do it.

Step 1: Go to your phpmyadmin.

Step 2: Go to SQL tab.

Step 3: Enter the SQL query that I gave you to reset your password for the username ‘root’.

Step 4: At the bottom-right side you will see a button that says “Go”. Click on it to execute your query.

Hey @johnhardy ,

Could you please confirm if your address is http://localhost:8080/phpmyadmin/ ( 8080 ) and not (8081) ?

Regards