TheChanger

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

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.

Michael Kimsal
http://heywords.com/srv - take our 2 minute survey

TheChanger

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

TheChanger

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

Alpha981

Hello Gordon

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

Hope that helps

LIKE our Animated Facebook Reveal Tab and get 21 Animated Transitions for FREE!!!
Iframe Wordpress Theme For Facebook Fan Pages
Niche Templates Affiliate Review Themes - Affiliate Review Templates - Review Site Theme - Review Site Templates

TheChanger

My .htaccess file is currently set to 755. I will change it to 644 asap.

Thank you