you're a genius! I had old_passwords=1 in my.cnf, changed it to 0,
restarted mysql, and then the users worked like a charm. thanks!
Little, Timothy wrote:
My theory would be that it's an OLD-PASSWORDS issue. It would seem that
you might have used the
old_passwords=1 in your original configur
nt: Monday, June 15, 2009 7:41 PM
To: mysql@lists.mysql.com
Subject: restoring mysql db doesn't restore user passwords
I'm running Fedora 11 i386 with Mysql 5.1.32. I dumped my mysql
databases with:
mysqldump -u root -pxxx --lock-all-tables --all-databases >
/root/mysql-back
I'm running Fedora 11 i386 with Mysql 5.1.32. I dumped my mysql
databases with:
mysqldump -u root -pxxx --lock-all-tables --all-databases >
/root/mysql-backup/all-db.sql
and then wiped the operating system and reinstalled. Then I ran
mysqladmin -u root password
to set my root pass
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 up
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
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)
mys
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 (
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 [EM
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:
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
| GR
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 '3
Chris Fonnesbeck wrote:
Here is the startup script:
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 whether the problem is on t
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
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 P
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.
#
#
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): A
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 \g.
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
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
> p
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 'c
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' (usin
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, whe
Helpful Hint:
I had a major problem not being able to register a DSN (Data Source Name)
with the CF Administrator, using username and password from a MySQL 4.1.3
beta user table.
After much hair-pulling, I discovered that CF cannot apparently handle the
new 41-character format of the passwords
Hi
I have problem with passwords.
Normal users who have only 'USAGE' global privileges are
not able to change their own password. I tried to do fresh installation
of mysql 4.0.9 (and 4.0.8) on my windows workstation. I created new user
(as root):
GRANT USAGE ON *.* TO dummy@localhost;
then I
Hello All,
I am using Linux, with Apache, mysql among other things.
I am root, user, owner, etc.
Other than getting up there in age, I can't seem to remember the
mysql passwords that I set up for root, users, etc.
is there a way to remove/recover the password I set up for
mysql for root and sta
Sent: Monday, August 27, 2001 5:35 AM
Subject: Re: Setting user passwords per database
> It would see you could us ethe GRANT command:
>
> GRANT ALL PRIVILEGES ON database1.* TO user@"%" IDENTIFIED BY 'password1';
> GRANT ALL PRIVILEGES ON database2.* TO user@"
IDENTIFIED BY 'password3';
- Original Message -
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 26, 2001 10:40 PM
Subject: Setting user passwords per database
Is it possible to set a di
On Sun, Aug 26, 2001 at 10:40:20PM -0500, Mark Johnson wrote:
>
> Is it possible to set a differenent password per database for the
> same user? It doen't appear to be possible
Not that I know of. The user is tied to a single password.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Tech
Is it possible to set a differenent password per database for the same user?
It doen't appear to be possible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
29 matches
Mail list logo
