A question can only have one accepted answer. Are you sure you want to replace the current answer with this one?
You previously marked this answer as accepted. Are you sure you want to unaccept it?
Write for DigitalOcean
You get paid, we donate to tech non-profits.
Find and meet other developers in your city.
Contribute to Open Source
Hi i am trying to connect with my mysql server running on centos 7
But its saying: Acces denied for user data@myip. and i can’t connect to root either.
please help me?
Add comments here to get more clarity or context around a question. To answer a question, use the “Answer” field below.
I fixed it using a query:
update user set host=’%’ where host=‘localhost’;
You can type !ref in this text area to quickly search our full set of tutorials, documentation &
marketplace offerings and insert the link!
I've noticed that I have a lot of sleeping MySQL processes. I tried killing them one by one but there are too many to do so. Does anyone know if there is an easier way to kill all sleeping processes at once?
I am relatively new to UFW and iptables.
I need the following port forwarding to be permanent:
iptables -A INPUT -i eth0 -p tcp --dport 80 -j ACCEPT
iptables -A INPUT -i eth0 -p tcp --dport 8080 -j ACCEPT
iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8080
iptables -A INPUT -i eth0 -p tcp --dport 443 -j ACCEPT
iptables -A INPUT -i eth0 -p tcp --dport 8443 -j ACCEPT
iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 443 -j REDIRECT --to-port 8443
I have enabled UFW and made settings in there as well.
When rebooting the UFW settings remain but the iptables settings disappear.
How do I make them permanent? Preferably via UFW - if possible.
I have been trying to fix issues with Reverse Dns. I'm running VirtualMin on CentOS 7.
I have renamed my droplet to hostname.com (soundstroke.ng) i don't know what else to do i have followed so many tutorials on this but doesn't work.
Please what should i do?
I turned off my droplet and deleted the domain which were added in the droplet.
How come after doing all these my domain is still active and shows the website?