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 ...
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?
when i try connecting it to 3306 i get
1130, "Host 'DESKTOP-FM6K23E' is not allowed to connect to this MySQL server"
in my browser only when i put http://192.168.1.30:7082 i am able to access the phpmyadmin page
so that why i kept the port as 7082, should i change it in the my.cnf file?
rigatron wrote:1130, "Host 'DESKTOP-FM6K23E' is not allowed to connect to this MySQL server"
That message is coming from the sql server itself - so you are reaching the server on port 3306.
There is a solution posted here: https://www.thegeekstuff.com/2010/08/allow-mysql-client-connection/ (among other places).
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
