i want to change MyConnection1.Password but ...

[iqprog]

Hi,

MyConnection1.Password := 'mypassword';
MyConnection1.Connected := True;
MyConnection1.Password := ''; // <== MyConnection1 automatic disconnected.

i want to change MyConnection1.Password but I don't want to
MyConnection1 disconnected;

sorry my english little.

thanks.

best regards.

[optima]

What exactly do you want to do?

If you want the user password to be changed on the MySQL server, use a TMyCommand component linked to your connection and execute the following SQL:
MyCommand.SQL.Text :=
'SET PASSWORD = PASSWORD('''+NewPassword+''')';
MyCommand.Execute;

I hope this helps.

[iqprog]

i am not want to user password.

i want to Password property of MyConnection Component.
but when i changed password property, if MyConnection.Connected then MyConnection auto disconnected but i don't want disconnected.

sorry little english.

thanks

best regards.

[Ikar]

Changing MyConnection.Password property has no sense for the established connection.

[iqprog]

thanks Ikar
but....
try please example.

procedure TForm1.Button1Click(Sender: TObject);
begin
MyConnection1.Password := 'mypass';
MyConnection1.Connected := True;
// ok no problem

if MyConnection1.Connected then
showmessage('connection ok.') // ok no problem
else
showmessage('not connection');

MyConnection1.Password := '';

if MyConnection1.Connected then
showmessage('connection ok.')
else
showmessage('not connection'); // PROBLEM
end;

i want to change password and i want to not disconnect.

i want to security.
this solution for security.

because hack programs viewing component properties.

thanks.

best regards.

[Ikar]

To store a password in source code is unsafe, regardless where you put it - .dfm or .pas files. The best choice for security reasons is probably to ask user for password.

What does not suit you in behavior where a connection is reestablished?

[iqprog]

dear IKAR,

i do not store the password in .dfm or .pas

my problem is after the connection, i want to make this: MyConnection1.Password:=''

but when use this MyConnection1.Password:='' , MyConnection1 disconnect automatically.

after i get the password from user and establish the connection, i want to clean the value of object password property.

example in my last reply was sent explain to my problem. if you run that codes you can understand what i try to say.

Thanks,

[Ikar]

In our opinion, clearing of the password after establishing a connection has no sense. If malicious program can get access to address space of the application, it doesn't make sense how much time the password is available.