/****** Object:  LinkedServer [database_live]    Script Date: 07/11/2016 10:06:41 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'database_live', @srvproduct=N'MySQL', @provider=N'MSDASQL', @provstr=N'DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=####.##.###.###];Port=3306;OPTION=3;DATABASE=database_live;'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'mysql_inr_live',@useself=N'False',@locallogin=NULL,@rmtuser=N'mohamed',@rmtpassword='########'