[Bio-Linux] problems with mysql

Pau Marc Muñoz Torres paumarc at gmail.com
Thu Apr 30 08:28:41 EDT 2015


thanks tony

Pau Marc Muñoz Torres
skype: pau_marc
http://www.linkedin.com/in/paumarc
http://www.researchgate.net/profile/Pau_Marc_Torres3/info/


2015-04-30 14:18 GMT+02:00 Tony Travis <tony.travis at minke-informatics.co.uk>
:

> On 30/04/15 13:04, Pau Marc Muñoz Torres wrote:
> > GRANT ALL ON *.* TO myuser@'remote_ip' IDENTIFIED BY 'my_password';
>
> Hi, Pau.
>
> I'm not sure "privileges" is optional in a GRANT - I would have used:
>
> > grant all privileges on *.* to 'root'@'remote_ip' with grant option;
>
> However, I think it is a BIG security hole to expose MySQL on the public
> Internet - Please beware of doing that :-(
>
> If you're locked out, try:
>
> > stop mysql
> > mysqld_safe --skip-grant-tables&
> > mysql
> > use mysql;
> > update user set password=PASSWORD("<new password>")where User='root';
> > flush privileges;
> > quit
>
> That's got me out of quite a few dark holes in the past :-)
>
> HTH,
>
>   Tony.
>
> --
> Minke Informatics Limited, Registered in Scotland - Company No. SC419028
> Registered Office: 3 Donview, Bridge of Alford, AB33 8QJ, Scotland (UK)
> tel. +44(0)19755 63548                    http://minke-informatics.co.uk
> mob. +44(0)7985 078324        mailto:tony.travis at minke-informatics.co.uk
> _______________________________________________
> Bio-Linux mailing list
> Bio-Linux at nebclists.nerc.ac.uk
> http://nebclists.nerc.ac.uk/mailman/listinfo/bio-linux
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.bioinformatics.org/pipermail/bio-linux-list/attachments/20150430/3b6f63ee/attachment.html>


More information about the Bio-linux-list mailing list