I am trying to connect to MySQL Server from my local PC using MySQL Workbench (Connection Method: Standard TCP/IP). Server
Server: Ubuntu 20.04.2 LTS
Changing the IP Address
# 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
mysqlx-bind-address = 0.0.0.0
Port Status
netstat -antp | grep 3306
tcp 0 0 0.0.0.0:33060 0.0.0.0:* LISTEN 690/mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 690/mysqld
firewall
ufw status
Status: active
To Action From
-- ------ ----
3306 ALLOW 0.0.0.0
3306 ALLOW Anywhere
22/tcp ALLOW Anywhere
3306 (v6) ALLOW Anywhere (v6)
22/tcp (v6) ALLOW Anywhere (v6)
The Error Message
Failed to Connnect ot MySQL at IP:3306 with user UserName
Host'PC IP' is not allowed to connect to this MySQL Serve
I really appreciate if you could help me. Thank you
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi @MFAlghanmi,
I’ll recommend trying to allow your IP address on your Droplet.
To allow all network connections that originate from a specific IP address, run the following command, replacing the highlighted IP address with the IP address that you want to allow access:
sudo ufw allow from 203.0.113.101
Output
Rule added
If you run sudo ufw status now, you’ll see output similar to this, showing the word ALLOW next to the IP address you just added.
Output
Status: active
To Action From
-- ------ ----
...
Anywhere ALLOW 203.0.113.101
You can also allow connections from a whole subnet by providing the corresponding subnet mask for a host, such as 203.0.113.0/24.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
