[Savannah-cvs] [756] Improve to use personal database named after $USER

[bob]

Revision: 756
          
http://svn.savannah.gnu.org/viewvc/?view=rev&root=administration&revision=756
Author:   rwp
Date:     2024-01-17 14:15:40 -0500 (Wed, 17 Jan 2024)
Log Message:
-----------
Improve to use personal database named after $USER

Modified Paths:
--------------
    trunk/sviki/RunningSavaneLocally.mdwn

Modified: trunk/sviki/RunningSavaneLocally.mdwn
===================================================================
--- trunk/sviki/RunningSavaneLocally.mdwn       2024-01-17 19:15:35 UTC (rev 
755)
+++ trunk/sviki/RunningSavaneLocally.mdwn       2024-01-17 19:15:40 UTC (rev 
756)
@@ -59,7 +59,7 @@
 can only make this work using the current supplied demo database to
 seed the new system.
 
-    ## Setup database account "gordon" and "savane_demo" database.
+    ## Setup database account "gordon" and "savane_gordon" database.
 
     $ sudo mysql
     Welcome to the MariaDB monitor.  Commands end with ; or \g.
@@ -71,11 +71,11 @@
     Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.
 
     ## Create the database.
-    MariaDB [(none)]> CREATE DATABASE savane_demo CHARACTER SET utf8mb4;
+    MariaDB [(none)]> CREATE DATABASE savane_gordon CHARACTER SET utf8mb4;
     Query OK, 1 row affected (0.001 sec)
 
     ## Create user and grant access privileges.  Use a different random 
password.
-    MariaDB [(none)]> GRANT ALL ON savane_demo.* TO 'gordon'@'localhost' 
IDENTIFIED BY 'eXbVedcYWHydp9b5';
+    MariaDB [(none)]> GRANT ALL ON savane_gordon.* TO 'gordon'@'localhost' 
IDENTIFIED BY 'eXbVedcYWHydp9b5';
     Query OK, 0 rows affected (0.016 sec)
 
     MariaDB [(none)]> FLUSH PRIVILEGES;
@@ -87,11 +87,12 @@
 Create a MariaDB option file in your home directory.  This will set
 the defaults for your interactive access to the database.  This
 contains the password and therefore should have permissions only for
-yourself removing group and other access permissions.
+yourself removing group and other access permissions.  Instead of
+"gordon" use your actual account name.
 
     gordon:~/src/savane$ cat >~/.my.cnf <<EOF
     [mysql]
-    database = savane_demo
+    database = savane_gordon
     user = gordon
     password = eXbVedcYWHydp9b5
     EOF
@@ -99,10 +100,10 @@
 
 Download the initial seed database.  Load the demo tables.  This
 "mysql" command will read the `~/.my.cnf` file above to use the
-indicated user and password.
+indicated user and password and database.
 
     $ wget 
https://download.savannah.nongnu.org/releases/administration/savane_demo-2022-05.sql.gz
-    $ zcat savane_demo-2022-05.sql.gz | mysql savane_demo
+    $ zcat savane_demo-2022-05.sql.gz | mysql
 
 For this local sandbox working copy we are going to be working in our
 home directory in a "$HOME/src/savane" directory.
@@ -129,7 +130,7 @@
 
     <?php
     $sys_dbhost="localhost";
-    $sys_dbname="savane_demo";
+    $sys_dbname="savane_gordon";
     $sys_dbuser="gordon";
     $sys_dbpasswd="eXbVedcYWHydp9b5";
     ?>