You were asked to install and configure MySQL server on a Windows Server machine and need to provide remote access to it for your group to configure and manager when you are not around 🙂
When you have completed the installation of the MySQL into the server. You can run this command:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
Username – is the account you wish to create or use.
IP – is the physical IP address of the computer you wish to grant remote access to. [note: if you enter ‘%’ instead of an IP address, that user will be able to remote into MySQL from any computer]
Password – is the password you wish to create if it’s a new user or the existing password of an existing account.
Once the command is sent and completed you must run this command afterward: