I tried what all the links suggested and nothing. I tried this bit of code and even deleted the wp_usermeta table after the insert command didn’t work and tried to create table firstly.
INSERT INTO ‘wp_usermeta'(‘umeta_id’,’user_id’,’meta_key’,’meta_value’) VALUES
(1, 1, ‘nickname’, ‘admin’),
(2, 1, ‘rich_editing’, ‘true’),
(3, 1, ‘admin_color’, ‘fresh’),
(4, 1, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’),
(5, 1, ‘wp_user_level’, ’10’);
then tried
CREATE TABLE wp_usermeta(‘umeta_id’,’user_id’,’meta_key’,’meta_value’) VALUES
(1, 1, ‘nickname’, ‘admin’),
(2, 1, ‘rich_editing’, ‘true’),
(3, 1, ‘admin_color’, ‘fresh’),
(4, 1, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’),
(5, 1, ‘wp_user_level’, ’10’);
and get the error
SQL query:
CREATE TABLE wp_usermeta(
‘umeta_id’,
‘user_id’,
‘meta_key’,
‘meta_value’
) VALUES ( 1, 1, ‘nickname’, ‘admin’ ) , ( 2, 1, ‘rich_editing’, ‘true’ ) , ( 3, 1, ‘admin_color’, ‘fresh’ ) , ( 4, 1, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’ ) , ( 5, 1, ‘wp_user_level’, ’10’ );
MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”umeta_id’,’user_id’,’meta_key’,’meta_value’) VALUES
(1, 1, ‘nickname’, ‘admin” at line 1