How to connect to MYSQL using delphi

Required controls: (view as form)

1. SQLConnection1: TSQLConnection
ConnectionName = 'mysqlconnection'
DriverName = 'mysql'
GetDriverFunc = 'getsqldrivermysql'
LibraryName = 'dbxmys. dll'
LoginPrompt = False
Params. Strings = (
'Hostname = localhost'
'Database = mysqldb'
'User _ Name = root'
'Password = pswd'
'Maxblobsize =-1

ServerCharSet = utf8 ')
VendorLib = 'libmysql. dll'
Connected = True

2. SQLTable1: TSQLTable
GetMetadata = False
MaxBlobSize =-1
SQLConnection = SQLConnection1
TableName = 'human'

3. performance1: TDataSource
DataSet = ClientDataSet1

4. DataSetProvider1: TDataSetProvider
DataSet = SQLTable1

5. ClientDataSet1: TClientDataSet
Active = True
ProviderName = 'datasetprovider1'

6. DBGrid1: TDBGrid
DataSource = performance1

7. DBNavigator1: TDBNavigator
DataSource = performance1
 

8. Button1: TButton
Caption = 'button1'
OnClick = Button1Click

 

Code:

Procedure TForm1.Button1Click (Sender: TObject );
Begin
ClientDataSet1.ApplyUpdates (0); // update
End;

Finally, you can find the two library files and publish them together.

LibraryName = 'dbxmys. dll'
VendorLib = 'libmysql. dll'