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
