MySQL not working probably

[lnielsen]

Reported via Gitter:

Greetings. We tried to install Invenio v3.1.1 with setup instruction, but we selected MySQL database, because our company is used to work with MySQL database. After the research we want to report some issues with MySQL Invenio install.
First: When we process /scripts/setup, it will fails because of permissions of MySQL docker database. Looks like the Docker installer not creating or adding permissions to Invenio user (default: my-site). Following code is solution, how to get success with setup database:

 # Execute MySQL docker box
docker exec -it my-site_db_1 bash
 # Create user my-site with password my-site
CREATE USER 'my-site'@'%' IDENTIFIED BY 'my-site';
 # Create database my-site
CREATE DATABASE my-site;
 # Let my-site user get permission
GRANT ALL PRIVILEGES ON *.* TO 'my-site'@'%' WITH GRANT OPTION;

Now the setup will be success.
Second: When we create record via JSON CURL, it will write to MySQL table records_metadata with strange UTF8 strings (nonASCII strings). So if we want to view the record in site, it will throw Unicode error. Also I noticed, that the record in administration has correct UID. Just in MySQL database is strange like in picture: