RE: Set user password by using PowerBuilder

2004-03-16 Thread TH Leung
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 > >>

Re: Set user password by using PowerBuilder

2004-03-16 Thread Martin Gainty
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 'd