<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>Thank you Eric for your guide(s). One word of warning about MySQL charsets.<br></p><blockquote type="cite"><div class="ox-c3e60fac24-WordSection1"><p class="ox-c3e60fac24-MsoNormal"> </p><p class="ox-c3e60fac24-MsoNormal">Create the MySQL database:</p><p class="ox-c3e60fac24-MsoNormal"> </p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">mysql -h [mysql-host] -u root -p </span></p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">Enter password: [root-password] </span></p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">MySQL> CREATE DATABASE midpoint CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin DEFAULT COLLATE utf8_bin;</span></p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">MySQL> CREATE USER 'midpoint' IDENTIFIED BY 'some-password'; </span></p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">GRANT ALL on midpoint.* TO 'midpoint'; </span></p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">MySQL> \q </span></p><p class="ox-c3e60fac24-MsoNormal"> </p><p class="ox-c3e60fac24-MsoNormal">Import the database schema (will take a minute or so):</p><p class="ox-c3e60fac24-MsoNormal"> </p><p class="ox-c3e60fac24-MsoNormal" style="margin-left: .5in;"><span style="font-size: 12.0pt; font-family: Courier; color: #4472c4;">mysql -h [mysql-host] -u midpoint -p midpoint < /opt/midpoint/doc/config/sql/_all/mysql-3.8-all-utf8mb4.sql </span></p></div></blockquote><p>In most MySQL versions "utf8" uses 3 bytes to represent a symbol. Therefore utf8 == utf8mb3. Since the .sql file from midpoint is called "utf8mb4" meaning 4 bytes per symbol, the CREATE statement should be corrected accordingly.<br></p><p>Search "mysql utf8 vs utf8mb4" for the full description.<br></p><p>Paolo<br></p><p><br></p><p class="default-style"></p></body></html>