<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d33142127\x26blogName\x3dfishyweb\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://fishyweb.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://fishyweb.blogspot.com/\x26vt\x3d4851815010354999608', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

a simple solution for a frequent - first time mysql issue Saturday, March 31, 2007 |

whenever a new mysql server is setup on a new machine, when i try to connect to it from my desktop using the mysql querybrowser, i get into a frequent 'host xxx.xxx.xxx.xxx is not allowed to connect to this mysql server'!

The normal way my sysadmins would fix this problem is to restart the mysql server with '--skip-grant-tables' option.

Somehow i am not very comfortable this way... and today when none of my sysadmins are around and i faced this problem, i was left to my own to probe for the solution.

:) and here it is, a more appropriate, systematic and logical way of getting rid of this error.

GRANT ALL PRIVILEGES ON *.* TO 'user'@'xxx.xxx.%' IDENTIFIED BY 'mypassword';

and voila, there it goes.

Logging from *any* system as the given user with the given password from within the specified range of internal subnet goes through smooth.

Moral : looking out for a solution sincerely and getting to the bottom of the problem, works always!