Title: Case-sensitive WP_Table_prefix
Last modified: August 20, 2016

---

# Case-sensitive WP_Table_prefix

 *  Resolved [KleinBloemetje](https://wordpress.org/support/users/kleinbloemetje/)
 * (@kleinbloemetje)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/case-sensitive-wp_table_prefix/)
 * Today, I had some issues moving a local WP installation to the live server.
 * After some experimenting, I discovered that the issue had to do with case-sensitivity
   of the table_prefix as defined in the wp-config.php.
 * The local configuration:
    - wp-config defined $table_prefix = “VYN_”, using capitals.
    - The database contained tables with the prefix “vyn_”, using lower case.
    - Worked fine, no issues here.
    - Export of database used “vyn_” as lower case table prefix.
 * Migration to production:
    - Importing database tables resulted in tables with the prefix “vyn_”, using
      lower case.
    - Using wp-config with $table_prefix = “VYN_”, using upper case resulted in 
      a redirect to the installation page to enter database configuration etc.
    - Using wp-config with $table_prefix = “vyn_”, using lower case resulted in 
      a messed up site and not possible to login using whatever user I defined locally.
 * The solution that worked was to manually update the database contents replacing“
   VYN_” with “vyn_” for all table references used.
    Together with wp-config defining
   $table_prefix = “vyn_”, I’ve got it working at last…
 * Two reasons for this post:
    1. First I would like to help others possibly having the same issue.
    2. Second, it would be nice if this could be resolved in a next version of WordPress…(
       If this is the wrong location, please help with a suggestion for a better place.)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [BusinessITgeek](https://wordpress.org/support/users/businessitgeek/)
 * (@businessitgeek)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-wp_table_prefix/#post-3614300)
 * hi Klein,
 * Thanks for highlighting this. i encountered this problem too. I’m using version
   3.6. Apparently this problem exist way back in 2009:
    [http://esdev.net/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/#.Ui_rn9JkMwB](http://esdev.net/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/#.Ui_rn9JkMwB)
 * To Moderators,
    please feedback this to the development team and hopefully this
   gets rectified.
 * thanks!
 *  [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/case-sensitive-wp_table_prefix/#post-3614310)
 * How this works depends on the operating system that your MySQL server is running
   on, and how the lower_case_table_names variable is set on that server. See: [https://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html](https://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Case-sensitive WP_Table_prefix’ is closed to new replies.

## Tags

 * [case-sensitive](https://wordpress.org/support/topic-tag/case-sensitive/)
 * [local](https://wordpress.org/support/topic-tag/local/)
 * [wp-config](https://wordpress.org/support/topic-tag/wp-config/)

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 2 replies
 * 3 participants
 * Last reply from: [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/case-sensitive-wp_table_prefix/#post-3614310)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics