Versions Compared

Old Version 11

changes.mady.by.user jtel Support

Saved on

compared with

New Version 12

changes.mady.by.user jtel Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Content imported from a Scroll Translations translation file.

...

Sv translation
languagede

Status
colourRed
titleTHIS PAGE IS ONLY AVAILABLE IN ENGLISH

Sv translation
languagefr

Code Block
languagebash
wget https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb dpkg -i mysql-apt-config_0.8.16-1_all.deb
Code Block
languagebash
rm -f mysql-apt-config_0.8.16-1_all.deb
Code Block
languagebash
apt-get update apt-get -y install mysql-server

Translations Ignore


Code Block
languagebash
ufw allow 3306/tcp


Translations Ignore


Code Block
languagebash
wget -P /etc/mysql/mysql.conf.d http://cdn.jtel.de/downloads/configs/jtel-enhanced-8-deb.cnf


Translations Ignore


Code Block
languagebash
# For 4 GB RAM innodb_buffer_pool_size = 2048M # For 8 GB RAM innodb_buffer_pool_size = 5120M   # For 12 GB RAM innodb_buffer_pool_size = 8192M   # For 16 GB RAM innodb_buffer_pool_size = 12288M ... # From 16 GB simply take 3/4 of the RAM


Translations Ignore


Code Block
languagebash
title
systemctl restart mysql


Translations Ignore


Code Block
languagebash
mysql -u root -p<password> -v -e"CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '<password>'" mysql -u root -p<password> -v -e"GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION" mysql -u root -p<password> -v -e"FLUSH PRIVILEGES"


Translations Ignore


Code Block
languagebash
cp /home/jtel/shared/JTELCarrierPortal/Libraries/jtel_udf_udpsend/jtel_udf_udpsend.so /usr/lib/mysql/plugin/ chown root:root /usr/lib/mysql/plugin/jtel_udf_udpsend.so chmod 644 /usr/lib/mysql/plugin/jtel_udf_udpsend.so


Translations Ignore


Code Block
languagebash
cp /home/jtel/shared/JTELCarrierPortal/Libraries/jtel_udf_udpsend/dummy/jtel_udf_udpsend.so /usr/lib/mysql/plugin/ chown root:root /usr/lib/mysql/plugin/jtel_udf_udpsend.so chmod 644 /usr/lib/mysql/plugin/jtel_udf_udpsend.so


Translations Ignore


Code Block
languagebash
mysql -u root -p<password> -v -e"DROP FUNCTION IF EXISTS udpsend" mysql -u root -p<password> -v -e"CREATE FUNCTION udpsend RETURNS STRING SONAME 'jtel_udf_udpsend.so'"


Note
title