1 (* HCoop
Domtool (http
://hcoop
.sourceforge
.net
/)
2 * Copyright (c
) 2006, Adam Chlipala
4 * This program is free software
; you can redistribute it
and/or
5 * modify it under the terms
of the GNU General Public License
6 * as published by the Free Software Foundation
; either version
2
7 * of the License
, or (at your option
) any later version
.
9 * This program is distributed
in the hope that it will be useful
,
10 * but WITHOUT ANY WARRANTY
; without even the implied warranty
of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE
. See the
12 * GNU General Public License for more details
.
14 * You should have received a copy
of the GNU General Public License
15 * along
with this program
; if not
, write to the Free Software
16 * Foundation
, Inc
., 51 Franklin Street
, Fifth Floor
, Boston
, MA
02110-1301, USA
.
19 (* MySQL user
/table management
*)
21 structure MySQL
:> MYSQL
= struct
23 val validPasswd
= CharVector
.all (fn ch
=> Char.isAlphaNum ch
29 fun adduser
{user
, passwd
} =
31 NONE
=> SOME
"No password given"
33 if validPasswd passwd
then
34 if Slave
.shell
[Config
.MySQL
.adduser
, user
, " ", passwd
] then
37 SOME
"Error executing CREATE USER script"
39 SOME
"Password contains characters besides letters, digits, and !.-_"
41 fun createdb
{user
, dbname
} =
42 if Slave
.shell
[Config
.MySQL
.createdb
, user
, " ", dbname
] then
45 SOME
"Error executing CREATE DATABASE script"
47 val _
= Dbms
.register ("mysql", {getpass
= SOME Client
.getpass
,