Login | Register
My pages Projects Community openCollabNet

Discussions > cvs > CVS update: joist/sql/org/joist setup_user.sql.in

Project highlights: Architectural Overview

joist
Discussion topic

Back to topic list

CVS update: joist/sql/org/joist setup_user.sql.in

Author anoncvs
Full name anonymous CVS access
Date 2000-10-07 03:23:42 PDT
Message User: jrobbins
  Date: 00/10/07 03:23:42

  Modified: scripts create_joist_database
               sql/org/joist setup_user.sql.in
  Log:
  switched scripts to use mysql root user, and reload after table is made, and grant access ab both 127.0.0.1 and localhost
  
  Revision Changes Path
  1.5 +6 -6 joist/scripts/create​_joist_database
  
  Index: create_joist_database
  ====================​====================​====================​=======
  RCS file: /cvs/joist/scripts/c​reate_joist_database​,v
  retrieving revision 1.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- create_joist_database 2000/10/05 23:46:30 1.4
  +++ create_joist_database 2000/10/07 10:23:41 1.5
  @@ -1,26 +1,26 @@
   #!/bin/sh
   # Creates the Joist database user, database, and schema.
   #
  -# $Id: create_joist_database,v 1.4 2000/10/05 23:46:30 dlr Exp $
  +# $Id: create_joist_database,v 1.5 2000/10/07 10:23:41 jrobbins Exp $
   
   SQL_DIR="${SANDBOX}​/joist/sql/org/joist​"
  -MYSQL_MYSQLDB='mysql -p mysql'
  +MYSQL_MYSQLDB='mysql -u root -p mysql'
   MYSQL_APPDB="mysql -u${DATABASE_USER} -p${DATABASE_PASSWORD} ${DATABASE_NAME}"
   PW_MSG=''
   
   echo -n 'You will be prompted to enter a password several times during the '
   echo 'execution of '
  -echo 'this script. Please use the MySQL password of the current user.'
  +echo 'this script. Please use the root MySQL password.'
   echo
   
   echo "Setting up database user ${DATABASE_USER}"
   ${MYSQL_MYSQLDB} < ${SQL_DIR}/setup_user.sql
   
  -echo "Reloading grant tables"
  -mysqladmin -p reload
  -
   echo "Setting up database ${DATABASE_NAME}"
   ${MYSQL_MYSQLDB} < ${SQL_DIR}/setup_database.sql
  +
  +echo "Reloading grant tables"
  +mysqladmin -u root -p reload
   
   echo 'Creating database schema'
   ${MYSQL_APPDB} < ${SQL_DIR}/joist.sql
  
  
  
  1.2 +2 -1 joist/sql/org/joist/​setup_user.sql.in
  
  Index: setup_user.sql.in
  ====================​====================​====================​=======
  RCS file: /cvs/joist/sql/org/j​oist/setup_user.sql.​in,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- setup_user.sql.in 2000/10/05 23:44:13 1.1
  +++ setup_user.sql.in 2000/10/07 10:23:42 1.2
  @@ -1,9 +1,10 @@
   # Creates the database user.
   #
  -# $Id: setup_user.sql.in,v 1.1 2000/10/05 23:44:13 dlr Exp $
  +# $Id: setup_user.sql.in,v 1.2 2000/10/07 10:23:42 jrobbins Exp $
   
   # Add the database user.
   grant all privileges on __DATABASE_NAME__.* to __DATABASE_USER__@127.0.0.1 identified by '__DATABASE_PASSWORD__';
  +grant all privileges on __DATABASE_NAME__.* to __DATABASE_USER__@localhost identified by '__DATABASE_PASSWORD__';
   
   # Delete unsecured account.
   delete from user WHERE Password='' and User='';

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

CVS update: joist/sql/org/joist setup_user.sql.in anoncvs anonymous CVS access 2000-10-07 03:23:42 PDT
Messages per page: