password: YES)
Yet, when I go in as root and re-grant permissions with the user
password, access is restored. When I reboot, I get the error again.
What could possibly be causing this?
Thanks,
Chris Fonnesbeck
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 7/14/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
>
> What does
>
> show grants for 'chris'@'localhost';
>
>
> reports when you're logged as root?
>
I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '3446cb892d3dffdd' WIT
p
Enter password:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using
password: YES)
On 7/14/05, Danny Stolle <[EMAIL PROTECTED]> wrote:
> Chris Fonnesbeck wrote:
> > I have mysql 4.1.12 installed on OSX 10.4, and have run into the
> > curi
!"
fi
The grant command was:
grant all on *.* to [EMAIL PROTECTED] identified by 'my_password';
Thanks for the help,
C.
On 7/14/05, Danny Stolle <[EMAIL PROTECTED]> wrote:
> Michael Stassen wrote:
> > Danny Stolle wrote:
> >
> >> Chris Fonnesbeck wrot
On 7/14/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
> > PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION |
>
>
>
> You're using passwords in old format. Is it possible that problem
>
> somehow related to this. Are you connecting using mysql command line
>
> client? What version i
#x27;@'localhost' IDENTIFIED BY
PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION |
Does this mean the password has somehow changed?
C.
On 7/15/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
> Chris Fonnesbeck wrote:
> > Here is the startup script:
>
> >
blems arose. However, I just used the ... IDENTIFIED BY 'foobar'
syntax.
Thanks,
C.
On 7/16/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
> Chris Fonnesbeck wrote:
>
> > Sorry. While I am able to log in, I get the following:
> >
> > | GRANT ALL PRIV
On 7/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
>
> Hmmm... In that case, I have more questions. Log in as root and run
>
>SHOW VARIABLES LIKE '%pass%';
>DESC user password;
>
> and post the results.
>
> Also, was this a brand new installation, or an upgrade? If an upgrade, f
16 |2001 |
|36 |2002 |
|91 |2003 |
| 5 |2004 |
|52 |2005 |
+---+-+
10 rows in set (0.12 sec)
So, I'm at a loss as to how to get a complete result set. I do find it
a bit strange that sql returns an incomplete query as a default.
Any ideas
