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 ...
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).
Guys thanks for helping me out ,but i am a novice in linux and i was messing around with the mysql and now i am not able to login ,
how do i reset and start it from the begining ?
should i factory reset the nas or what(i dont want to delete my data in the drives)
I think you'll need to back up the data and do the factory reset, especially if you can no longer log in with ssh.
I suggest setting up a linux system on another device (perhaps a VM or a dual boot on a PC), and learn about linux that way.
There is a ReadyNAS VM that you can also use to test installs - though it is x86, and not ARM, it still might be useful to you. https://github.com/ReadyNAS/sdk/wiki/Setup-ReadyNAS-OS-on-VirtualBox
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
