Need help with WP Security Scan plugin - Please

by 5 replies
8
Hello everyone,

Today I added the WP Security Scan plugin to one of my blogs. The following two problems were discovered during the initial scan:



I get the following error message, when I try to change the table prefixes via the plugin:



I contacted my hosting company (Hostgator) and they said everything seems to be setup correctly. And they said that the problem is most likely the plugin. So with said, I decided to try changing the tables manually by following these steps: Change WordPress database table name prefix | WordPress Developer

When I try to import the localhost.sql I get the following error message:

MySQL said:


#1007 - Can't create database 'username_wrdp1'; database exists

At this point I have no idea how to change the table prefixes. Can someone please help me figure this out?

I also have no idea how to fix this problem:



Any help would be greatly appreciated.

Thank you,
Gordon
#programming #plugin #scan #security
  • On the issue of 'database already exists', the sql file you have probably has a 'create database <foo>' statement in it already - just remove that one line and try again.
    • [ 1 ] Thanks
    • [1] reply
    • I was able to import the file after I deleted this line from the .sql file:

      CREATE DATABASE `username_wrdp1` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
      USE `username_wrdp1`;

      Thanks for the help Mgkimsal

      Does anyone know how to fix this issue:

      What do I put in the .htaccess file?

      Thanks in advance,
      Gordon
      • [1] reply
  • Hello Gordon

    I have just checked my .htaccess file and the permissions are set to 644

    Hope that helps
    • [ 1 ] Thanks
    • [1] reply
    • My .htaccess file is currently set to 755. I will change it to 644 asap.

      Thank you
Join the discussion

Next Topics on Trending Feed