The anonymous user does not exist drupal 11.2

Can you add the exact command entered and the output?

1. In phpMyAdmin I selected the database.
2. I clicked on SQL.
3. In the card I pasted:

INSERT INTO users (uid, langcode, uuid) VALUES (0, 'en', '');

INSERT INTO `users_field_data` (`uid`, `langcode`, `preferred_langcode`, `preferred_admin_langcode`, `name`, `pass`, `mail`, `timezone`, `status`, `created`, `changed`, `access`, `login`, `init`, `default_langcode`) VALUES (0, 'en', 'en', NULL, '', NULL, NULL, '', 0, 0, 0, 0, 0, NULL, 1);

4. I clicked Run
5. Message:

Error
SQL Query: Copy
INSERT INTO users (uid, langcode, uuid) VALUES (0, 'en', '');
MySQL Message:
#1146 - Table 'hmcpdbiy_t2am1.users' does not exist

This looks like an install or a platform problem on your end. You will have to explain exactly how you installed Drupal.

If the users table doesn't exist then there were serious installation problems that only exist on your platform.

If the users table did not exist Drupal would not be operating. Perhaps your database hmcpdbiy_t2am1 is not the one in which Drupal is installed.

Drupal was automatically installed with cpanel.

Database tables have a prefix.
I added it in the query and it ran fine, but the problem remains.

What was the command you typed? It did not insert a row with uid = 0 so it must have failed with an error.

I entered #3 with the prefix xxx_users and there was no error.
The number of users is correct: 3 + anonymous (plus the one entered with the query).

Read carefully this section: https://www.drupal.org/node/1029506#s-a-database-import-changed-the-uid-... →

You probably need to execute UPDATE users SET uid = 0 WHERE uuid = '';

No, I have this error:
#1054 - Unknown column 'name' in 'WHERE'

Type the command that I provided in comment #11.

I'm sure I typed #11. Boh.

Anyway, it worked!!

Now all that's left to do is fix the CKEditor toolbar issue and then the site will be fully functional again.

Thanks for your help and patience