LibreOffice Base can make working with remote MySQL databases a snap. Jack Wallen walks you through the steps to make this happen.

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

How to make a database connection to MySQL in PHP Note: You can also use the MS SQL code if you first have Web Services define an ODBC DSN for your MySQL database.

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.