hi,

i have a mysql server and when I run on that server;
# mysql -h localhost -u root -p
and the type the password I get the mysql prompt.

when i do this from a another machine:
# mysql -h <above_machines_ip> -u root -p
and the type the same passowrd I get :
ERROR 1045 (28000): Access denied for user 'root'@'x.x.x.x' (using
password: YES)

how can I further trace what the problem is? there is NO connectivity
problem, socket to server machine is opened, connected and message is
sent.

tnx for all replies

On 5/10/2011 9:21 AM, adirtymindisajoyforever wrote:
MySQL authorizations are based on both the user id and the ip address.
Generally you have one userid for localhost and another for one or more
(or all) remote ip addresses.

You need to create another user (it can be root with the same or
different password, but I really don't recommend it for security
reasons), such as

See http://dev.mysql.com/doc/refman/5.6/en/grant.html for more detailed
information and syntax.

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

adirtymindisajoyforever <getridofthespam (AT) yahoo (DOT) com> wrote:
^^^^^^^^^^^^^^^^^^^^^^^
your parents must have a sick kind of humor to give you such a name

Yes.

There is no problem. You first have to create a MySQL account to
connect from a different machine. A freshly installed MySQL server
comes with a root@localhost account and additionally allows anybody
access to the `test` database. You certainly don't want to leave it
that way.

http://dev.mysql.com/doc/refman/5.1/...tallation.html
http://dev.mysql.com/doc/refman/5.1/...anagement.html


PS: you should not use the "root" account (more precisely: any MySQL
account with the SUPER privilege) for daily work. Create a less
privileged account for that and use the root account only when needed.


XL

adirtymindisajoyforever wrote:
it is possible to set _different) permissions for users connecting
locally, and remotely.

These are held in the mysql database.


you obviously are connecting: so it has to be authentication at this level.


I am not sure of the purest and side effect free way of modifying these,
so I will refer you to the manual having said what you are looking for.