Need help with WP Security Scan plugin - Please

by TheChanger

Posted: 14 years ago 5 replies

PROGRAMMING

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:

Your table prefix should not be wp_. Click here to change it. and
The file .htaccess does not exist in wp-admin/.

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

Your User which is used to access your Wordpress Tables/Database, hasn't enough rights( is missing ALTER-right) to alter your Tablestructure. Please visit the plugin documentation for more information. If you believe you have alter rights, please contact the plugin author for assistance.

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:

The file .htaccess does not exist in wp-admin/.

Any help would be greatly appreciated.

Thank you,
Gordon

#plugin #scan #security

mgkimsal

14 years ago

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

{{ DiscussionBoard.errors[1891638].message }}

TheChanger

14 years ago

Originally Posted by mgkimsal

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.

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:The file .htaccess does not exist in wp-admin/.

What do I put in the .htaccess file?

Thanks in advance,
Gordon

Thanks
1 reply

{{ DiscussionBoard.errors[1891722].message }}

TheChanger 14 years ago

Originally Posted by Gordon Hay

Does anyone know how to fix this issue:The file .htaccess does not exist in wp-admin/.

What do I put in the .htaccess file?

Thanks in advance,
Gordon

I found the answer here: I installed the WP plugin "WP Security Admin Too... - JustAnswer

What permission level should I set for the .htaccess file?

Thanks
- Thanks
{{ DiscussionBoard.errors[1891808].message }}

Alpha981 14 years ago

Hello Gordon

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

Hope that helps
- [ 1 ] Thanks
- 1 reply
Signature
Free Visual Custom QR Codes For Mobile Internet Marketing, The following formats are supported: Text, URL, Facebook Profile, Facebook Like,Twitter Profile, Twitter Status, Linkedin Profile, vCard, meCard
{{ DiscussionBoard.errors[1891860].message }}
- TheChanger 14 years ago
  
  Originally Posted by Alpha981
  
  Hello Gordon
  
  I have just checked my .htaccess file and the permissions are set to 644
  
  Hope that helps
  
  My .htaccess file is currently set to 755. I will change it to 644 asap.
  
  Thank you
  
  Thanks
  
  {{ DiscussionBoard.errors[1893290].message }}

Need help with WP Security Scan plugin - Please

Trending Topics

Any thoughts on golf's latest phenom...Scottie Scheffler??

Should i Index Author pages?

best high quality crypto traffic.

What's the Best IM-Related Skill to Learn Today That Can Help in the Future?

Some interesting stats about brand comms