WordPress.org

Ready to get started?Download WordPress

Forums

Locked out after wp_ prefix change with security scan (1 post)

  1. NeedHelpPlease
    Member
    Posted 3 years ago #

    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!!!'

Topic Closed

This topic has been closed to new replies.

About this Topic

  • RSS feed for this topic
  • Started 3 years ago by NeedHelpPlease
  • This topic is not resolved
  • WordPress version: 3.0.1