1

I installed XAMPP in my laptop when i tried to open phpmyadmin it gives me the error as follows

Error

MySQL said: Documentation

1273 - Unknown collation: 'utf8mb4_general_ci'

Any suggestion why this error occurs?

Community
  • 1
  • 1
ashish kumar
  • 67
  • 2
  • 14
  • This might help http://stackoverflow.com/questions/21190523/phpmysql-error-1273-1273-unknown-collation-utf8mb4-general-ci – timr Mar 22 '15 at 18:41
  • I had that error using Firefox, but not Chrome, with XAMPP 1.7.3. I fixed it cleaning the cookies. – Leopoldo Sanczyk Feb 06 '19 at 00:09

1 Answers1

1

First Clear cookie

If error persists, try

Editing phpMyAdmin/libraries/DatabaseInterface.class.php

Change 

if (PMA_MYSQL_INT_VERSION >  50503) {
    $default_charset = 'utf8mb4';
    $default_collation = 'utf8mb4_general_ci';
} else {
    $default_charset = 'utf8';
    $default_collation = 'utf8_general_ci';
}

To

//if (PMA_MYSQL_INT_VERSION >  50503) {
//    $default_charset = 'utf8mb4';
//    $default_collation = 'utf8mb4_general_ci';
//} else {
    $default_charset = 'utf8';
    $default_collation = 'utf8_general_ci';
//}

Then restart Mysql.

Leandro Papasidero
  • 3,728
  • 1
  • 18
  • 33