First of all. I ran a mysql server before of a dell laptop using Ubuntu. Now I have a Synology NAS that is on 24/7. I think it is beter to run my mysql server there. So I installed it and everything went well till I made a second account (I logged in with my root and created a new phpmyadmin user account). I tried to log in and it gave this message.
Now I have my port 3306 (TCP) opened to my NAS. But if I look at the message it says 'localhost', so no portforwarding. I don't know how to solve this or what to do. Do you have any idea?
1 1 1 silver badge asked Jun 16, 2017 at 16:09 Douwe de Vries Douwe de Vries 48 8 8 bronze badgesWhen you created the user, what host value did you use? Since phpMyAdmin is using the MySQL socket connection, the user you've created needs to say localhost (that's indicated by the 'localhost', instead of doing it over TCP/IP networking which would show 127.0.0.1 or a full hostname/IP address). MySQL treats 127.0.0.1 or '%' as being different from localhost. You'll need to edit the user to change the host to 'Local' (or 'localhost', depending on which version you have) as the wildcard % only applies to TCP/IP connections, not socket connections.
Since phpMyAdmin is running locally on your NAS, you don't need to expose port 3306 to the network, all you need is to be able to get to the web page (typically port 80) from the rest of your network. You'd need port 3306 if you were connecting directly to MySQL, but that's not needed here.
answered Jun 17, 2017 at 18:05 Isaac Bennetch Isaac Bennetch 12.3k 2 2 gold badges 36 36 silver badges 46 46 bronze badgesTo subscribe to this RSS feed, copy and paste this URL into your RSS reader.
Site design / logo © 2024 Stack Exchange Inc; user contributions licensed under CC BY-SA . rev 2024.9.2.14718