Title: My SQL – Create new database error
Last modified: August 19, 2016

---

# My SQL – Create new database error

 *  [humerlis](https://wordpress.org/support/users/humerlis/)
 * (@humerlis)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/)
 * Error
    SQL query:
 * SET CHARACTER SET ‘utf8’;
 * MySQL said:
 * #1115 – Unknown character set: ‘utf8’
 * What should I do?

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

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076279)
 * `UTF-8`
    is how it is supposed to be
 * when do you get this error?
 *  Thread Starter [humerlis](https://wordpress.org/support/users/humerlis/)
 * (@humerlis)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076318)
 * When I click phpMyAdmin after selecting my language when at [http://localhost/xampp/splash.php](http://localhost/xampp/splash.php)
   when setting up WordPress on my computer
 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076344)
 * review this to see if you did it all correctly
    [http://www.tamba2.org.uk/wordpress/xampp/](http://www.tamba2.org.uk/wordpress/xampp/)
 *  Thread Starter [humerlis](https://wordpress.org/support/users/humerlis/)
 * (@humerlis)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076351)
 * In the Xampp control panel, the running displays are there, but the module boxes
   are both checked
 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076358)
 * See if this helps…if your XAMPP install isn’t working, then try the process shown
   in the video with a fresh install.
 * [http://educhalk.org/blog/?p=154](http://educhalk.org/blog/?p=154)
 *  Thread Starter [humerlis](https://wordpress.org/support/users/humerlis/)
 * (@humerlis)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076479)
 * Thank you. Everything was working fine until I got to [http://localhost/wordpress/wp-admin/install.php](http://localhost/wordpress/wp-admin/install.php)
   and got
    Can’t select database We were able to connect to the database server(
   which means your username and password is okay) but not able to select the wordpress
   database.
 * Are you sure it exists?
    Does the user [rgabel@humerlis.com](https://wordpress.org/support/topic/my-sql-create-new-database-error/rgabel@humerlis.com?output_format=md)
   have permission to use the wordpress database? On some systems the name of your
   database is prefixed with your username, so it would be like username_wordpress.
   Could that be the problem? If you don’t know how to setup a database you should
   contact your host. If all else fails you may find help at the WordPress Support
   Forums.
 * I did find the following file:
 * C:\xampplite\mysql\data\wordpress
 * I may be in over my head.
 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076513)
 * > Does the user [rgabel@humerlis.com](https://wordpress.org/support/topic/my-sql-create-new-database-error/rgabel@humerlis.com?output_format=md)
   > have permission to use the wordpress database?
 * why is your user an email address?this should be the exact set up for wp-config.
   php
 *     ```
       define('DB_NAME', 'wordpress'); // The name of the database
       define('DB_USER', 'root'); // Your MySQL username
       define('DB_PASSWORD', ''); // ...and password
       define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
       ```
   
 * notice the db name is “wordpress”
    the user is always “root” and the password
   is left blank

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

The topic ‘My SQL – Create new database error’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 7 replies
 * 3 participants
 * Last reply from: [Samuel B](https://wordpress.org/support/users/samboll/)
 * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/my-sql-create-new-database-error/#post-1076513)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics