[midPoint] midPoint 3.8 Docker Install with MySQL

[Paolo Cravero]

Thank you Eric for your guide(s). One word of warning about MySQL charsets.

> 
>      
> 
>     Create the MySQL database:
> 
>      
> 
>         mysql -h [mysql-host] -u root -p
> 
>         Enter password: [root-password]
> 
>         MySQL> CREATE DATABASE midpoint CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin DEFAULT COLLATE utf8_bin;
> 
>         MySQL> CREATE USER 'midpoint' IDENTIFIED BY 'some-password';
> 
>         GRANT ALL on midpoint.* TO 'midpoint';
> 
>         MySQL> \q
> 
>      
> 
>     Import the database schema (will take a minute or so):
> 
>      
> 
>         mysql -h [mysql-host] -u midpoint -p midpoint < /opt/midpoint/doc/config/sql/_all/mysql-3.8-all-utf8mb4.sql
> 

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.

Search "mysql utf8 vs utf8mb4" for the full description.

Paolo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20181113/73b203b4/attachment.htm>