How to create MYSQL database LinkServer?

Here are script to create linkserver between SQL Server and MYSQL

 

 

EXEC master.dbo.sp_addlinkedserver @server = N’MYSQLDB’, @srvproduct=N'MySQL ODBC 5.1 driver', @provider=N'MSDASQL', @provstr=N'Driver={MySQL ODBC 5.1 driver};Server=172.XXX.XXX.XXX;Port=3306;Option=131072;Stmt=;Database=trial;Uid=user;Pwd=@@'

 

 

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname= N’MYSQLDB’,@useself=N'False',@locallogin=NULL,@rmtuser=N'user',@rmtpassword='@@'