Remote access MYSQL on a WD My Cloud Mirror

I have a WD My Cloud Mirror with a database i need to access remotely, so i need the IP of the router that keeps changing (the port forward is already done).  Is there any installed software i can use or perhaps is it possible to install a DynDNS client?
Paer ToernellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paer ToernellAuthor Commented:
I need the updater installed in the WD My Cloud Mirror, not in any other computer in the network if possible.
Davis McCarnOwnerCommented:
1)  If you are running MySQL server on the PC, you'll need remote access to the PC and the SQL pipe unless you want to risk corrupting the data.  You want access to the SQL server, not the data file.  Have you considered LogMeIn, TeamViewer, or SplashTop to simply access a PC at your place?  They all work by using an intermediary server to establish the connection so your ip changing becomes a non-issue.
2)  If you want a DynDNS setup, that usually gets done in the router; but, as a note my ip only changes about once per year, these days.
Paer ToernellAuthor Commented:
IP here (Thailand) change all the time, and for some reason my DynDNS account wont work in the router - and we have external user of our MYSQL database that we wont give access to our computers or the entire MyClod (unix) server.
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Davis McCarnOwnerCommented:
SQL databases; though, are manipulated by the SQL server which receives requests from the clients for retrieving and changing data.  All kinds of stuff ought to hit the fan if you try to access it directly from a second PC (Its just like having two people editing the same document simultaneously; one of the will get scr*wed!)
BTW; too, that external user would have the slowest access you can imagine even if the external access would work.
I think you should add a PC to the internal network; set it up to run the software for the database, clobber internet browsing on it, and use LogMeIn, TeamViewer, or Splashtop which would also solve the ip address problem.  Heck, if its a Pro version of Windows, you could even use RDP.
Paer ToernellAuthor Commented:
Programs written in Delphi the correct way can with ease and speed use the same MYSQL database simultaneously with either optimistic or pessimistic locking. Its a "fat" client and the speed is up to 200-500 times faster that a web solution, because its more the numer of access to the MySQL that takes time more than how much data is sent. Even a slow server like MyCloud can handle 50 users in the same table with ease, most of the operations is done locally in the client, not like in a Web browser where most operations requires communication with the server. When You access a table, you normally download at least a few hundred rows at the same time, and from there on its all in the client written in compiled code.
Paer ToernellAuthor Commented:
Delphi is 50 times faster than PHP, add to that the data is in the clients RAM, not in a server.
Davis McCarnOwnerCommented:
So the local clients access the data file directly?
Paer ToernellAuthor Commented:
If the table is small you fetch it all in one "pump", if its larger you fetch perhaps 500 rows or so, that you can finetune yourself. In most cases you wont notice that the database is on the other side of the world. When a record is updated, ether the server will check if its already changed by another user (Wikipedia style) OR as soon as you start edit it it will be locked and noone else can start edit it (Filemaker style).
Davis McCarnOwnerCommented:
We may have some misunderstanding or language issue; but, that wasn't my question.  If local users can navigate to the database file and double-click to open it (just like an Excel or Word item), the answer is yes.  If local users have to run your Delphi program which then accesses the SQL server's database, the answer is no.
If the answer is no, users of your Delphi program need to have access to the SQL pipe(s) and, even if we could get that opened to the internet, I'd be scared silly about the security risks.
Paer ToernellAuthor Commented:
Delphi have a toolbox called "Firedac" that is very good and can handle most SQL databases, but i'm used to Devarts UNIDAC that i think can handle even more databases including Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise.

ScrennDump
So if i write an application for PostgreSQL and want to make a Oracle, all i have to do is to is a 2 seconds change the provider in a visual component or i can let the user select engine and the same code can be used.
Davis McCarnOwnerCommented:
Sunsales,
You're still missing the point.  If you chose DB2 or DBF from your own picture AND the PC was configured to open the filetype with your application, a user could go to the data file using explorer and double-click it to open.  That, I have made work for clients in the past; but, until user number one is done using the file, nobody else would be able to open it.  They would get sharing violation errors.
Almost all SQL databases; though, have the database server open the file with the users making queries or changes using "pipes" that send or receive data to the SQL server process; only the server itself opens the file which allows for multiple users doing multiple things in the same database.
Paer ToernellAuthor Commented:
Yeas i probably miss the point. I have been using technology like this for more than 20 years, and it works. I'm nor familiar with how the technology used works, but its very fast and flexible. There is also encryption available.
Davis McCarnOwnerCommented:
Opening an SQL shared database is NOT like opening an Excel spreadsheet.  The SQL server has what are called "named pipes" which are then connected to by all of the clients.  Clients then make requests for data and the server handles those requests.
The server is the only PC to actually have the database file open.
It may be possible to open the ports in the router so that the SQL data is available to remote users with the appropriate client software installed; but, just as with the local users, they would be accessing the server not the data file.
My concern with that is that then, anyone with a decent knowledge of SQL would be able to access your data.
Paer ToernellAuthor Commented:
Yes, You do access the server with SQL commands, not the data. SQL commands is sent and data is received.
Davis McCarnOwnerCommented:
So you need remote access to the SQL server rather than the data file which is what I said from the getgo.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Paer ToernellAuthor Commented:
Correct
Davis McCarnOwnerCommented:
Then your entire question is not going to get what you want:
"I have a WD My Cloud Mirror with a database i need to access remotely"

From my first post:
Have you considered LogMeIn, TeamViewer, or SplashTop to simply access a PC at your place? (Any of them would solve your problem because the host PC registers itself with their service)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Cloud Services

From novice to tech pro — start learning today.