How do I enable remote access to MySQL?
• Open a DOS command prompt on the Scrutinizer server. • Run the following command from the ~\SCRUTINIZER\mysql\bin directory: mysql -u root –password= • A mysql> prompt should be displayed. • To create a remote user account with root privileges, run the following commands: GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@’IP’ IDENTIFIED BY ‘PASSWORD’; ‘USERNAME’ is the username to be created. ‘IP’ is the public IP address of the remote connection. ‘PASSWORD’ is the password to be assigned for this username. (IP can be replaced with % to allow this user to logon from any host or IP) mysql> FLUSH PRIVILEGES; mysql> exit; Click here for more information on limiting MySQL user accounts.
