Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
ab	51.43 KB	-rwxr-xr-x
annotate	10.2 KB	-rwxr-xr-x
apachectl	3.33 KB	-rwxr-xr-x
apr-1-config	6.84 KB	-rwxr-xr-x
apreq2-config	5.96 KB	-rwxr-xr-x
apu-1-config	6.42 KB	-rwxr-xr-x
apxs	23.3 KB	-rwxr-xr-x
aria_chk	4.56 MB	-rwxr-xr-x
aria_dump_log	4.35 MB	-rwxr-xr-x
aria_ftdump	4.37 MB	-rwxr-xr-x
aria_pack	4.4 MB	-rwxr-xr-x
aria_read_log	4.51 MB	-rwxr-xr-x
autopoint	25.97 KB	-rwxr-xr-x
bdftogd	3.91 KB	-rwxr-xr-x
bison	288.55 KB	-rwxr-xr-x
bmp2tiff	14.32 KB	-rwxr-xr-x
bsqldb	26.76 KB	-rwxr-xr-x
bunzip2	85.55 KB	-rwxr-xr-x
bzcat	85.55 KB	-rwxr-xr-x
bzcmp	2.08 KB	-rwxr-xr-x
bzdiff	2.08 KB	-rwxr-xr-x
bzegrep	1.64 KB	-rwxr-xr-x
bzfgrep	1.64 KB	-rwxr-xr-x
bzgrep	1.64 KB	-rwxr-xr-x
bzip2	85.55 KB	-rwxr-xr-x
bzip2recover	14.23 KB	-rwxr-xr-x
bzless	1.23 KB	-rwxr-xr-x
bzmore	1.23 KB	-rwxr-xr-x
captoinfo	66.7 KB	-rwxr-xr-x
checkgid	6.13 KB	-rwxr-xr-x
cjpeg	30.29 KB	-rwxr-xr-x
clear	6.12 KB	-rwxr-xr-x
corelist	15.03 KB	-rwxr-xr-x
cpan	8.18 KB	-rwxr-xr-x
crc32	715 B	-r-xr-xr-x
c_rehash	6.57 KB	-rwxr-xr-x
curl	174.83 KB	-rwxr-xr-x
curl-config	5.48 KB	-rwxr-xr-x
cwebp	50.9 KB	-rwxr-xr-x
datacopy	22.45 KB	-rwxr-xr-x
dbilogstrip	1.44 KB	-r-xr-xr-x
dbiprof	6.17 KB	-r-xr-xr-x
dbiproxy	5.37 KB	-r-xr-xr-x
dbl2png	14.3 KB	-rwxr-xr-x
dbmmanage	8.72 KB	-rwxr-xr-x
defncopy	18.76 KB	-rwxr-xr-x
derb	23.09 KB	-rwxr-xr-x
djpeg	26.27 KB	-rwxr-xr-x
dwebp	30.49 KB	-rwxr-xr-x
enc2xs	40.79 KB	-rwxr-xr-x
encguess	3.02 KB	-rwxr-xr-x
envsubst	34.55 KB	-rwxr-xr-x
envvars	1.03 KB	-rw-r--r--
envvars-std	1.03 KB	-rw-r--r--
fax2ps	18.52 KB	-rwxr-xr-x
fax2tiff	14.66 KB	-rwxr-xr-x
fcgistarter	10.27 KB	-rwxr-xr-x
fisql	26.91 KB	-rwxr-xr-x
fix_rights	956 B	-rwxr-xr-x
flex	353.36 KB	-rwxr-xr-x
flex++	353.36 KB	-rwxr-xr-x
freebcp	18.59 KB	-rwxr-xr-x
freetype-config	3.75 KB	-rwxr-xr-x
ftpasswd	33.94 KB	-rwxr-xr-x
ftpcount	15.67 KB	-rwxr-xr-x
ftpdctl	82.73 KB	-rwxr-xr-x
ftpmail	13.69 KB	-rwxr-xr-x
ftpquota	32.21 KB	-rwxr-xr-x
ftptop	23.52 KB	-rwxr-xr-x
ftpwho	47.84 KB	-rwxr-xr-x
gd2copypal	10.15 KB	-rwxr-xr-x
gd2togif	10.14 KB	-rwxr-xr-x
gd2topng	10.16 KB	-rwxr-xr-x
gdcmpgif	10.15 KB	-rwxr-xr-x
gdparttopng	10.16 KB	-rwxr-xr-x
gdtopng	10.14 KB	-rwxr-xr-x
genbrk	14.84 KB	-rwxr-xr-x
gencfu	10.74 KB	-rwxr-xr-x
gencnval	22.73 KB	-rwxr-xr-x
gendict	22.91 KB	-rwxr-xr-x
gen_php_doc.sh	240 B	-rwxr-xr-x
genrb	161.05 KB	-rwxr-xr-x
GET	14.34 KB	-r-xr-xr-x
gettext	34.53 KB	-rwxr-xr-x
gettextize	42.73 KB	-rwxr-xr-x
gettext.sh	4.52 KB	-rwxr-xr-x
gif2tiff	14.48 KB	-rwxr-xr-x
giftogd2	10.15 KB	-rwxr-xr-x
h2ph	28.55 KB	-rwxr-xr-x
h2xs	59.52 KB	-rwxr-xr-x
HEAD	14.34 KB	-r-xr-xr-x
htcacheclean	30.53 KB	-rwxr-xr-x
htdbm	18.47 KB	-rwxr-xr-x
htdigest	10.27 KB	-rwxr-xr-x
html_template_phplibtool	107 B	-rwxr-xr-x
htpasswd	18.41 KB	-rwxr-xr-x
httpd	696.97 KB	-rwxr-xr-x
httxt2dbm	10.23 KB	-rwxr-xr-x
iconv	26.38 KB	-rwxr-xr-x
icu-config	21.58 KB	-rwxr-xr-x
icuinfo	10.54 KB	-rwxr-xr-x
infocmp	58.65 KB	-rwxr-xr-x
infotocap	66.7 KB	-rwxr-xr-x
innochecksum	3.62 MB	-rwxr-xr-x
instmodsh	4.16 KB	-r-xr-xr-x
jpegtran	42.36 KB	-rwxr-xr-x
json_pp	4.89 KB	-rwxr-xr-x
ldapadd	67.11 KB	-rwxr-xr-x
ldapcompare	55 KB	-rwxr-xr-x
ldapdelete	59.09 KB	-rwxr-xr-x
ldapexop	55.06 KB	-rwxr-xr-x
ldapmodify	67.11 KB	-rwxr-xr-x
ldapmodrdn	55 KB	-rwxr-xr-x
ldappasswd	55.03 KB	-rwxr-xr-x
ldapsearch	79.36 KB	-rwxr-xr-x
ldapurl	18.34 KB	-rwxr-xr-x
ldapwhoami	55.02 KB	-rwxr-xr-x
libmcrypt-config	1.43 KB	-rwxr-xr-x
libnetcfg	15.42 KB	-rwxr-xr-x
libpng16-config	2.27 KB	-rwxr-xr-x
libpng-config	2.27 KB	-rwxr-xr-x
listaction	170.55 KB	-rwxr-xr-x
listaction_d	170.54 KB	-rwxr-xr-x
listfdb	14.17 KB	-rwxr-xr-x
listjpeg	6.13 KB	-rwxr-xr-x
listmp3	10.54 KB	-rwxr-xr-x
listswf	174.55 KB	-rwxr-xr-x
listswf_d	174.54 KB	-rwxr-xr-x
logresolve	10.34 KB	-rwxr-xr-x
lwp-download	8.34 KB	-r-xr-xr-x
lwp-mirror	2.45 KB	-r-xr-xr-x
lwp-request	14.34 KB	-r-xr-xr-x
lwp-rget	14.78 KB	-r-xr-xr-x
makeconv	55.35 KB	-rwxr-xr-x
makefdb	70.41 KB	-rwxr-xr-x
makeswf	23.2 KB	-rwxr-xr-x
mariabackup	22.87 MB	-rwxr-xr-x
mariadb	4.28 MB	-rwxr-xr-x
mariadb-access	109.37 KB	-rwxr-xr-x
mariadb-admin	3.83 MB	-rwxr-xr-x
mariadb-backup	22.87 MB	-rwxr-xr-x
mariadb-binlog	4.05 MB	-rwxr-xr-x
mariadb-check	3.83 MB	-rwxr-xr-x
mariadb-client-test	4.38 MB	-rwxr-xr-x
mariadb_config	10.52 KB	-rwxr-xr-x
mariadb-convert-table-format	4.12 KB	-rwxr-xr-x
mariadbd-multi	26.76 KB	-rwxr-xr-x
mariadbd-safe	30.43 KB	-rwxr-xr-x
mariadbd-safe-helper	3.49 MB	-rwxr-xr-x
mariadb-dump	3.92 MB	-rwxr-xr-x
mariadb-dumpslow	8.05 KB	-rwxr-xr-x
mariadb-find-rows	3.21 KB	-rwxr-xr-x
mariadb-fix-extensions	1.22 KB	-rwxr-xr-x
mariadb-hotcopy	34.14 KB	-rwxr-xr-x
mariadb-import	3.82 MB	-rwxr-xr-x
mariadb-install-db	21.48 KB	-rwxr-xr-x
mariadb-ldb	4.05 MB	-rwxr-xr-x
mariadb-plugin	3.53 MB	-rwxr-xr-x
mariadb-secure-installation	13.38 KB	-rwxr-xr-x
mariadb-setpermission	17.13 KB	-rwxr-xr-x
mariadb-show	3.82 MB	-rwxr-xr-x
mariadb-slap	3.84 MB	-rwxr-xr-x
mariadb-test	4.21 MB	-rwxr-xr-x
mariadb-tzinfo-to-sql	3.53 MB	-rwxr-xr-x
mariadb-upgrade	3.62 MB	-rwxr-xr-x
mariadb-waitpid	3.52 MB	-rwxr-xr-x
mbstream	3.55 MB	-rwxr-xr-x
ming-config	561 B	-rwxr-xr-x
mp2bug	1.16 KB	-r-xr-xr-x
msgattrib	22.39 KB	-rwxr-xr-x
msgcat	18.38 KB	-rwxr-xr-x
msgcmp	22.49 KB	-rwxr-xr-x
msgcomm	18.37 KB	-rwxr-xr-x
msgconv	18.35 KB	-rwxr-xr-x
msgen	18.35 KB	-rwxr-xr-x
msgexec	14.38 KB	-rwxr-xr-x
msgfilter	26.45 KB	-rwxr-xr-x
msgfmt	79.41 KB	-rwxr-xr-x
msggrep	46.73 KB	-rwxr-xr-x
msginit	43.15 KB	-rwxr-xr-x
msgmerge	51.37 KB	-rwxr-xr-x
msgunfmt	30.57 KB	-rwxr-xr-x
msguniq	18.36 KB	-rwxr-xr-x
msql2mysql	1.42 KB	-rwxr-xr-x
myisamchk	4 MB	-rwxr-xr-x
myisam_ftdump	3.88 MB	-rwxr-xr-x
myisamlog	3.86 MB	-rwxr-xr-x
myisampack	3.91 MB	-rwxr-xr-x
my_print_defaults	3.53 MB	-rwxr-xr-x
myrocks_hotbackup	24.46 KB	-rwxr-xr-x
mysql	4.28 MB	-rwxr-xr-x
mysqlaccess	109.37 KB	-rwxr-xr-x
mysqladmin	3.83 MB	-rwxr-xr-x
mysqlbinlog	4.05 MB	-rwxr-xr-x
mysqlcheck	3.83 MB	-rwxr-xr-x
mysql_client_test	4.38 MB	-rwxr-xr-x
mysql_config	4.54 KB	-rwxr-xr-x
mysql_convert_table_format	4.12 KB	-rwxr-xr-x
mysqld_multi	26.76 KB	-rwxr-xr-x
mysqld_safe	30.43 KB	-rwxr-xr-x
mysqld_safe_helper	3.49 MB	-rwxr-xr-x
mysqldump	3.92 MB	-rwxr-xr-x
mysqldumpslow	8.05 KB	-rwxr-xr-x
mysql_find_rows	3.21 KB	-rwxr-xr-x
mysql_fix_extensions	1.22 KB	-rwxr-xr-x
mysqlhotcopy	34.14 KB	-rwxr-xr-x
mysqlimport	3.82 MB	-rwxr-xr-x
mysql_install_db	21.48 KB	-rwxr-xr-x
mysql_ldb	4.05 MB	-rwxr-xr-x
mysql_plugin	3.53 MB	-rwxr-xr-x
mysql_secure_installation	13.38 KB	-rwxr-xr-x
mysql.server	11.93 KB	-rwxr-xr-x
mysql_setpermission	17.13 KB	-rwxr-xr-x
mysqlshow	3.82 MB	-rwxr-xr-x
mysqlslap	3.84 MB	-rwxr-xr-x
mysqltest	4.21 MB	-rwxr-xr-x
mysql_tzinfo_to_sql	3.53 MB	-rwxr-xr-x
mysql_upgrade	3.62 MB	-rwxr-xr-x
mysql_waitpid	3.52 MB	-rwxr-xr-x
mytop	61.06 KB	-rwxr-xr-x
ncurses5-config	5.17 KB	-rwxr-xr-x
ngettext	34.55 KB	-rwxr-xr-x
onig-config	1.35 KB	-rwxr-xr-x
openssl	642.05 KB	-rwxr-xr-x
osql	8.84 KB	-rwxr-xr-x
pal2rgb	14.82 KB	-rwxr-xr-x
pcre-config	2.31 KB	-rwxr-xr-x
pcregrep	36.34 KB	-rwxr-xr-x
pcretest	66.56 KB	-rwxr-xr-x
pear	817 B	-rwxr-xr-x
peardev	838 B	-rwxr-xr-x
pearinfo	538 B	-rwxr-xr-x
pecl	751 B	-rwxr-xr-x
perl	3.3 MB	-rwxr-xr-x
perl5.34.1	3.3 MB	-rwxr-xr-x
perlbug	44.13 KB	-rwxr-xr-x
perldoc	274 B	-rwxr-xr-x
perlivp	10.58 KB	-rwxr-xr-x
perlthanks	44.13 KB	-rwxr-xr-x
perror	3.71 MB	-rwxr-xr-x
phar	14.89 KB	-rwxr-xr-x
phar.phar	14.89 KB	-rwxr-xr-x
php	18.06 MB	-rwxr-xr-x
php-8.2.12	18.06 MB	-rwxr-xr-x
php-cgi	18.06 MB	-rwxr-xr-x
php-cgi-8.2.12	18.06 MB	-rwxr-xr-x
php-config	4.39 KB	-rwxr-xr-x
php-config-8.2.12	4.39 KB	-rwxr-xr-x
phpdbg	18.06 MB	-rwxr-xr-x
phpize	4.43 KB	-rwxr-xr-x
phpize-8.2.12	4.43 KB	-rwxr-xr-x
phpunit	1.9 KB	-rwxr-xr-x
piconv	8.18 KB	-rwxr-xr-x
pkgdata	43.7 KB	-rwxr-xr-x
pl2pm	4.44 KB	-rwxr-xr-x
png2dbl	14.38 KB	-rwxr-xr-x
pngfix	46.48 KB	-rwxr-xr-x
png-fix-itxt	6.11 KB	-rwxr-xr-x
pngtogd	10.14 KB	-rwxr-xr-x
pngtogd2	10.15 KB	-rwxr-xr-x
pod2html	4.05 KB	-rwxr-xr-x
pod2man	14.69 KB	-rwxr-xr-x
pod2text	10.56 KB	-rwxr-xr-x
pod2usage	4.02 KB	-rwxr-xr-x
podchecker	3.58 KB	-rwxr-xr-x
POST	14.34 KB	-r-xr-xr-x
ppm2tiff	14.51 KB	-rwxr-xr-x
prove	13.35 KB	-rwxr-xr-x
prxs	8.96 KB	-rwxr-xr-x
ptar	3.49 KB	-rwxr-xr-x
ptardiff	2.59 KB	-rwxr-xr-x
ptargrep	4.3 KB	-rwxr-xr-x
ras2tiff	10.48 KB	-rwxr-xr-x
raw2adpcm	10.21 KB	-rwxr-xr-x
raw2tiff	18.35 KB	-rwxr-xr-x
rdjpgcom	10.18 KB	-rwxr-xr-x
recode-sr-latin	14.33 KB	-rwxr-xr-x
replace	3.5 MB	-rwxr-xr-x
reset	18.59 KB	-rwxr-xr-x
resolveip	3.52 MB	-rwxr-xr-x
resolve_stack_dump	3.53 MB	-rwxr-xr-x
rgb2ycbcr	14.46 KB	-rwxr-xr-x
rotatelogs	18.41 KB	-rwxr-xr-x
sabcmd	21.13 KB	-rwxr-xr-x
sablot-config	1.11 KB	-rwxr-xr-x
shasum	9.76 KB	-rwxr-xr-x
splain	18.97 KB	-rwxr-xr-x
sqlite	27.8 KB	-rwxr-xr-x
sqlite3	1.74 MB	-rwxr-xr-x
sst_dump	4.04 MB	-rwxr-xr-x
streamzip	5.31 KB	-r-xr-xr-x
suexec	14.36 KB	-rwsr-xr-x
swftocxx	154.57 KB	-rwxr-xr-x
swftoperl	154.57 KB	-rwxr-xr-x
swftophp	154.57 KB	-rwxr-xr-x
swftopython	154.57 KB	-rwxr-xr-x
swftotcl	154.57 KB	-rwxr-xr-x
tabs	14.31 KB	-rwxr-xr-x
tdspool	286.9 KB	-rwxr-xr-x
thumbnail	14.92 KB	-rwxr-xr-x
tic	66.7 KB	-rwxr-xr-x
tiff2bw	14.8 KB	-rwxr-xr-x
tiff2pdf	66.52 KB	-rwxr-xr-x
tiff2ps	55.95 KB	-rwxr-xr-x
tiff2rgba	14.32 KB	-rwxr-xr-x
tiffcmp	18.41 KB	-rwxr-xr-x
tiffcp	43.31 KB	-rwxr-xr-x
tiffcrop	112.88 KB	-rwxr-xr-x
tiffdither	14.48 KB	-rwxr-xr-x
tiffdump	18.52 KB	-rwxr-xr-x
tiffinfo	18.55 KB	-rwxr-xr-x
tiffmedian	22.44 KB	-rwxr-xr-x
tiffset	10.23 KB	-rwxr-xr-x
tiffsplit	14.3 KB	-rwxr-xr-x
toe	14.38 KB	-rwxr-xr-x
tput	14.41 KB	-rwxr-xr-x
tset	18.59 KB	-rwxr-xr-x
tsql	282.99 KB	-rwxr-xr-x
uconv	47.36 KB	-rwxr-xr-x
unzip-mem	14.21 KB	-rwxr-xr-x
unzzip	10.21 KB	-rwxr-xr-x
unzzipcat	10.2 KB	-rwxr-xr-x
unzzipcat-mem	10.17 KB	-rwxr-xr-x
unzzipcat-seeko	10.2 KB	-rwxr-xr-x
unzzipdir	6.16 KB	-rwxr-xr-x
unzzipdir-mem	6.13 KB	-rwxr-xr-x
use-devel-checklib	2.81 KB	-r-xr-xr-x
wcmgr	6.1 KB	-rwxr-xr-x
webalizer	157.1 KB	-rwxr-xr-x
webazolver	157.1 KB	-rwxr-xr-x
webpng	14.28 KB	-rwxr-xr-x
wrjpgcom	10.19 KB	-rwxr-xr-x
wsrep_sst_backup	2.95 KB	-rwxr-xr-x
wsrep_sst_common	54.05 KB	-rw-r--r--
wsrep_sst_mariabackup	51.01 KB	-rwxr-xr-x
wsrep_sst_mysqldump	7.7 KB	-rwxr-xr-x
wsrep_sst_rsync	32.31 KB	-rwxr-xr-x
wsrep_sst_rsync_wan	32.31 KB	-rwxr-xr-x
xgettext	330.1 KB	-rwxr-xr-x
xml2-config	1.69 KB	-rwxr-xr-x
xmlcatalog	14.35 KB	-rwxr-xr-x
xmllint	64.38 KB	-rwxr-xr-x
xmlwf	26.57 KB	-rwxr-xr-x
xslt-config	2.36 KB	-rwxr-xr-x
xsltproc	22.52 KB	-rwxr-xr-x
xsubpp	5.06 KB	-rwxr-xr-x
yacc	45 B	-rwxr-xr-x
zipcmp	19 KB	-rwxr-xr-x
zipdetails	49.95 KB	-r-xr-xr-x
zipmerge	14.88 KB	-rwxr-xr-x
ziptool	27.7 KB	-rwxr-xr-x
zzcat	6.13 KB	-rwxr-xr-x
zzdir	10.16 KB	-rwxr-xr-x
zzxorcat	10.16 KB	-rwxr-xr-x
zzxorcopy	10.17 KB	-rwxr-xr-x
zzxordir	10.19 KB	-rwxr-xr-x

