Topic: connect mysql

how to connect mysql to myvisual database

Re: connect mysql

Hello Manos

Can this help you ?

procedure Form1_OnShow (Sender: string; Action: string);
begin
     frmWait.Show;
     Application.ProcessMessages;

     {$MySQL disable_connectdialog}
     Form1.MySQLConnection.Server := '127.0.0.1';
     Form1.MySQLConnection.Port := 3306;
     Form1.MySQLConnection.Username := 'root';
     Form1.MySQLConnection.Password := 'root';
     Form1.MySQLConnection.Database := 'mvd';

     try
         Form1.MySQLConnection.Connect;
     except
         frmWait.Close;
         ShowMessage('Can''t connect to database.');
         Form1.Close;
     end;

     if Form1.MySQLConnection.Connected then
     begin
         UpdateDatabase(''); // to fill ComboBoxes
         Form1.GridEmployees.dbUpdate; // if you have TableGrid on first form with option "Enable auto execution", you should call method dbUpdate manually
     end;
     frmWait.Close;
end;




begin


end.

JB

Re: connect mysql

how to connect mysql to myvisual database   the local server

4 (edited by sibprogsistem 2020-03-06 07:21:33)

Re: connect mysql

http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=6316&download=0

Post's attachments

Attachment icon Безымянный.png 42.44 kb, 178 downloads since 2020-03-06 

Re: connect mysql

Connect to local server, use host: 127.0.0.1

Dmitry.