• 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)
  • UTF-8
    is how it is supposed to be

    when do you get this error?

    Thread Starter humerlis

    (@humerlis)

    When I click phpMyAdmin after selecting my language when at http://localhost/xampp/splash.php when setting up WordPress on my computer

    review this to see if you did it all correctly
    http://www.tamba2.org.uk/wordpress/xampp/

    Thread Starter humerlis

    (@humerlis)

    In the Xampp control panel, the running displays are there, but the module boxes are both checked

    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

    Thread Starter humerlis

    (@humerlis)

    Thank you. Everything was working fine until I got to 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 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.

    Does the user rgabel@humerlis.com 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.