Tried and still no go. Here's the exact steps I took:
1) (as root in Mysql using the mysql database)
delete from user where user='exim';
2) flush privileges;
3) exit mysql
4) reenter mysql
5) grant ALL PRIVILEGES on exim.* to exim IDENTIFIED BY PASSWORD 'testpw';
6) flush privileges;
7) exit Mysql;
8) Attempt to log into mysql as exim, get blocked
One thing I'm noticing is that despite my saying grant ALL PRIVILEGES, the
user table shows all N's for the various priv columns. Possibly the reason?
I will play around with it, perhaps adding the user manually vs
automatically (via grant) and see if it helps unless someone else has a
better idea.
----- Original Message -----
From: "ScaryG" <freymann@???>
To: "Dan Egli" <dmegli@???>
Cc: <exim-users@???>
Sent: Thursday, April 04, 2002 8:06 PM
Subject: Re: [Exim] MySql Problems
> On Thu, 4 Apr 2002 19:32:32 -0700
> "Dan Egli" <dmegli@???> wrote:
>
> > forgot to mention that I did that. Even rebooted the entire mysql
> > daemon, still user exim is denied access.
>
> Ok. I went back and re-read your syntax for accessing the database..
>
> I use:
>
> mysql -u username -p password dbname;
>
> The line you quoted has an extra word tossed in between mysql and the -u.
>
>
> MySql is pretty smart... if you "think" you have the right
> username/password and the correct database name, but you can't connect
> with the above format -- you got something wrong. Delete, start over.
>
> -ger
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
>
>
>
