Change your WordPress Database Prefix in a Minute

RENAME TABLE wp_comments TO uyc_comments;
RENAME TABLE wp_commentmeta TO uyc_commentmeta;
RENAME TABLE wp_links TO uyc_links;
RENAME TABLE wp_options TO uyc_options;
RENAME TABLE wp_postmeta TO uyc_postmeta;
RENAME TABLE wp_posts TO uyc_posts;
RENAME TABLE wp_terms TO uyc_terms;
RENAME TABLE wp_termmeta TO uyc_termmeta;
RENAME TABLE wp_term_relationships TO uyc_term_relationships;
RENAME TABLE wp_term_taxonomy TO uyc_term_taxonomy;
RENAME TABLE wp_usermeta TO uyc_usermeta;
RENAME TABLE wp_users TO uyc_users;
UPDATE uyc_options SET option_name = REPLACE(option_name, 'wp_', 'uyc_') WHERE option_name LIKE 'wp_%';
UPDATE uyc_usermeta SET meta_key = REPLACE(meta_key, 'wp_', 'uyc_') WHERE meta_key LIKE 'wp_%';