WordPress Droplet MySQL Username

Hello, @markdwardell

Would you mind sharing if you’re getting any exact error messages when trying to access the database using the client you’ve mentioned?

Have you tried to access the database using alternative client or simply by using the MySQL client when you’re logged in with ssh on the droplet itself?

You can check this tutorial as well:

How to Connect to a MySQL Server Remotely with MySQL Workbench

Regards, Alex

Hi @markdwardell,

So, the first thing you can always check to learn your user’s password without changing it is your WordPress’s wp-config.php file. In there you can see the database credentials your website is using. Usually, it looks something like this:

/** The name of the database for WordPress */
define( 'DB_NAME', 'wordpress' );

/** MySQL database username */
define( 'DB_USER', 'wordpress' );

/** MySQL database password */
define( 'DB_PASSWORD', 'PasswordHere' );

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

/** Database Charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8' );

/** The Database Collate type. Don't change this if in doubt. */
define( 'DB_COLLATE', '' );

And when using a WordPress droplet, you can find the file at the following path - /var/www/html/wp-config.php

Now, if you actually changed the password of your wordpress user, you’ll need to update it in your configuration file as well.

If you want to change the password your wordpress user is using, you can do the following once you’ve SSHed to the droplet:

mysql

 ALTER USER 'wordpress'@'localhost' IDENTIFIED BY 'NEW_PASSWORD_HERE';

Once you do change the password, remember to change it in the wp-config.php file as well.

Regards, KFSys