Skip to content

Instantly share code, notes, and snippets.

@ahmeti

ahmeti/UbuntuMysql1.sh

Created December 18, 2018 14:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ahmeti/f3af0eb9eb0a5e21c704ae1e8f3e1c67 to your computer and use it in GitHub Desktop.
Save ahmeti/f3af0eb9eb0a5e21c704ae1e8f3e1c67 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
UbuntuMysql1.sh
$ sudo ufw status
Status: active
To Action From
-- ------ ----
22 LIMIT Anywhere
443 ALLOW Anywhere
80 ALLOW Anywhere
22 (v6) LIMIT Anywhere (v6)
443 (v6) ALLOW Anywhere (v6)
80 (v6) ALLOW Anywhere (v6)
Raw
UbuntuMysql2.sh
sudo ufw allow 3306
sudo service ufw restart
Raw
UbuntuMysql3.sh
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Raw
UbuntuMysql4.sh
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
Raw
UbuntuMysql5.sh
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
Raw
UbuntuMysql6.sql
CREATE USER 'kullanici_adi'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'kullanici_adi'@'%' IDENTIFIED BY 'kullanici_sifre';
Raw
UbuntuMysql7.sh
sudo service mysql restart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment