[Bio-Linux] problems with mysql

[Tony Travis]

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