Connecting to a lynux mySQL database remotely

[minestrone]

Anyone have any mySQL administration skills and could help me out with this? I have set up a mySQL DB on ubuntu and want to access it remotely with query browser from my windows machine.

So I set up grants on the DB like so..

GRANT ALL privileges ON *.* TO [email protected] ;

but I am still getting access error 1045.

I even try..

GRANT ALL ON *.* TO '%'@'%' ;

Which I think gives everyone everything but still get the same error.

Can anyone see what the problem is?

Thanks

[DimPrawn]

lynux?

[minestrone]

lynux?

Oops.

Anyway got it..

GRANT ALL ON *.* to 'root'@'192.168.1.66' IDENTIFIED BY 'password' ;

[b0redom]

flush privileges;

[Ardesco]

I suggest either:

http://www.navicat.com/en/products/n..._overview.html

or

http://www.phpmyadmin.net/home_page/index.php

depending on your budget

[NickFitz]

Oops.

Anyway got it..

GRANT ALL ON *.* to 'root'@'192.168.1.66' IDENTIFIED BY 'password' ;

Yup, that's FTW - I nearly drove myself mad recently by forgetting that "IDENTIFIED BY" bit

[MrMark]

Lot's of stuff devoted to this scenario in the reference manual for mysql, if you fancy a bedtime read

http://dev.mysql.com/doc/refman/5.1/...ss-denied.html