User Access Question

------=_Part_6699_31066192.1138849851929
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,

I'm running MySQL 4.1 on a Win2k box and I'm confused (again) about user
logins. My application is getting the following error:

Connection verification failed for data source: MySQLDSN
[]java.sql.SQLException: Access denied for user 'admin'@'host.mydomain.net'
(using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user
'admin'@'host.mydomain.net' (using password: YES)

Here is the contents of my user table:

host user
% admin
localhost admin
localhost root
host.mydomain.net admin

Clearly 'admin'@'host.mydomain.net' has access. Yet, I'm getting this
error. The strange thing is, I can connect via SQL Manager for MySQL using
an "admin" login. So, the 'admin'@'%' is working. What am I doing wrong?


--
"Liberalism is trust of the people, tempered by prudence; conservatism,
distrust of the people, tempered by fear."
-William Gladstone
------------------------------------------
Robert Nurse
http://www.bajansrealm.com
AIM: BarbadosToNYC

------=_Part_6699_31066192.1138849851929--

Re: User Access Question

Well, I couldn't see clearly why MySQL refuses the connection, my best
guests would be:

1) Different passwords for the accounts, try this: at console and
logged as root (or at least with all privileges) type:

GRANT ALL PRIVILEGES TO 'admin'@'host.mydomain.net' IDENTIFIED BY 'password=
';

2) Old style passwords. Some clients (I don't know about Java) can't
connect using new passwords (they are longer and encrypted in a
different way), the standard format changed between 4.0 and 4.1. Try
this: at console and logged as admin type:

SET PASSWORD=3DOLD_PASSWORD('password');

And try again.

Another option is that maybe your DNS is not working properly, so the
server doesn't know that your machine is part of the 'host.domain.net'
domain. Try checking this too.

Good luck,

On 2/2/06, Robert Nurse wrote:
> Hi All,
>
> I'm running MySQL 4.1 on a Win2k box and I'm confused (again) about user
> logins. My application is getting the following error:
>
> Connection verification failed for data source: MySQLDSN
> []java.sql.SQLException: Access denied for user 'admin'@'host.mydomain.ne=
t'
> (using password: YES)
> The root cause was that: java.sql.SQLException: Access denied for user
> 'admin'@'host.mydomain.net' (using password: YES)
>
> Here is the contents of my user table:
>
> host user
> % admin
> localhost admin
> localhost root
> host.mydomain.net admin
>
> Clearly 'admin'@'host.mydomain.net' has access. Yet, I'm getting this
> error. The strange thing is, I can connect via SQL Manager for MySQL usi=
ng
> an "admin" login. So, the 'admin'@'%' is working. What am I doing wrong=
?
>
>
> --
> "Liberalism is trust of the people, tempered by prudence; conservatism,
> distrust of the people, tempered by fear."
> -William Gladstone
> ------------------------------------------
> Robert Nurse
> http://www.bajansrealm.com
> AIM: BarbadosToNYC
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org