Getting "can't find any matching row in the user table” when trying to change user password in Sequel Pro and Adminer

Support
1

After upgrading to High Sierra (macOS 10.13.1), I, unfortunately, lost all of my passwords. I’m having problems changing user passwords in Sequel Pro and Adminer. I keep on getting the "can’t find any matching row in the user table” when trying to change the password using any of these SQL commands (user and pswd are sample user and password values):

SET PASSWORD FOR ‘user’@‘local’ = ‘pswd’;

SET PASSWORD FOR ‘user’@‘local’ = PASSWORD ('pswd’);

If I can get past that particular error, I will issue this: FLUSH PRIVILEGES;

Any suggestions?

2

Hi @jmbimagery,

Can you explain why you’re trying to change the MySQL username/password?

Are you needing to change the WordPress user passwords or simply MySQL? The default database login for Local is root for the user root for the password.

3

I lost my passwords to the user accounts on a recent macOS update, so I cannot login to the sites. I’m not changing the MySQL database password.

4

Aha, that’s an easy fix using WP-CLI :slight_smile:

Here’s what you can do:

  1. Right-click on the site in Local’s sidebar
  2. Go to Open Site SSH
  3. Enter the following command (and adjust it accordingly): wp user update THE_USER --user_pass=NEW_PASSWORD

THE_USER can be the username, user ID, or email associated with the WordPress login.

For more info, please see https://developer.wordpress.org/cli/commands/user/update/

5

I got a successful update. That was pretty easy. Thanks!

Since I submitted my question last week, however, I have been unable to log into or view any of my test sites. I have been using 2.0.1 since I cannot run version 2.1.1. I have been getting the following:

This site can’t be reached

test-site.dev refused to connect.