Code Editor : mysql_setpermission

#!/usr/bin/perl
## Emacs, this is -*- perl -*- mode? :-)

# Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU Library General Public
# License as published by the Free Software Foundation; version 2
# of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
# Library General Public License for more details.
#
# You should have received a copy of the GNU Library General Public
# License along with this library; if not, write to the Free
# Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
# MA 02110-1335  USA

##
##        Permission setter for MySQL
##
##        mady by Luuk de Boer (luuk@wxs.nl) 1998.
##        it's made under GPL ...:-))
##
##
############################################################################
## History
##
## 1.0 first start of the program
## 1.1 some changes from monty and after that
##     initial release in mysql 3.22.10 (nov 1998)
## 1.2 begin screen now in a loop + quit is using 0 instead of 9
##     after ideas of Paul DuBois.
## 1.2a Add Grant, References, Index and Alter privilege handling (Monty)
## 1.3 Applied patch provided by Martin Mokrejs <mmokrejs@natur.cuni.cz>
##     (General code cleanup, use the GRANT statement instead of updating
##     the privilege tables directly, added option to revoke privileges)
## 1.4 Remove option 6 which attempted to erroneously grant global privileges

#### TODO
#
# empty ... suggestions ... mail them to me ...

$version="1.4";

use DBI;
use Getopt::Long;
use strict;
use vars qw($dbh $sth $hostname $opt_user $opt_password $opt_help $opt_host
	    $opt_socket $opt_port $host $version);

