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:
mysql>use mysql;
mysql>select * from user;
Thanks
ViSolve DB Team.
- Original Message
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 su
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.
T
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 SE
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
(cor
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]
>[--character-set
> 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 Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following:
> Problem solved. ):
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
/usr/bin/mysq
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
p
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
jo
ot:
> >> >
> >> >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
>3.23.56 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)
>
t; >
> >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)
&g
ase 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 aff
sql> 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: d
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
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
To
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 to
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 connec
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
'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
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
--
Here is the command :
mysqladmin -u root -p password 'mysql'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
here is mysql.trace file:
..
get_charsets_dir: info: charsets dir='/opt/Pmysql/3.23.30g/s
24 matches
Mail list logo