Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Index column size too large. The maximum column size is 767 bytes
  2.  
  3. sed -i 's/utf8mb4mb4/utf8/g' /etc/mysql/mariadb.conf.d/*
  4. drop your database
  5. restart mysql services
  6. mysql > select @@character_set_database;
  7. Alter the value utf8mb4 to utf8 and set collate to utf8_general_ci
  8. mysql > ALTER DATABASE glance CHARACTER SET utf8 COLLATE utf8_general_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement