| | 5 | |
| | 6 | == Set up Database == |
| | 7 | We advice using [http://mysql.com/ MySQL] v5.1, or use MySQL variant like [http://mariadb.org/ MariaDB]. |
| | 8 | |
| | 9 | MediaMosa is currently '''untested''' with [http://www.postgresql.org/ PostgreSQL]. |
| | 10 | |
| | 11 | Use the database '''mediamosa''' example below to create your database 'mediamosa' with user 'mediamosa' before proceeding. |
| | 12 | {{{ |
| | 13 | # The password entries below needs to be changed. |
| | 14 | |
| | 15 | # Create the database. |
| | 16 | CREATE DATABASE mediamosa DEFAULT CHARSET=utf8; |
| | 17 | |
| | 18 | # Create localhost access for user 'mediamosa'. |
| | 19 | CREATE USER 'mediamosa'@'localhost' IDENTIFIED BY 'mediamosa'; |
| | 20 | |
| | 21 | # Now grant usage for user 'mediamosa' on the 'mediamosa' database. |
| | 22 | GRANT USAGE ON mediamosa.* TO 'mediamosa'@'localhost' IDENTIFIED BY 'mediamosa' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; |
| | 23 | |
| | 24 | GRANT ALL ON mediamosa.* TO 'mediamosa'@'localhost'; |
| | 25 | }}} |
| | 26 | |
| | 27 | You may change the 'mediamosa' database prefix and the database user name. |
| | 28 | |
| | 29 | If you want to migrate your current MediaMosa v1.7 database to the new 2.x version, you have to create or have a database user, which has enough rights to read your current v1.7 databases. |
| | 30 | |
| | 31 | == Other == |