WordPress.org

1. Humerlis
   Member
   Posted 3 years ago #

   Error
   SQL query:

   SET CHARACTER SET 'utf8';

   MySQL said:

   #1115 - Unknown character set: 'utf8'

   What should I do?

2. Samuel B
   moderator
   Posted 3 years ago #

   UTF-8
   is how it is supposed to be

   when do you get this error?

3. Humerlis
   Member
   Posted 3 years ago #

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

4. Samuel B
   moderator
   Posted 3 years ago #

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

5. Humerlis
   Member
   Posted 3 years ago #

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

6. figaro
   Member
   Posted 3 years ago #

   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

7. Humerlis
   Member
   Posted 3 years ago #

   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.

8. Samuel B
   moderator
   Posted 3 years ago #

   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

Topic Closed

This topic has been closed to new replies.