Thanks Martin,
But, I want to know the script in PowerBuilder, because my current version of MySQL
does not support store procedure, so I don't know how to code the set user password
statements in PB.
>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
> Sent: Wednesday, March 17, 2004 12:24 PM
> To: '[EMAIL PROTECTED]'
> 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]
