Configuring the EFM Server Metadata Store in MySQL

EFM Server requires a relational data store to store metadata. To use MySQL for this, install MySQL and create a database for the CEM metastore.

Launch the MySQL monitor:
```
mysql -u root -p
```

Create the database for the CEM metastore:

CREATE DATABASE EFM DEFAULT CHARACTER SET utf8;

Create the efm user account, replacing the final IDENTIFIED BY string with your password:
```
CREATE USER 'efm@'%' IDENTIFIED BY '9oNio)ex1ndL';
```

Assign privileges to the efm account:

GRANT ALL PRIVILEGES ON *.* TO 'efm@'%' WITH GRANT OPTION;

Commit the operation:
```
commit;
```

We want your opinion

How can we improve this page?

What kind of feedback do you have?