instalação do phpipam

eduardo
7 Nov 2020

depois de criado o contentor atualizamos o debian:
apt update && apt upgrade -y

apt install mariadb-server mariadb-client -y
mysql_secure_installation

CREATE DATABASE phpipam;
GRANT ALL ON phpipam.* TO phpipam@localhost IDENTIFIED BY 'phpipamadmin';
FLUSH PRIVILEGES;
QUIT;

apt -y install php php-{mysql,curl,gd,intl,pear,imap,memcache,pspell,tidy,xmlrpc,mbstring,gmp,json,xml,fpm}

apt -y install git

mostrar grants de todos os utilizadores dum SGBD a partir da linha de comandos

eduardo
2 Nov 2020

mysql --silent --skip-column-names --execute "select concat('\'',User,'\'@\'',Host,'\'') as User from mysql.user" | sort | \
while read u
do echo "-- $u"; mysql --silent --skip-column-names --execute "show grants for $u" | sed 's/$/;/'
done
https://dba.stackexchange.com/questions/23265/mysql-show-grants-for-all…

Subscrever