Arthur, trying to strip down your output to the very basics:
mysql> select * from user; > | localhost | postfix | | Y mysql> select * from db; > | localhost | maildb | postfix | Y | N > # mysql -u postfix maildb > ERROR 1045: Access denied for user: > '[EMAIL PROTECTED]' (Using password: NO) This shows us that user 'postfix' has global SELECT privileges, plus SELECT privileges for the 'maildb' database. Everything's fine, if you want the privileges to be so. To connect, you should specify that the mysql client should prompt you for a password: C:\mysql\bin>mysql -upostfix -p maildb Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Have a look at that tiny "-p". This will make the client prompt you for a password. If no password is assigned for that user, simply press Enter. If that doesn't succeed, connect to the server as another user (like "root") and issue: mysql> FLUSH PRIVILEGES; Then try to connect as "postfix" once again. Good luck! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
