× NETGEAR will be terminating ReadyCLOUD service by July 1st, 2023. For more details click here.
Orbi WiFi 7 RBE973
Reply

Want to Install MySQL on ReadyNas Pro

davidabroad
Aspirant

Want to Install MySQL on ReadyNas Pro

I would like to install MySQL on my ReadyNas Pro to be able to run a multiuser version of DBGallery (a photo organizing database).
Can anyone advise ho to do this?
I have been advised that I need to download the SQL software from MYSQL.com but have no idea which version to choose or how to install!

Hoping someone can help!

David
Message 1 of 8
sphardy1
Apprentice

Re: Want to Install MySQL on ReadyNas Pro

MySQL is pre-installed on your NAS - this post should help get you going
Message 2 of 8
davidabroad
Aspirant

Re: Want to Install MySQL on ReadyNas Pro

Hi andthanks for your reply and the link.

I have installed MYSQLON and that is working.
Also installed PHP and PHPAdmin and both are now working, although I did have to install Putty and go into mySQL on command line to be able to create a user and get into the PHPAdmin homepage.
So now the Admin program is running - however any program external to the server (in other words running on my connected Windows PC) such as MySQLAdmin or DBGallery cannot connect to the server, even using the exact same username and password as that I use to get into phpAdmin!

Any help or pointers would be greatly appreciated!

Thanks
Regards
David
Message 3 of 8
sphardy1
Apprentice

Re: Want to Install MySQL on ReadyNas Pro

By default the server is setup to only accept connections from applications running on the server itself - a standard security option

You'll have to edit /etc/mysql/my.cnf to alter this behaviour. Or install DBGallery on the NAS
Message 4 of 8
davidabroad
Aspirant

Re: Want to Install MySQL on ReadyNas Pro

thanks for the info.

I am new to this so please bear with me .............

Looking at a previous post of yours back in May (that was in relation to connecting to mySQL on the Duo), you mention that a bind address command needs to be added.
--bind-address='0.0.0.0'

Is this to be added to the my.cnf file you mention before?
If so should it replace the existing line bind-address = 127.0.0.1?

Or does it go elsewhere?

Thanks!
Message 5 of 8
sphardy1
Apprentice

Re: Want to Install MySQL on ReadyNas Pro

Yes - add to my.cnf , replacing the other line. That ensures mysql is listening to both Ethernet ports

Also check that the setting --skip-networking is NOT set as that disables mysql from being accessed via tcpip
Message 6 of 8
davidabroad
Aspirant

Re: Want to Install MySQL on ReadyNas Pro

thanks for this.

I had been struggling for more than a week with this, but after following your instruction all is connected!

David
Message 7 of 8
kpokora
Aspirant

Re: Want to Install MySQL on ReadyNas Pro

Hello,

I have similar problem on my NasPro Duo, i know that i have to modify my.cnf file, but where i can find this file ? When i borwsing my NAS resources as an admin user i can;t find any addons files.
Message 8 of 8
Top Contributors
Discussion stats
  • 7 replies
  • 9401 views
  • 0 kudos
  • 3 in conversation
Announcements