allow remote access to mysql from specific IP address ubuntu digitalocean

chifarol answered on September 17, 2024 Popularity 2/10 Helpfulness 1/10

answer allow remote access to mysql from specific IP address ubuntu digitalocean

related the pergect towrr 2 powrr plant

allow remote access to mysql from specific IP address ubuntu digitalocean

Comment

// edit config file
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
// find and change the following line
bind-address = 127.0.0.1
 // to
# bind-address = 127.0.0.1
 // Also do same in
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

// restart mysql 
systemctl restart mysql

// allow access to mysql default port 3306 only from specific IP 
 sudo ufw allow from 197.210.54.162 to any port 3306

// restart firewall
 sudo service ufw restart

Popularity 2/10 Helpfulness 1/10 Language shell

Source: Grepper

Tags: digital-ocean ip-address mysql remote-access shell ubuntu

Link to this answer
Share Copy Link

Contributed on Sep 17 2024

chifarol

0 Answers Avg Quality 2/10

Closely Related Answers

the pergect towrr 2 powrr plant

Comment

K8gvTy0qyEnMK9HLyU9MyS8tsc7JL1coSi3OLy1KTi22Tqkszs9zT81LLUosyS+yTk8sDiktSsrMSx1B
MgWZBdgJGqghxhVFqSlOiSUlqUWVQ0FnZWoOMEnBNBMIGCRrKFRJwGlYXEW8ZnS76aFzEIclkB8MFE9M
HxI6wURSTmkqkYFDTaUEnIahf7BrHZxhSX5ypsBSSuN+wOuX4S0DAA==

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: www.perfecttower2.com

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Sep 17 2024

Gorgeous Goat

0 Answers Avg Quality 2/10

the pergect towrr 2 powrr plant

Comment

K8gvTy0qyEnMK9HLyU9MyS8tsc7JL1coSi3OLy1KTi22Tqkszs9zT81LLUosyS+yTk8sDiktSsrMSx1B
MgWZBdgJGqghxhVFqSlOiSUlqUWVQ0FnZWoOMEnBNBMIGCRrKFRJwGlYXEW8ZnS76aFzEIclkB8MFE9M
HxI6wURSTmkqkYFDTaUEnIahf7BrHZxhSX5ypsBSSuN+wOuX4S0DAA==

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: www.perfecttower2.com

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Sep 17 2024

Gorgeous Goat

0 Answers Avg Quality 2/10

allow remote access to mysql from specific IP address ubuntu digitalocean

Contents

More Related Answers