my $sqlport = "";
my $sqlhost = "";
my $user = "";

$dbh=$host=$opt_user= $opt_password= $opt_help= $opt_host= $opt_socket= "";
$opt_port=0;

read_my_cnf();		# Read options from ~/.my.cnf

GetOptions("user=s","password=s","help","host=s","socket=s","port=i");

usage() if ($opt_help); # the help function

if ($opt_host eq '')
{
  $sqlhost = "localhost";
}
else
{
  $sqlhost = $opt_host;
}

# ask for a password if no password is set already
if ($opt_password eq '')
{
  system "stty -echo";
  print "Password for user $opt_user to connect to MariaDB: ";
  $opt_password = <STDIN>;
  chomp($opt_password);
  system "stty echo";
  print "\n";
}

# Using port argument with 'localhost' will cause an error
if ($sqlhost ne "localhost") {
  $sqlport = ":port=$opt_port";
}

# make the connection to MariaDB
$dbh= DBI->connect("DBI:mysql:mysql:host=$sqlhost$sqlport:mysql_socket=$opt_socket",$opt_user,$opt_password, {PrintError => 0}) ||
  die("Can't make a connection to the mysql server.\n The error: $DBI::errstr");

# the start of the program
&q1();
exit(0); # the end...

#####
# below all subroutines of the program
#####

