Page tree

Versions Compared

Key

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

...

Code Block
yum install mysql-server
service mysqld start

 

 

and create 1 user with ALL privileges to 1 database for Fedora Commons Repository software, and 1 user with 1 database for the Avalon web application. 

 

mysql

...

Create databases and users

Enter the mysql monitor:

Code Block
#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
.
.
mysql>

Create a database for the Fedora Commons Repository software and add a user to it.  

Code Block
create database fedora3;
create user 'railsfcrepo'@'localhost' identified by 'railsfcrepo';
grant all privileges on railsfedora3.* to 'railsfcrepo'@'localhost';
flush privileges;

 

 

 

Please see documentation for your version of MySQL Server for detailed syntax (http://dev.mysql.com/doc/refman/5.0/en/create-database.html)

...

 

Create a database for the Avalon web application and add a user to it.

Code Block
create database rails;
create user 'rails'@'localhost' identified by 'rails';
grant all privileges on rails.* to 'rails'@'localhost';
flush privileges;

Please see documentation for your version of MySQL Server for detailed syntax (http://dev.mysql.com/doc/refman/5.1/en/create-database.html )

Check your work
Code Block
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| fedora3            |
| mysql              |
| rails              |
| test               |
+--------------------+
5 rows in set (0.00 sec)
mysql> select user, host from mysql.user;
+--------+--------------+
| user   | host         |
+--------+--------------+
| root   | 127.0.0.1    |
|        | 129.79.32.87 |
| root   | 129.79.32.87 |
|        | localhost    |
| fcrepo | localhost    |
| rails  | localhost    |
| root   | localhost    |
+--------+--------------+
7 rows in set (0.00 sec)

 

Fedora Commons repository

wget http://sourceforge.net/projects/fedora-commons/files/fedora/3.6.2/fcrepo-installer-3.6.2.jar/download

...