ts3 z bazą danych jak zrobić

apt update
apt upgrade -y

apt install nano ufw htop curl wget fontconfig-config fonts-dejavu-core \
libfontconfig1 screen libgd3 libjbig0 liblua5.1-0 libperl5* libtiff5 libxpm4 \
libxslt1.1 libpython-stdlib libpython2.7-minimal libpython2.7-stdlib zip \
python-minimal python2.7 python2.7-minimal fcgiwrap ssl-cert libglib2.0-0 \
x11vnc xvfb libxcursor1 ca-certificates bzip2 python libossp-uuid16 unzip sudo -y

wget http://kompilacje.linuxiarz.pl/Ubuntu_16.04_LTS/nginx-1.12.0-linuxiarz.pl-%5Bopenssl-1.1.0e%5D/nginx-common_1.12.0-linuxiarz.pl_all.deb

wget http://kompilacje.linuxiarz.pl/Ubuntu_16.04_LTS/nginx-1.12.0-linuxiarz.pl-%5Bopenssl-1.1.0e%5D/nginx-doc_1.12.0-linuxiarz.pl_all.deb

wget http://kompilacje.linuxiarz.pl/Ubuntu_16.04_LTS/nginx-1.12.0-linuxiarz.pl-%5Bopenssl-1.1.0e%5D/nginx-extras_1.12.0-linuxiarz.pl_amd64.deb

wget http://kompilacje.linuxiarz.pl/Ubuntu_16.04_LTS/nginx-1.12.0-linuxiarz.pl-%5Bopenssl-1.1.0e%5D/nginx_1.12.0-linuxiarz.pl_all.deb

dpkg -i nginx-*.deb

systemctl stop nginx.service

apt-get -y install php7.0-fpm php7.0-mysql php7.0-curl php7.0-gd php7.0-intl \
php7.0-pspell php7.0-mbstring php-gettext php-pear php-imagick php7.0-imap php7.0-mcrypt

cd /opt/; wget https://files.phpmyadmin.net/phpMyAdmin/4.7.0/phpMyAdmin-4.7.0-all-languages.zip

unzip php*
mv phpMyAdmin-4.7.0-all-languages pma

mkdir -p /var/lib/php/session

chmod 4777 /var/lib/php/session

rm STABLE*

rm -rf /etc/nginx/conf.d/*

wget http://pliki.linuxiarz.pl/05-2017/pma.conf -O /etc/nginx/conf.d/pma.conf

systemctl start nginx.service

apt install mariadb-server mariadb-client -y

service mysql start

mysql_secure_installation
i potem zaznaczyc zeby root mógł sie ogowac czyli ze no

echo "update user set plugin='' where User='root'; flush privileges;" | mysql --defaults-file=/etc/mysql/debian.cnf mysql

adduser teamspeak3 --disabled-login -q

su teamspeak3
cd $HOME
wget http://dl.4players.de/ts/releases/3.5.0/teamspeak3-server_linux_amd64-3.5.0.tar.bz2

tar xvf teamspeak3-server_linux_amd64-3.5.0.tar.bz2
rm teamspeak3-server_linux_amd64-3.5.0.tar.bz2
mv /home/teamspeak3/teamspeak3-server_linux_amd64 /home/teamspeak3/server/
mysql -u root -p

CREATE DATABASE teamspeak3;
CREATE USER 'teamspeak3'@'localhost' IDENTIFIED BY 'ZMIEN_HASŁO';
GRANT ALL PRIVILEGES ON teamspeak3.* TO teamspeak3@localhost IDENTIFIED BY 'ZMIEN_HASŁO';
quit

cd /home/teamspeak3/server

sudo ln -s /home/teamspeak3/server/redist/libmariadb.so.2 /lib/x86_64-linux-gnu/libmariadb.so.2

cp redist/libmariadb.so.2 ./

touch /home/teamspeak3/server/ts3server.ini
nano /home/teamspeak3/server/ts3server.ini

machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
liscensepath=
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_mariadb
dbpluginparameter=ts3db_mariadb.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mariadb/
dblogkeepdays=90
logpath=logs
logquerycommands=0
dbclientkeepdays=30

touch /home/teamspeak3/server/ts3db_mariadb.ini
nano /home/teamspeak3/server/ts3db_mariadb.ini

[config]
host=localhost
port=3306
username=teamspeak3
password=RE7TMzug97o2SaD6 ## TWOJE HASŁO !!
database=teamspeak3
socket=/var/run/mysqld/mysqld.sock

cd /home/teamspeak3/server
ldd libts3db_mariadb.so

./ts3server