MySQL Forums
Forum List  »  Install & Repo

Re: MySql on LAN Server
Posted by: Peter Brawley
Date: March 19, 2020 09:48PM

You're now running MySQL server on one workstation, and running Crystal Reports also on that workstation. Apart from CR, what client software do you use to interact with MySQL, WorkBench, or what?

You want to be able to access that MySQL instance yourself from outside the lan, also run Crystal Reports against the server from outside the lan? Perhaps you also want others to have such access?

MySQL server will need some settings changes to make it available to the outside world while keeping it secure. Does your organisation have domain names? Is the lan yours, or is run by a company you work for? If the latter, it's a job for their IT staff. If you need to do it yourself, you'll need to harden the server (eg https://www.techrepublic.com/article/how-to-harden-mysql-security-with-a-single-command/), define remote users and their privileges, set up SSL (eg https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench), etc. Big job.

Options: ReplyQuote


Subject
Written By
Posted
March 19, 2020 06:23PM
March 19, 2020 06:34PM
March 19, 2020 07:16PM
Re: MySql on LAN Server
March 19, 2020 09:48PM
March 19, 2020 10:15PM
March 19, 2020 11:29PM
March 22, 2020 06:51PM
March 22, 2020 07:48PM
March 19, 2020 07:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.