Need help with WP Security Scan plugin - Please
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
Michael Kimsal
http://heywords.com/ - for article writers