Re: [Openhive-discuss] Script to create openhive database.

[Bryce H. <br...@br...>]

On Tue, Jun 07, 2005 at 03:44:18PM -0700, cliff white wrote:
> This is a script for dummies like me.. 
> Starting from a fresh MySQL install, it creates 
> all the users, and makes the db ready to run the
> database.sql

Ah, excellent!  Looks good, this is definitely going to be useful for
folks.

Btw, I have been playing around with MediaWiki and was extremely
impressed with the way they handle doing the database initialization.
Basically you just untar the package in your webspace, then from a
browser you hit a config.php file, enter the name of your virgin db,
give the db user and pwd, and it goes through and populates the database
and everything.  Then you delete or hide the config.php file, and you're
good to go.

> Can someone add to CVS? 

Done.  It's in the openhive_database/ module.

Bryce

> cliffw
> ------------Start create_db_users.sh---------------
> #!/bin/bash
> 
> set -x
> # This is a script to create the openhive database administrator,
> # with the proper logins and passwords.
> # alter to suit your needs
> # Cliffw White 2005
> # Licensed under the GPL, see the file COPYING for details.
> 
> # We will use 'openhive' for our database user
> # We will add a 'mysql' user also
> 
> # Most of this comes from the MySQL manual
> 
> root_user="root"
> oh_user="openhive"
> admin_user="mysql"
> db="openhive"
> # this should be a big secret!
> admin_pw="mysql"
> oh_pw="openhive"
> host=`/bin/hostname`
> 
> 
> # secure the root user!
> mysql --user="$root_user" -e "set password for 'root'@'localhost' = PASSWORD('$admin_pw');"
> mysql --user="$root_user" --password="$admin_pw" -e "set password for 'root'@'$host' = PASSWORD('$admin_pw');"
> 
> # create the admin user
> 
> mysql --user="$root_user" --password="$admin_pw" -e "grant all privileges on *.* to 'mysql'@'localhost' IDENTIFIED by '$admin_pw'with GRANT OPTION;"
> mysql --user="$root_user" --password="$admin_pw" -e "grant all privileges on *.* to 'mysql'@'%' IDENTIFIED by '$admin_pw'with GRANT OPTION;"
> 
> # create the openhive db
> 
> mysql  --user="$root_user" --password="$admin_pw" -e "create database $db;"
> 
> # create the openhive user
> 
> mysql  --user="$root_user" --password="$admin_pw" --database="$db" -e "grant all privileges on $db.* to '$oh_user'@'localhost' identified by '$oh_pw';"
> mysql  --user="$root_user" --password="$admin_pw" --database="$db" -e "grant all privileges on $db.* to '$oh_user'@'%' identified by '$oh_pw';"
> 
> --------------end-------------------
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
> a projector? How fast can you ride your desk chair down the office luge track?
> If you want to score the big prize, get to know the little guy.  
> Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> _______________________________________________
> Openhive-discuss mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openhive-discuss
>