...
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
...