###
# the beginning of the program
###
sub q1 { # first question ...
  my ($answer,$end);
  while (! $end) {
    print "#"x70;
    print "\n";
    print "## Welcome to the permission setter $version for MariaDB.\n";
    print "## made by Luuk de Boer\n";
    print "#"x70;
    print "\n";
    print "What would you like to do:\n";
    print "  1. Set password for an existing user.\n";
    print "  2. Create a database + user privilege for that database\n";
		print "     and host combination (user can only do SELECT)\n";
    print "  3. Create/append user privilege for an existing database\n";
		print "     and host combination (user can only do SELECT)\n";
    print "  4. Create/append broader user privileges for an existing\n";
		print "     database and host combination\n";
		print "     (user can do SELECT,INSERT,UPDATE,DELETE)\n";
    print "  5. Create/append quite extended user privileges for an\n";
		print "     existing database and host combination (user can do\n";
		print "     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,\n";
		print "     LOCK TABLES,CREATE TEMPORARY TABLES)\n";
    print "  6. Create/append full privileges for an existing database\n";
		print "     and host combination (user has FULL privilege)\n";
    print "  7. Remove all privileges for for an existing database and\n";
		print "     host combination.\n";
    print "     (user will have all permission fields set to N)\n";
    print "  0. exit this program\n";
    print "\nMake your choice [1,2,3,4,5,6,7,0]: ";
    while (<STDIN>) {
      $answer = $_;
      chomp($answer);
      if ($answer =~ /^[1234567]$/) {
        if ($answer == 1) {
	   setpwd();
        } elsif ($answer =~ /^[234567]$/) {
	   addall($answer);
	} else {
          print "Sorry, something went wrong. With such option number you should not get here.\n\n";
          $end = 1;
        }
      } elsif ($answer == 0) {
        print "We hope we can help you next time \n\n";
	$end = 1;
      } else {
        print "Your answer was $answer\n";
        print "and that's wrong .... Try again\n";
      }
      last;
    }
  }
}

