Cannot log in to administrators dashboard

Make sure you’re editing the right database & pay attention to the table prefix. Table prefix and database details needs to match wp-config.php settings.

Hi, Thank you for responding.

How do I check that? I worked on what was there when you click on it. So I do not know.

The database is this : wordpress-3530343177e3

Inside the database i worked on this: f6_users

Nothing under the structure column says: wp_

SJ

What caused you to lose the administrator capability?

Hi, I have absolutely no idea. I’m the only one working on the site. At some point, I set up another author for blogs which is actually also me. That was 2 weeks or so before.

I am trying to figure out how to check if the table prefix and database?prefix are the same. I suspect not. I suppose it will be the reason why changes have no effect.

SJ

Got it. If you’re able to get command line access, using WP-CLI might be straightforward way to fix this. I believe you could use wp user set-role.

First of all you need to verify that you are editing the right database after that just the user table and set the right administration rights to user carefully.

Morning, thank you.

I think I have set user roles correctly using this code:

a:1:{s:13:”administrator”;s:1:”1″;}

wp_capabilities

It made no difference.

There is only one database for this site. I do not know how to check the prefixes yet. I do not what to check

In File manager > Public > WP Content > wp-config-sample.php it is $table_prefix = ‘wp_’;

In File manager > Public > WP Content > WPConfig it is $table_prefix = ‘f6_’;

On one website I found this: “Change WordPress database prefix in the wp-config.php file: ????? The?wp-config?file contains database credentials, and it needs to be modified before you change the database prefix. Incorrect credentials tend to trigger the?“database connection issue” error, which makes a website blank.”

So, as I have said, in wp-config.php folder it is: $table_prefix = ‘f6_’;

So, in phpMyAdmin I made changes in f6_usermeta and f6_users.

The user meta is set as

Administrator 1: user ID 1: meta key= wp_capabilities met value = a:1:{s:13:”administrator”;s:1:”1″;}

Administrator 2: user ID 2: meta key= wp_capabilities met value = a:1:{s:13:”administrator”;s:1:”1″;}

Administrator 3: user ID 3: meta key= wp_capabilities met value = a:1:{s:13:”administrator”;s:1:”1″;}

Thanks

SJ

Hi,

I forgot to mention, when I tried to log in now it said the password is wrong.

SJ

Hi,

Just to confirm: In wp-config.php

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘wordpress-3530343177e3’);

In phpMyAdmin:

wordpress-3530343177e3.

So, I’m working in the right place

SJ

Hi,

Thnk you to those who tried to help. I lost the site

WordPress revealed its ugly side to me. This is a fatal flaw. It should never happen that someone loses a whole website because of no fault of their own.

This is a message to whomever takes charge. Have a good look at this, please. I have now lost weeks of work.

Everyone appreciates what had been created and is being made availble for free but the price in the end is just too high.

I’ll have to find a safer alternative.

Hi,

We deleted my entire website on the server. So, no database or folder remained. When I tried to install WP from new on the CP it said it is already installed. When I tried to log in with my new installation and new passwords I still could not log in as administrator.

That tells me the issue is with the WP software because my databases and folders had all been deleted.

@diebornmans I’m sorry to hear this happened to you, and pardon for the late response — I needed to step away from the forums for a bit.

I’m still foggy as to what could have caused you to lose administrator access in the first place. Perhaps there was a plugin conflict or a bug with the user registration logic that caused this to happen. I’ll take a look to see if I can create a new user and replicate the issue.

In any case, I wish you the best of luck on your next steps and hope that you can find something that suits your needs ??

Hi,

Thank you.

I built new websites from scratch. I suspect my account was hacked.

Regards

SJ