* Claudio Nanni <claudio.na...@gmail.com> [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc....,
>
> Usually this problem comes when you have the anonymous user in the grant
> tables (''),
> MySQL has a tricky way of processing the grant tables.
>
> Sometimes you can be surprised by what you read issuing:
>
> SELECT USER(),CURRENT_USER();
linus:~ tim$ sudo mysql
Password:
.....
mysql> SELECT USER(),CURRENT_USER();
+----------------+----------------+
| USER() | CURRENT_USER() |
+----------------+----------------+
| root@localhost | root@localhost |
+----------------+----------------+
1 row in set (0.00 sec)
...hmm... on my linux box, where all works, I see
'tim@localhost'
> try this:
>
> mysql -utim -psecret -h127.0.0.1 -P3306
linus:~ tim$ mysql -utim -p****** -h127.0.0.1 -P3306
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password:
NO)
Thanks.
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
