Jules

No, there’s other WP installation. Thanks for response.

Same problem here. I keep getting random (Korean mostly) posts that GET PUBLISHED! I have installed the Publish-Approval plugin but that did not help. The posts get published still without approval and they are all under one users login. I also get spam “Categories and Tags” (all in Korean) as well.
My server sits behind a campus firewall as well as having the local firewall enabled.
How are these posts getting published and what can I do to stop them?
I’ve reviewed my plugins – and only three legit plugins installed (stop spam comments, publish approval and WP Health) I’ve removed all unused themes.

Suggestions on how to fix this annoying problem?
Many thanks!

Wow! Thank you. That worked.
I had simply changed my admin password that created the login problem. I had no idea permission to INSERT would stop me from logging in! And not quite sure how that insert permission got removed. ?
Many many thank yous!

Hello – I’m having a very similar issue, (cannot sign in with my admin user) but my logs have slightly different error. I’ve tried many of the suggestions in this thread but they have not worked; perhaps I’m not changing the correct values in my wp_usermeta table or I should be working in a different table entirely.

Could you please take a look at my weblogs to provide guidance on the value I should be modifying?

[Fri Apr 12 13:31:05.212195 2019] [php7:notice] [pid 31522] [client WordPress database error INSERT command denied to user ‘wpuser’@’leavitt.li.suu.edu’ for table ‘wp_usermeta’ for query INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (1, ‘session_tokens’, ‘a:1:{s:64:\\”2ffacadc867adefb78f35e476497e5e26f20cac70bbb7bc62d4dbc723675f033\\”;a:4:{s:10:\\”expiration\\”;i:1555270265;s:2:\\”ip\\”;s:13:\\”134.250.14.91\\”;s:2:\\”ua\\”;s:115:\\”Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36\\”;s:5:\\”login\\”;i:1555097465;}}’) made by wp_signon, wp_set_auth_cookie, WP_Session_Tokens->create, WP_Session_Tokens->update, WP_User_Meta_Session_Tokens->update_session, WP_User_Meta_Session_Tokens->update_sessions, update_user_meta, update_metadata, add_metadata, referer: https://leavitt.li.suu.edu/leavitt/wp-login.php
[Fri Apr 12 13:31:05.322711 2019] [php7:notice] [pid 31522] [client WordPress database error INSERT command denied to user ‘wpuser’@’leavitt.li.suu.edu’ for table ‘wp_options’ for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_doing_cron’, ‘1555097465.3213140964508056640625’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, wp_cron, spawn_cron, set_transient, add_option, referer: https://leavitt.li.suu.edu/leavitt/wp-login.php

values in my wp_usermeta table:

umeta_id user_id meta_key meta_value
1 1 nickname admin
2 1 rich_editing true
3 1 comment_shortcuts true
4 1 admin_color fresh
5 1 wp_capabilities a:1:{s:13:”administrator”;b:1;}
8 1 wp_usersettings m0=o&m1=c&m2=o&m3=o&m4=o&m5=o&m6=c&m7=o&m8=o&uploader=1&editor=tinymce
7 1 wp_user_level 10
9 1 wp_usersettingstime 1277750056
66 1 description
65 1 last_name
64 1 first_name Jul

RESOLVED!

I was simply missing a “LoadModule dir_module modules/mod_dir.so” in my httpd.conf file! So simple, now that I know the answer, but hope it helps save someone else the headache I had.