Robert A. Knop Jr. writes:

>    ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
> 
>     mysql> select * from user where user='rknop'\G
>     *************************** 1. row ***************************
>                Host: %
>                User: rknop

localhost is a special value (meaning connection over unix socket
rather than TCP/IP), and it's not matched by % in this case. You
need to grant access to user@localhost as well.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.

mysql

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to