Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
$ mysql -u root -p
> createCREATE databaseDATABASE fcrepo CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
> createCREATE userUSER 'user1'@'localhost' IDENTIFIED BY 'xyz';
> GRANT ALL PRIVILEGES ON fcrepo.* to 'user1'@'localhost';
> \q


Note

MySQL and MariaDB use case insensitive collations by default, but resources in Fedora are case sensitive. If you decide to create your database using a case insensitive collation, then Fedora will not be able to handle case appropriately, leading to undefined behavior.

PostgreSQL

To create a new database and user in PostgreSQL, assuming a username of user1 and a password of xyz:

Code Block
$ sudo -u postgres psql
> createCREATE databaseDATABASE fcrepo;
> createCREATE userUSER user1;
> alterALTER userUSER user1 passwordPASSWORD 'xyz';
> grantGRANT allALL privilegesPRIVILEGES onON databaseDATABASE fcrepo toTO user1;
> \q


Docker-based Database Setup

...