NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
get data from phpmyadmin in local network on netgear readynas 212
I have successfuly set up mysql and and phpmyadmin, i am able to access it from the web browser using the ip of the nas, but if i want to query the data from my desktop using mysqldb(in python) i am not able to connect to it, any idea if i should open any ports or what,
i am trying to connect it by using
host = ipaddress
port = 7082
user = root
password = ""
any suggession as how to get this working?
10 Replies
Replies have been turned off for this discussion
Hi rigatron,
Welcome to the Community!
There might be a local config that blocks the connections from outside the NAS. This would require a config change on the backend via SSH. If you are comfortable with Linux you can access the NAS via SSH then edit the config for the bind-address. It probably says bind-address=127.0.0.1, so you need to change it to 0.0.0.0 instead.
You may check this link for reference. Just ignore the iptables one, just follow the editing of the config for the bind address.
Regards,
hi john , i am not that familar with linux but i did some digging and i was able to do the changes and even after restarting the mysql services, i was not able to connect, this is the snapshot of my config file , and when i try to query with
db = MySQLdb.connect(host="192.168.1.30", user="root", passwd="", db="rigatron_db", port=7082)
i get
_mysql_exceptions.OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0")You are trying to connect on 7082, but it looks like the NAS is set up to use 3306.
Did you try connecting on port 3306?
Hi rigatron,
We’d greatly appreciate hearing your feedback letting us know if the information we provided has helped resolve your issue or if you need further assistance.
If your issue is now resolved, we encourage you to mark the appropriate reply as the “Accept as Solution” or post what resolved it and mark it as solution so others can be confident in benefiting from the solution.
The NETGEAR community looks forward to hearing from you and being a helpful resource in the future!
Regards,
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
