How to resolve some issue while Installing Moodle Ubuntu 16.04 using Xampp

How to resolve moodle fresh installation issue : 
mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix

1. Go to /opt/lampp/etc then edit my.cnf to add below code


[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4 
 
2. Restart Xampp
 
 
 

Comments

Post a Comment

Popular posts from this blog

How to learn data structure effectively

Step 1 : Learn the theory and fundamentals Understand top fundamental topics covered in data structures such as: Algorithms, Arrays, Collections, Complexity Analysis, Graphs, Hashtables, Heaps, Linked Lists, Queues, Recursion, Search, Sort, Stacks, Trees You can checkout these websites to help cover fundamentals: www.geeks4geeks.com  - explains all the high level fundamentals www.beehyve.io/data-structures  — student crowdsourced resources and community for any topic in CS including Data Structures Time complexity resources [BeeHyve]Time Complexity Cheat Sheet https://visualgo.net/en  - has visualizations of a lot of helpful algorithms Here are more schools that have DS classes which you may find helpful: CS 226 Algorithms and Data Structures Brown CS 16 Introduction to Algorithms and Data Structures Stanford CS 166 Data Structures CMU CSE 15-211 Fundamental Data Structures and Algorithms University of Washington at St. Louis CSE 241 Algorithms a...
Read more

How to create your own mail server

https://www.digitalocean.com/community/tutorials/why-you-may-not-want-to-run-your-own-mail-server https://www.digitalocean.com/community/tutorials/how-to-configure-a-mail-server-using-postfix-dovecot-mysql-and-spamassasin https://www.digitalocean.com/community/tutorials/how-to-run-your-own-mail-server-with-mail-in-a-box-on-ubuntu-14-04
Read more