Public » Linux

apt-get install -y mariadb-server; \
mysql_secure_installation; \
echo "update user set host='%',user='jsql',plugin='' where user='root'; flush privileges;" | mysql -u root -p mysql; \
mkdir -p /etc/gen/firewall/host:`ip ad|grep inet|grep eth0|${SERVER_IP}/3306:tcp:mysqld; \
echo -e "195.54.47.33\t\t# JustNet VPN" >> /etc/gen/firewall/host:`ip ad|grep inet|grep eth0|${SERVER_IP}/3306:tcp:mysqld/allow; \
/etc/init.d/ip_firewall restart; \
rsync -avz -e ssh jadmin@deploy.justnet.pl:storage/baseconfig/mariadb/ /; \
sed -i "s|bind-address            = 127.0.0.1|bind-address            = ${SERVER_IP}|" /etc/mysql/mariadb.conf.d/50-server.cnf; \
systemctl restart mariadb;

PHPMyAdmin

$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'xxx.xxx.xxx.xxx';
$cfg['Servers'][$i]['verbose'] = 'Nazwa_Serwera';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;