mySQL to utf8mb4


#1

I have added these line to /etc/mysql/my.cnf But I am getting error during creation of a site

character-set-server=utf8mb4
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
init_connect='SET collation_connection = utf8mb4_unicode_ci'
skip-character-set-client-handshake

Where is the error?


#2

What’s the error message you get when creating a site?

What’s the content of /var/log/ee/ee.log upon site creation?


#3

2016-09-16 10:38:35,117 (DEBUG) ee : Creating database jizz_com 2016-09-16 10:38:35,120 (DEBUG) ee : 2016-09-16 10:38:35,120 (DEBUG) ee : ‘MySQL Connectivity problem occured’ 2016-09-16 10:38:35,120 (INFO) ee : Oops Something went wrong !!


#4

It seems your MySQL (MariaDB) is not running.

Try removing the added lines and restarting your Mysql (service mysql restart).

If it works, add one line, then restart MySQL and watch; if it restarts fine add another line and restart, until you figure out what’s wrong.


#5

Thanks @portofacil but I want to have utf8mb4 support for my sites If I have UTF8 support everything are working fine


#6

Okay, I’m sorry. Perhaps my English is not good enough to understand and explain what we both mean.

I hope someone else can help.


#7

I found this:

So my solution:

  1. revert your changes, restart mysql

  2. create wordpress site

  3. login into EasyEngine admin tools at port 22222

  4. open phpMyAdmin, login into mysql

  5. select your database, click it to open

  6. click operations tab -> find collation, select utf8mb4_unicode_ci


#8