Basically to set the password you want to effect a GRANT on the Table here
is example
> >> >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;
HTH,
Martin
----- Original Message -----
From: "TH Leung" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 11:24 PM
Subject: Set user password by using PowerBuilder
Hi,
I am using the version 4.01 of MySQL and the Powerbuilder. I want to create
a function in PowerBuilder which allows user to reset its MySQL password.
Could anybody help me and give me some advices?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
