Devart Forums

Hi

I am using Delphi5 and MyDac 3.55.0.22

I need to know how to get and set system variables like Max_Connections using TMyServerControl or something similar

Best regards
Flemming Brandt

Do a
from a TMyQuery and you'll obtain variables from mysql server. Refer to mysql docs for more details about this.

Regards

Hi
I know the show variables command.

In the help file under TMyServerControl it only sais:

procedure ShowVariables;
Description
Use this method to show the current state of the server.
See Also
ShowStatus

I would like to know if it was posible to list/get a single variable and then set the variable to a different setting.

Hi

I don't know what is wrong with the forum today!!! I look up in the corner and I can see that I (TheLion) am logged in. But when I submitted my answer It was as a guest!!!

But I would still like an exsample on how to set a system variable. I thought that it could be done through TMyServerControl.

Attach a TDatasource+TDBGrid to the TMyServerControl and you'll see it filled with the variables.

Use SHOW VARIABLES LIKE 'Max_Connections' to get values and SET Max_Connections for setting.

Please see MySQL Reference for details