Dan,
Friday, April 05, 2002, 3:21:46 AM, you wrote:
DE> I tried to add a user to my mysql system for the MTA (exim) but am having a
DE> hard time making it work.
DE> I used grant to give exim permissions:
DE> grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
DE> <exim pw>;
DE> and the exim database does exist, BUT.....
DE> [root@shortcircuit root]# mysql exim -u exim -p
DE> Enter password: <exim pw>
DE> ERROR 1045: Access denied for user: 'exim@localhost' (Using password: YES)
DE> [root@shortcircuit root]#
DE> Any ideas? Why can user exim not access the exim database?
You have used wrong GRANT syntax.
I have tested you example, look at the row from user table:
| Host | User | Password | Select_priv | [skip]
| localhost | exim | exim pw | N | N [skip]
^^^^^^^^^^^^^^
Your password is not encrypted.
You should use:
GRANT ALL PRIVILEGES ON exim.* TO 'exim'@'localhost' IDENTIFIED BY
'exim pw';
DE> Thanks!
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
