Connect mysql from Remote machine
About author I am Java professional, working on java and Portal technoglies from last 5 years. I start techartifact with my some friends to share our knowledge and tips with world. Read more from this authorIn 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 OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@”%” IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;
