This documentation refers to an earlier version of Islandora. https://wiki.duraspace.org/display/ISLANDORA/Start is current.

To setup the MySQL Database for Fedora...

 Assuming MySQL database software is currently installed, execute the following:
 

# mysql -u root -p
Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 68
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. 
Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database fedora3;
Query OK, 1 row affected (0.00 sec)

mysql> create user 'fedoraAdmin'@'%' identified by 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on fedora3.* to 'fedoraAdmin'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> alter database fedora3 default character set utf8;
Query OK, 1 row affected (0.01 sec)

mysql> alter database fedora3 default collate utf8_bin;
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
mysql> exit

 

 

  • No labels