https://tecadmin.net/install-mysql-server-on-debian9-stretch/
sudo apt update
sudo apt upgrade
wget http://repo.mysql.com/mysql-apt-config_0.8.13-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb
sudo apt update
sudo apt install mysql-server
USE mysql;
CREATE USER ‘mbc‘@’localhost’ IDENTIFIED BY ‘mbc’;
GRANT ALL PRIVILEGES ON . TO ‘mbc‘@’localhost’;
UPDATE user SET plugin=’auth_socket’ WHERE User=’mbc’;
FLUSH PRIVILEGES;
exit;
mysql> set @max_allowed_packet=1048576;
mysql> set @max_allowed_packet=6410241024;
6410241024
67108864
root@xps:/home/mbc# mysql –user=root -pNNNN lndb
mysql>CREATE USER ‘ln_admin‘@’%’ IDENTIFIED BY ‘welcome’;
mysql>GRANT ALL PRIVILEGES ON . TO ‘ln_admin‘@’%’ WITH GRANT OPTION;