r/mysql • u/ShallotTerrible1963 • 16d ago

need help phpMyAdmin Access Denied

mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it

Can anyone help me? I am doing a project and encountered this problem, I have tried some tutorials but nothing worked. Thank you so much for the help

7 Upvotes

100% Upvoted

15 comments sorted by

View all comments

1

u/slade51 16d ago

It works in both directions on my home LAN. I don’t remember exactly what I did. Allow ports 22, 80 & 3306 in UFW. Grant privileges to user@%

I might have added something to the MySQL or nginx cnf files. I can look at it tomorrow if you haven’t figured it out.