###
# set a password for a user
###
sub setpwd
{
  my ($user,$pass,$host) = "";
  print "\n\nSetting a (new) password for a user.\n";

$user = user();
  $pass = newpass($user);
  $host = hosts($user);

print "#"x70;
  print "\n\n";
  print "That was it ... here is an overview of what you gave to me:\n";
  print "The username 		: $user\n";
#  print "The password		: $pass\n";
  print "The host		: $host\n";
  print "#"x70;
  print "\n\n";
  print "Are you pretty sure you would like to implement this [yes/no]: ";
  my $no = <STDIN>;
  chomp($no);
  if ($no =~ /n/i)
  {
    print "Okay .. that was it then ... See ya\n\n";
    return(0);
  }
  else
  {
    print "Okay ... let's go then ...\n\n";
  }
  $user = $dbh->quote($user);
  $host = $dbh->quote($host);
  if ($pass eq '')
  {
    $pass = "''";
  }
  else
  {
    $pass = "PASSWORD(". $dbh->quote($pass) . ")";
  }
  my $sth = $dbh->prepare("update user set Password=$pass where User = $user and Host = $host") || die $dbh->errstr;
  $sth->execute || die $dbh->errstr;
  $sth->finish;
  print "The password is set for user $user.\n\n";

}

###
# all things which will be added are done here
###
sub addall {
  my ($todo) = @_;
  my ($answer,$good,$db,$user,$pass,$host,$priv);

if ($todo == 2) {
    $db = newdatabase();
  } else {
    $db = database();
  }

$user = newuser();
  $pass = newpass("$user");
  $host = newhosts();

print "#"x70;
  print "\n\n";
  print "That was it ... here is an overview of what you gave to me:\n";
  print "The database name	: $db\n";
  print "The username 		: $user\n";
#  print "The password		: $pass\n";
  print "The host(s)		: $host\n";
  print "#"x70;
  print "\n\n";
  print "Are you pretty sure you would like to implement this [yes/no]: ";
  my $no = <STDIN>;
  chomp($no);
  if ($no =~ /n/i) {
    print "Okay .. that was it then ... See ya\n\n";
    return(0);
  } else {
    print "Okay ... let's go then ...\n\n";
  }

if ($todo == 2) {
    # create the database
    if ($db) {
    my $sth = $dbh->do("CREATE DATABASE $db") || $dbh->errstr;
    } else {
      print STDERR "What do you want? You wanted to create new database and add new user, right?\n";
      die "But then specify databasename, please\n";
  }
  }

if ( ( !$todo ) or not ( $todo =~ m/^[2-7]$/ ) ) {
    print STDERR "Sorry, select option $todo isn't known inside the program .. See ya\n";
    quit();
  }

my @hosts = split(/,/,$host);
  if (!$user) {
     die "username not specified: $user\n";
  }
  if (!$db) {
     die "databasename is not specified nor *\n";
  }
  foreach $host (@hosts) {
    # user privileges: SELECT
    if (($todo == 2) || ($todo == 3)) {
      $sth = $dbh->do("GRANT SELECT ON $db.* TO \'$user\'@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr;
    } elsif ($todo == 4) {
      # user privileges: SELECT,INSERT,UPDATE,DELETE
      $sth = $dbh->do("GRANT SELECT,INSERT,UPDATE,DELETE ON $db.* TO \'$user\'@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr;
    } elsif ($todo == 5) {
      # user privileges: SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES
      $sth = $dbh->do("GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,CREATE TEMPORARY TABLES ON $db.* TO \'$user\'@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr;
    } elsif ($todo == 6) {
       # all privileges
       $sth = $dbh->do("GRANT ALL ON $db.* TO \'$user\'\@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr;
    } elsif ($todo == 7) {
       # all privileges set to N
       $sth = $dbh->do("REVOKE ALL ON $db.* FROM \'$user\'\@\'$host\'") || die $dbh->errstr;
    }
    }
  print "Everything is inserted and mysql privileges have been reloaded.\n\n";
}

###
# ask for a new database name
###
sub newdatabase {
  my ($answer,$good,$db);
  print "\n\nWhich database would you like to add: ";
  while (<STDIN>) {
    $answer = $_;
    $good = 0;
    chomp($answer);
    if ($answer) {
      my $sth = $dbh->prepare("SHOW DATABASES") || die $dbh->errstr;
      $sth->execute || die $dbh->errstr;
      while (my @r = $sth->fetchrow_array) {
        if ($r[0] eq $answer) {
          print "\n\nSorry, this database name is already in use; try something else: ";
          $good = 1;
        }
      }
    } else {
      print "You must type something ...\nTry again: ";
      next;
    }
    last if ($good == 0);
  }
  $db = $answer;
  print "The new database $db will be created\n";
  return($db);
}

###
# select a database
###
sub database {
  my ($answer,$good,$db);
  print "\n\nWhich database from existing databases would you like to select: \n";
  print "You can choose from: \n";
  my $sth = $dbh->prepare("show databases") || die $dbh->errstr;
  $sth->execute || die $dbh->errstr;
  while (my @r = $sth->fetchrow_array) {
    print "  - $r[0] \n";
  }
  print "Which database will it be (case sensitive). Type * for any: \n";
  while (<STDIN>) {
    $answer = $_;
    $good = 0;
    chomp($answer);
    if ($answer) {
      if ($answer eq "*") {
        print "OK, the user entry will NOT be limited to any database";
        return("*");
      }
      my $sth = $dbh->prepare("show databases") || die $dbh->errstr;
      $sth->execute || die $dbh->errstr;
      while (my @r = $sth->fetchrow_array) {
        if ($r[0] eq $answer) {
          $good = 1;
          $db = $r[0];
          last;
        }
      }
    } else {
        print "Type either database name or * meaning any databasename. That means";
        print " any of those above but also any which will be created in future!";
        print " This option gives a user chance to operate on databse mysql, which";
        print " contains privilege settings. That is really risky!\n";
      next;
    }
    if ($good == 1) {
      last;
    } else {
      print "You must select one from the list.\nTry again: ";
      next;
    }
  }
  print "The database $db will be used.\n";
  return($db);
}

###
# ask for a new username
###
sub newuser
{
  my $user = "";
  my $answer = "";

print "\nWhat username is to be created: ";
  while(<STDIN>)
  {
    $answer = $_;
    chomp($answer);
    if ($answer)
    {
      $user = $answer;
    }
    else
    {
      print "You must type something ...\nTry again: ";
      next;
    }
    last;
  }
  print "Username = $user\n";
  return($user);
}

###
# ask for a user which is already in the user table
###
sub user
{
  my ($answer,$user);

print "\nFor which user do you want to specify a password: ";
  while(<STDIN>)
  {
    $answer = $_;
    chomp($answer);
    if ($answer)
    {
      my $sth = $dbh->prepare("select User from user where User = '$answer'") || die $dbh->errstr;
      $sth->execute || die $dbh->errstr;
      my @r = $sth->fetchrow_array;
      if ($r[0])
      {
        $user = $r[0];
      }
      else
      {
       print "Sorry, user $answer isn't known in the user table.\nTry again: ";
       next;
     }
    }
    else
    {
      print "You must type something ...\nTry again: ";
      next;
    }
    last;
  }
  print "Username = $user\n";
  return($user);
}

###
# ask for a new password
###
sub newpass
{
  my ($user) = @_;
  my ($pass,$answer,$good,$yes);

print "Would you like to set a password for $user [y/n]: ";
  $yes = <STDIN>;
  chomp($yes);
  if ($yes =~ /y/)
  {
    system "stty -echo";
    print "What password do you want to specify for $user: ";
    while(<STDIN>)
    {
      $answer = $_;
      chomp($answer);
      system "stty echo";
      print "\n";
      if ($answer)
      {
        system "stty -echo";
        print "Type the password again: ";
        my $second = <STDIN>;
        chomp($second);
        system "stty echo";
        print "\n";
        if ($answer ne $second)
        {
          print "Passwords aren't the same; we begin from scratch again.\n";
          system "stty -echo";
          print "Password please: ";
          next;
        }
        else
        {
          $pass = $answer;
        }
      }
      else
      {
        print "You must type something ...\nTry again: ";
        next;
      }
      last;
    }
#    print "The password for $user is $pass.\n";
  }
  else
  {
    print "We won't set a password so the user doesn't have to use it\n";
    $pass = "";
  }
  return($pass);
}

###
# ask for new hosts
###
sub newhosts
{
  my ($host,$answer,$good);

print "We now need to know from what host(s) the user will connect.\n";
  print "Keep in mind that % means 'from any host' ...\n";
  print "The host please: ";
  while(<STDIN>)
  {
    $answer = $_;
    chomp($answer);
    if ($answer)
    {
      $host .= ",$answer";
      print "Would you like to add another host [yes/no]: ";
      my $yes = <STDIN>;
      chomp($yes);
      if ($yes =~ /y/i)
      {
        print "Okay, give us the host please: ";
        next;
      }
      else
      {
        print "Okay we keep it with this ...\n";
      }
    }
    else
    {
      print "You must type something ...\nTry again: ";
      next;
    }
    last;
  }
  $host =~ s/^,//;
  print "The following host(s) will be used: $host.\n";
  return($host);
}

###
# ask for a host which is already in the user table
###
sub hosts
{
  my ($user) = @_;
  my ($answer,$good,$host);

print "We now need to know which host for $user we have to change.\n";
  print "Choose from the following hosts: \n";
  $user = $dbh->quote($user);
  my $sth = $dbh->prepare("select Host,User from user where User = $user") || die $dbh->errstr;
  $sth->execute || die $dbh->errstr;
  while (my @r = $sth->fetchrow_array)
  {
    print "  - $r[0] \n";
  }
  print "The host please (case sensitive): ";
  while(<STDIN>)
  {
    $answer = $_;
    chomp($answer);
    if ($answer)
    {
      $sth = $dbh->prepare("select Host,User from user where Host = '$answer' and User = $user") || die $dbh->errstr;
      $sth->execute || die $dbh->errstr;
      my @r = $sth->fetchrow_array;
      if ($r[0])
      {
        $host = $answer;
        last;
      }
      else
      {
        print "You have to select a host from the list ...\nTry again: ";
        next;
      }
    }
    else
    {
      print "You have to type something ...\nTry again: ";
      next;
    }
    last;
  }
  print "The following host will be used: $host.\n";
  return($host);
}

###
# a nice quit (first disconnect and then exit
###
sub quit
{
  $dbh->disconnect;
  exit(0);
}

###
# Read variables password, port and socket from .my.cnf under the client
# or perl groups
###

sub read_my_cnf
{
  open(TMP,$ENV{'HOME'} . "/.my.cnf") || return 1;
  while (<TMP>)
  {
    if (/^\[(client|perl)\]/i)
    {
      while ((defined($_=<TMP>)) && !/^\[\w+\]/)
      {
	print $_;
	if (/^host\s*=\s*(\S+)/i)
	{
	  $opt_host = $1;
	}
	elsif (/^user\s*=\s*(\S+)/i)
	{
	  $opt_user = $1;
	}
	elsif (/^password\s*=\s*(\S+)/i)
	{
	  $opt_password = $1;
	}
	elsif (/^port\s*=\s*(\S+)/i)
	{
	  $opt_port = $1;
	}
	elsif (/^socket\s*=\s*(\S+)/i)
	{
	  $opt_socket = $1;
	}
      }
    }
  }
  close(TMP);
}

###
# the help text
###
sub usage
{
  print <<EOL;
----------------------------------------------------------------------
                 The permission setter for MariaDB.
                      version: $version

made by: Luuk de Boer <luuk\@wxs.nl>
----------------------------------------------------------------------

The permission setter is a little program which can help you add users
or databases or change passwords in MariaDB. Keep in mind that we don't
check permissions which already been set in MariaDB. So if you can't
connect to MariaDB using the permission you just added, take a look at
the permissions which have already been set in MariaDB.

The permission setter first reads your .my.cnf file in your Home
directory if it exists.

Options for the permission setter:

--help		: print this help message and exit.

The options shown below are used for making the connection to the MariaDB
server. Keep in mind that the permissions for the user specified via
these options must be sufficient to add users / create databases / set
passwords.

--user		: is the username to connect with.
--password	: the password of the username.
--host		: the host to connect to.
--socket	: the socket to connect to.
--port		: the port number of the host to connect to.

If you don't give a password and no password is set in your .my.cnf
file, then the permission setter will ask for a password.

EOL
exit(0);
}

${this.title}

Code Editor : mysql_setpermission