Connect mysql from Remote machine

In mysql user need permission based on IP to connect mysql server. In default installation of mysql it doesn’t permit root to connect from remote machine Using the following command, we set permission for connecting server from remote machines shell> mysql –user=root mysql mysql>GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY ‘some_pass’ WITH GRANT [...] Read more »