SHELL

install mysql on debian

first, update the packages: apt update and apt install gnupg

Next, download MySQL using wget command:
wget https://dev.mysql.com/get/mysql-apt-config_x.x.x-x_all.deb - x.x.x-x is the version.
then
sudo dpkg -i mysql-apt-config_x.x.x-x_all.deb
Update the apt repository:
apt-get update

Install the MySQL Server using the command:
sudo apt-get install mysql-community-server

Now, check the service status with systemctl:
systemctl status mysql.service

Next, run the command as a root user to safely configure the SQL service:
mysql_secure_installation

If you want to allow remote access, edit the file «mysqld.conf» in etc/:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

At the end of the file, add the option "bind_address" with the value of localhost:
bind-address=127.0.0.1

Save the file and restart the service with systemctl:
systemctl restart mysql

 remember to open the MySQL port (it will be good to specify the standard MySQL port). If you use ufw:
ufw allow $yoursqlport

where instead of yoursqlport write your MySQL port.

If you use iptables:
iptables –A INPUT –p tcp –dport $yoursqlport –j ACCEPT