Locked out after wp_ prefix change with security scan

  • I changed wp_ prefix in hopes to make my website more secure once it was launched. Instead, I managed to lock myself out of my WP admin pages. To make matters worse, my backup was also done incorrectly. I’m new to mac and made a stupid mistake.

    Could someone please help. I think that running a SQL will help (according to recommendations of many searches).

    If I go under the database table, 2nd tab (SQL) and type…
    UPDATEMYNEWPREFIX_usermetaSETmet_key=REPLACE(meta_key,’wp_’,
    ‘MYNEWPREFIX_’)

    …and MYNEWPREFIX is replaced with the prefix that I typed instead of WP (typed exactly as above without spaces)…will this fix the problem? I was using the WP Security Scan as the plug-in.

    THANK YOU in advance for any help!!!’

  • The topic ‘Locked out after wp_ prefix change with security scan’ is closed to new replies.