Re: Install MySQL SERVER

[Ibrahim Ali]

Hi Mark,

thanks for your answer.

when i tried to use the noinstall package it gave me problems as dlls were missing, i used the windows installer and installed mysql on windows server 2019, using full and dedicated server mode.


through the workbench networking configurations I added the bind address string and I managed to reach it through another client, trying to connect via command line on ubuntu using mysql -u USER -h MYSQL HOST -p and I tried to install nextcloud on a other client using the ip of the machine where mysql is configured as hostname.

I have 2 questions for you:


on machine 1 with ip *. *. *. 54 ce the mysql server manageable with workbench.


on machine 2 with ip *. *. *. 65 c and phpmyadmin to manage the server via web.

on machine 2 if I go to the phpmyadmin config.inc.php file and enter the ip of machine 1 as the server address, I can reach it via http: // machine2 / phpmyadmin, then the server is reachable only in lan.


my intention was to have nextcloud on lan and Guacamole on AWS or AZURE, can you tell me how to make the server reachable from the outside via a domain that redirects to the server on port 3306 or via the router's public ip?

in addition I wanted to know if it is possible to specify the size of the database for example to allow the guest user access to the test01 database with 1GB capacity and if you have any guide or advice to apply to the configuration to make it perform as on linux.

thanks