[Savannah-cvs] [387] Elaborate on setting up MySQL, per savannah-hackers-public@

[ineiev]

Revision: 387
          
http://svn.savannah.gnu.org/viewvc/?view=rev&root=administration&revision=387
Author:   ineiev
Date:     2019-06-17 13:23:26 -0400 (Mon, 17 Jun 2019)
Log Message:
-----------
Elaborate on setting up MySQL, per savannah-hackers-public@

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

Modified: trunk/sviki/RunningSavaneLocally.mdwn
===================================================================
--- trunk/sviki/RunningSavaneLocally.mdwn       2019-06-17 11:53:54 UTC (rev 
386)
+++ trunk/sviki/RunningSavaneLocally.mdwn       2019-06-17 17:23:26 UTC (rev 
387)
@@ -24,7 +24,7 @@
 
     # Install required packages.
     # Use php-mysql for PHP 7.0.
-    sudo apt-get install -y git php5-cli php5-mysql mysql-client \
+    sudo apt-get install -y git php5-cli php5-mysql mysql-client mysql-server \
                             imagemagick autoconf automake gettext make
 
     # Get Savane code.
@@ -73,24 +73,48 @@
 
     $ wget 
https://download.savannah.nongnu.org/releases/administration/savane_demo-2019-06-11.sql.gz
 
-    # Create a new MySQL database
-    $ echo "CREATE DATABASE savane_demo;" | mysql
+  ## Setup account for your account USERNAME:
 
-    # Load the demo tables
-    $ zcat savane_demo-2019-06-11.sql.gz | mysql savane_demo
+    $ sudo -i
+    # mysql -p
+    Enter password:
+    Welcome to the MySQL monitor.  Commands end with ; or \g.
+    Your MySQL connection id is 6
+    Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)
 
-    # Create a demo user
-    $ echo "grant SELECT on savane_demo.* TO 'USER'@'%' IDENTIFIED by 
'PASSWORD';" | mysql savane_demo
-    $ echo "grant insert,update,select,delete on savane_demo.* to 'USER'@'%';" 
| mysql savane_demo
+    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights 
reserved.
 
-Set `USER` and `PASSWORD` above to your desired values.
+    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.
+
+  ## Create a database user.
+  ## Set `USERNAME` and `PASSWORD` to your desired values.
+    mysql> CREATE USER 'USERNAME'@'localhost' IDENTIFIED by 'PASSWORD';
+    Query OK, 0 rows affected (0.01 sec)
+
+    mysql> GRANT ALL ON savane_demo.* TO 'USERNAME'@'localhost';
+    Query OK, 0 rows affected (0.01 sec)
+
+    mysql> quit;
+    Bye
+
+  ## Return to non-privileged login.
+    # exit
+    logout
+
+  ## Load the demo tables
+    $ zcat savane_demo-2019-06-11.sql.gz | mysql --user USERNAME -p
+    Enter password:
+
 Then update the configuration file with your local values
 (e.g. `/home/gordon/savane/local2/etc-savane/savane-dev-db.php` above):
 
     $sys_dbhost="localhost";
     $sys_dbname="savane_demo";
-    $sys_dbuser="USER";
+    $sys_dbuser="USERNAME";
     $sys_dbpasswd="PASSWORD";
 
 Reloading the savannah web page on your local web browser should