Can’t login to Admin panel after migrating to new server

Just create a new user using database query directly in database.

Below is the code to create a new admin account named newadmin with the password pass123. Note: We assume your database wp prefix is default.

INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status)
VALUES (‘newadmin’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);

Hi, Renu
Thanks for your reply.
I finally inserted the new user but the problem is still the same, the admin user is not able to login into the admin area. It redirects me continuously to the https:mydomain/wp-login.php area. I’m quite sure it’s something with the database, beceause yestaerday I’ve changed the collation from utf8mb4_general_ci to utf8mb4_unicode_ci

I’ve tried to execute the second query but it returns me the following error:
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘strcmp’

I’ve checked the collation of the database and change it to: utf8mb4_unicode_ci
The table usersmeta has utf8mb4_unicode_ci collation and also the columns meta_key, meta_value. What I’m doing wrong?

My phpmyadmin version is 4.7.9 and I’m using php 7.2 version

Regards

• This reply was modified 6 years, 3 months ago by estoespersonal.

Could you please share your site url?

Hi, Renu

Sadly my site is in a server that has no public internet access, so it’s in a private network for security reasons. What I’ve tried recently is changing the collate of the following tables:
ALTER TABLE wp_usermeta MODIFY meta_value VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE wp_usermeta MODIFY meta_value VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_usermeta MODIFY meta_key VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_usermeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_options CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_postmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_aryo_activity_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_commentmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_404 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_logs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_snippets CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_termmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_terms CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_term_taxonomy CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

But it still doesn′t work. Do you know which fixes I’ve got to do in order to get my app running again? As I said it’s working in my preproduction server but when I migrated everything to the production server it crashes.

If you want I can show you the wp-config.php file but I’m pretty sure it has something to do with the database because if I try to login with the “newadmin” user and a mistaken password like “badpswd” it shows a message telling me that my password is incorrect.

What else can I do?

I finnaly fixed it, the problem was with the collation of the column meta_value had a type of varchar(255), I’ve changed it to longtext and it worked again.