aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAntoine Amarilli <a3nm _at_ a3nm .dot. net>2013-12-29 00:15:42 (GMT)
committerAntoine Amarilli <a3nm _at_ a3nm .dot. net>2013-12-29 00:15:42 (GMT)
commitebb614d0dbb12cca5b8ac33e46da1bd9faf53460 (patch)
tree0546a6169ac95ae41d15d7fcd111987517f637b3
parentf5bf1179f6c2d47b79210dce0354d795dbdf9854 (diff)
downloaddrime-ebb614d0dbb12cca5b8ac33e46da1bd9faf53460.zip
drime-ebb614d0dbb12cca5b8ac33e46da1bd9faf53460.tar.gz
add instructions about SQL (suggested by Ted)
-rw-r--r--README16
1 files changed, 14 insertions, 2 deletions
diff --git a/README b/README
index 818e608..81fb4fb 100644
--- a/README
+++ b/README
@@ -22,6 +22,16 @@ also "frhyme.py" (see plint's documentation).
drime also requires PyMySQL <http://www.pymysql.org> and Flask
<http://flask.pocoo.org/> for Python3.
+drime requires a working MySQL installation (package mysql-server on Debian
+systems) and the instructions in this README require the MySQL client (package
+mysql-client) to populate the database. You will probably want to create a
+database and a user for drime, probably along the lines of the following SQL
+commands executed using "mysql -u root -p":
+
+ CREATE DATABASE drime;
+ CREATE USER 'drime'@'localhost' IDENTIFIED BY 'mysecretpassword';
+ GRANT ALL ON drime.* TO 'drime'@'localhost';
+
== 3. Generating the DB ==
The program database isn't shipped, but scripts are provided to build it
@@ -41,7 +51,9 @@ If this is not your first attempt, unzip might prompt you about overwriting
existing files. Answer 'A'.
To import the output of lexique2sql.sh in a MySQL database (on localhost,
-database 'drime', as user 'drime', interactive password authentication), run:
+database 'drime', as user 'drime', interactive password authentication, the
+password being "mysecretpassword" if you followed the instructions of the
+previous section), run:
cat output.sql |
cat <(echo 'use drime;') - |
@@ -50,7 +62,7 @@ database 'drime', as user 'drime', interactive password authentication), run:
mysql --default-character-set=utf8 -D drime -u drime -p
To monitor progress, use the pv utility (replace "cat output.sql" by
-"pv -l output.sql".
+"pv -l output.sql").
== 4. Using the DB ==