using the client and changes their password using SET
PASSWORD= PASSWORD('their new password'), it breaks the single signon.
Thanks,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
Check for the user in the 'User' Table of 'mysql' database. If there exists
'gamito' User in the User table, then set password will surely do.
Verify:
mysqluse mysql;
mysqlselect * from user;
Thanks
ViSolve DB Team.
- Original Message -
From: Deckard [EMAIL PROTECTED
Hello,
I'm trying to set a password for a user with the command:
mysql set password for 'gamito'@'localhost'=password('bla');
but i always get the error:
ERROR 1133 (42000): Can't find any matching row in the user table
although i'm pretty sure that he user exists.
I'm using MySQl version
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password after
they log in.
The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the
user has been created with no specific host extension in the mysql database
(corresponding
Carre
To: [EMAIL PROTECTED]
Sent: 7/13/04 5:01 AM
Subject: SET PASSWORD = PASSWORD('newpassword') does not work if user has
host extension
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password
after
they log in.
The command SET PASSWORD
Message-
From: Stephane Carre
To: [EMAIL PROTECTED]
Sent: 7/13/04 5:01 AM
Subject: SET PASSWORD = PASSWORD('newpassword') does not work if user has
host extension
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password
after
they log in.
The command
The man page says
/usr/bin/mysqladmin -u user -p somepassword
Not here it doesn't. My man page says:
mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help]
[--character-sets-dir=directory] [-C|--compress]
[-h|--host=[#]] [-p[pwd]] [--password=[pwd]]
On Mon, Apr 12, 2004 at 11:19:50AM +0100, Russell Horn wrote the following:
The man page says
/usr/bin/mysqladmin -u user -p somepassword
Not here it doesn't. My man page says:
mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help]
Okay, I've been googling for about half an hour, found several useful links
but I'm still having a problem with the password for the initial mysql db
that is created when you follow the install instructions.
Here is the problem I'm having:
joseph-a-nagy-jr root # /usr/bin/mysqladmin -u root -h
Problem solved. ):
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
The only fallacy is the inaction on our part to stave off the worst of
horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004
On Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following:
Problem solved. ):
snip
Well, it wasn't a problem with mysql per sey but a problem with how I was
entering the command.
The man page says
/usr/bin/mysqladmin -u user -p somepassword
is correct as is
grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password
test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK
it works.
Let me demonstrate it:
on mysql 3.23.56:
as root:
mysql create database test_dummy;
Query OK, 0 rows affected (0.00 sec)
mysql grant all on test_dummy.* to dummy;
Query OK, 0 rows affected (0.00 sec)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows
)
mysql set password for 'dummy'=password('testpass');
Query OK, 0 rows affected (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql exit
Bye
-
as a user: dummy:
-
mysql set password=password('testpass1');
Query OK, 0 rows affected
Chris W [EMAIL PROTECTED] wrote:
I am having trouble revoking the rights of the anonymous user or setting
a password for that user. Can some one help. I can just do an update
or delete but I want to do it with revoke and set password.
What exactly problems do you have? Show your REVOKE
I am having trouble revoking the rights of the anonymous user or setting
a password for that user. Can some one help. I can just do an update
or delete but I want to do it with revoke and set password.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Dear ALL
i did install mysql by rpms all 6 rpms
php-mysql
perl-DBD
mytsql server
mysql client
mysql devel
mysql
but after installing all these rpms when i want to set password for
root or any user then face folllowinmg problem
[root@lhr RPMS]# mysql_setpermission
Password for user
Hello,
My idea is to have several (about 3) databases. Each DB will have one
admin, who is responsible for this DB and doesn't have access to other DBs.
The problem is, how to set privileges?
I did:
GRANT ALL PRIVILEGES on DB1.* to admin1@localhost WITH GRANT OPTION;
Then if admin1 is
The documentation describes the use of "set password = password ('newpass')
as:
"PASSWORD = PASSWORD('some password')
Set the password for the current user. Any non-anonymous user can change his
own password!"
Well, nice I thought, a user can change it's password without havin
'help;' or '\h' for help. Type '\c' to clear the buffer
mysql set password=password('123');
Query OK, 0 rows affected (0.00 sec)
mysql \q
Bye
mysqld on 10.1.2.3 does crash immediately. When trying to restart the daemon
the following happens:
env MYSQL_UNIX_PORT=/var/mysql/socket
From: "Michel Tignyemb" [EMAIL PROTECTED]
Sent: Tuesday, January 16, 2001 4:33 PM
Here is the command :
mysqladmin -u root -p password 'mysql'
Remove the space between -p and password:
mysqladmin -u root -ppassword mysql
- Carsten
23 matches
Mail list logo