Chris Fonnesbeck wrote:
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
Please keep this on the list.
Chris Fonnesbeck wrote:
Something seems rather screwed up; I was starting from scratch by
revoking all privileges from joe and deleting him. I got the
following:
mysql REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'localhost';
Query OK, 0 rows affected (0.00 sec)
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, from
what
It's always a good idea to keep the thread on the list. That way, more people
can help solve the problem, and others may benefit from the answers.
Chris Fonnesbeck wrote:
Here is what happens:
mysql GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY 'testing';
Query OK, 0 rows affected
Sorry. While I am able to log in, I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION
|
after a restart, I get
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD
Chris Fonnesbeck wrote:
Sorry. While I am able to log in, I get the following:
| GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY
PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION
|
This is a new, 4.1+, 41 byte password hash.
after a restart, I get
|
Issuing the grant command yields an error:
mysql GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD
'testing';
ERROR 1105 (HY000): Password hash should be a 41-digit hexadecimal number
Also, I tried deleting and re-creating the 'chris' user, and the same
problems arose. However, I
Chris Fonnesbeck wrote:
Issuing the grant command yields an error:
mysql GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD
'testing';
ERROR 1105 (HY000): Password hash should be a 41-digit hexadecimal number
That's my fault. That should have been
GRANT ALL ON test.* TO
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 it is?
Chris Fonnesbeck [EMAIL PROTECTED] wrote:
On 7/14/05, Gleb
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 it is?
I
Chris Fonnesbeck wrote:
Here is the startup script:
standard script snipped
The grant command was:
grant all on *.* to [EMAIL PROTECTED] identified by 'my_password';
Thanks for the help,
C.
Chris,
You only answered one of my questions. I'm hoping to narrow the problem by
determining
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using
password: YES)
Yet,
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost'
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user
Hello.
What does
show grants for 'chris'@'localhost';
reports when you're logged as root?
Chris Fonnesbeck [EMAIL PROTECTED] wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
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' WITH GRANT
Tried that. I get the following:
Oliver:~/Research/Right Whale chris$ mysql mysql -u root -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or
Michael Stassen wrote:
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000):
Here is the startup script:
#!/bin/sh
#
# /Library/StartupItems/MySQLCOM/MySQLCOM
#
# A script to automatically start up MySQL on system bootup
# for Mac OS X. This is actually just a wrapper script around
# the standard mysql.server init script, which is included in
# the binary distribution.
#
19 matches
Mail list logo