<div dir="ltr">thanks tony </div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div>Pau Marc Muñoz Torres<br></div>skype: pau_marc<br><div><div><a href="http://www.linkedin.com/in/paumarc" target="_blank">http://www.linkedin.com/in/paumarc</a><br><a href="http://www.researchgate.net/profile/Pau_Marc_Torres3/info/" target="_blank">http://www.researchgate.net/profile/Pau_Marc_Torres3/info/</a><br><br></div></div></div></div></div>
<br><div class="gmail_quote">2015-04-30 14:18 GMT+02:00 Tony Travis <span dir="ltr"><<a href="mailto:tony.travis@minke-informatics.co.uk" target="_blank">tony.travis@minke-informatics.co.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 30/04/15 13:04, Pau Marc Muñoz Torres wrote:<br>
> GRANT ALL ON *.* TO myuser@'remote_ip' IDENTIFIED BY 'my_password';<br>
<br>
</span>Hi, Pau.<br>
<br>
I'm not sure "privileges" is optional in a GRANT - I would have used:<br>
<br>
> grant all privileges on *.* to 'root'@'remote_ip' with grant option;<br>
<br>
However, I think it is a BIG security hole to expose MySQL on the public<br>
Internet - Please beware of doing that :-(<br>
<br>
If you're locked out, try:<br>
<br>
> stop mysql<br>
> mysqld_safe --skip-grant-tables&<br>
> mysql<br>
> use mysql;<br>
> update user set password=PASSWORD("<new password>")where User='root';<br>
> flush privileges;<br>
> quit<br>
<br>
That's got me out of quite a few dark holes in the past :-)<br>
<br>
HTH,<br>
<br>
Tony.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Minke Informatics Limited, Registered in Scotland - Company No. SC419028<br>
Registered Office: 3 Donview, Bridge of Alford, AB33 8QJ, Scotland (UK)<br>
tel. <a href="tel:%2B44%280%2919755%2063548" value="+441975563548">+44(0)19755 63548</a> <a href="http://minke-informatics.co.uk" target="_blank">http://minke-informatics.co.uk</a><br>
mob. <a href="tel:%2B44%280%297985%20078324" value="+447985078324">+44(0)7985 078324</a> mailto:<a href="mailto:tony.travis@minke-informatics.co.uk">tony.travis@minke-informatics.co.uk</a><br>
_______________________________________________<br>
Bio-Linux mailing list<br>
<a href="mailto:Bio-Linux@nebclists.nerc.ac.uk">Bio-Linux@nebclists.nerc.ac.uk</a><br>
<a href="http://nebclists.nerc.ac.uk/mailman/listinfo/bio-linux" target="_blank">http://nebclists.nerc.ac.uk/mailman/listinfo/bio-linux</a><br>
</font></span></blockquote></div><br></div>