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 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).
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)
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
