Hi,
MySQL NB here.
Got a MySQL on linux.
When connecting from the local machine (mysql -u<user> -p<password>) I
can log in.
When trying from my Win machine to connect using Query Browser, I get
error 1045 "Access denied for user '<user>'@'Windows Machine
IP' (using password: YES).
I tried various combinations of " grant ALL on <DB> to <user>@<IP>;",
but nothing helped so far.

Any hints (except for the obvious "don't use query browser")?

Thanks,

Ran Shenhar wrote:
In MySQL, users are never identified solely by the user name, but by the
combination of user + host (i.e., the machine or network address from
which the user is coming). It is good for security reasons to have it
this way.

You need to have either a user/host combination of `user`@`*` or else a
user `user`@`<your Windows machine's IP address>` in addition to
`user`@`localhost`. Grant the appropriate permissions to the
combination(s) you need.

On Nov 23, 12:22*pm, Robert Hairgrove <rhairgr... (AT) bigfoot (DOT) com> wrote:
Thanks - but no luck with the grant: mysql> grant ALL on *.* to
'root'@'10.1.2.15';
Query OK, 0 rows affected (0.00 sec)

Ran Shenhar wrote:
Are these on the same intranet? Did you set up a password for
root (AT) 10 (DOT) 1.2.15? It is a different user than root (AT) localhost (DOT)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Nov 23, 1:00*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
Yes, machines are on same intranet and are accessible (ping works, I
can see the connection request running tcpdump on the mysql machine).
No I haven't as I wasn't aware I needed to - how do I go about that?
Also, since my Win is DHCP based, how do I make it general and not IP
specific?

Thanks,

On Nov 23, 1:10*pm, Ran Shenhar <ran.shen... (AT) gmail (DOT) com> wrote:
Following your comment, I saw on mysql.user that my user has no
password, I removed the password from Query Browser - it works.

Thanks for the pointer!

Ran Shenhar wrote:
There's a whole section in the manual about user account management. I
suggest you read it closely:

http://dev.mysql.com/doc/refman/5.4/...anagement.html

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Mon, 23 Nov 2009 16:54:35 -0500, Jerry Stuckle wrote:
One thing that bears mentioning that the manual doesn't make very
clear (mostly because everyone writing the manual is already familiar
with this) is that, when talking about user ids and hosts and the need
for adding them, 'localhost' is *special* and means "is connected
through the local, on-machine unix-ish socket file", and that does
*NOT* include connecting through the TCP loopback address frequently
named "localhost". It's also important (slightly less weird, slightly
more specialized) that it's vital to remember that the host connection
specifies the closest connecting point to the db server. Stuff like
phpMyAdmin needs the host to allow whatever user ID access from the
webserver, not the browser's IP address.

--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting. [TOFU := text oben,
Q: What is the most annoying thing on usenet? followup unten]

Another thing worth knowing is that 'Localhost', 'lOcAlHoSt', and
similar names are *not* special and mean "is connected through the TCP
loopback address frequently named "localhost"".

On 23 Nov, 20:22, Robert Hairgrove <rhairgr... (AT) bigfoot (DOT) com> wrote:
In cpanel there is a "Remote MySQL" option where ip addresses can be
listed. These addresses do not appear to be directly related to
specific users (as I would expect and hope them to be). So how is
this enabled?