...
- MySQL 5.5.49
- PostgreSQL 9.4 - 9.5
Database Setup
MySQL
To create a new database and user in MySQL, assuming a username of user1 and a password of xyz:
| Code Block |
|---|
$ mysql -u root -p
> create database fcrepo;
> create user 'user1'@'localhost' IDENTIFIED BY 'xyz';
> GRANT ALL PRIVILEGES ON fcrepo.* to 'user1'@'localhost';
> \q |
PostgreSQL
To create a new database and user in PostgreSQL, assuming a username of user1 and a password of xyz:
...