MySQL Database Server is designed for enterprise organizations delivering business critical database applications. It gives corporate developers, DBAs and ISVs an array of new enterprise features to make more productive developing, deploying, and managing industrial strength applications. If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI).

Dec 24, 2016 - The best way to find out is look at the Crossover web site listing if each app is supported by Crossover which is the purchaseable version of.

It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML, or other formats to MySQL. MySQL Database Server delivers new enterprise features, including: ACID Transactions to build reliable and secure business critical applications. Stored procedures to improve developer productivity.

Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata.

Distributed transactions (XA) to support complex transactions across multiple databases. Full Specifications What's new in version 5.7.20.1 This version includes performance update and minor bugfixes. General Publisher Publisher web site Release Date January 31, 2018 Date Added January 31, 2018 Version 5.7.20.1 Category Category Subcategory Operating Systems Operating Systems Mac OS X 10.10/10.11/10.3/10.4/10.4 Intel/10.5/10.5 Intel/10.6/10.7/10.8/10.9 Additional Requirements None Download Information File Size 387.96MB File Name mysql-5.7.21-1-macos10.13-x8664.zip Popularity Total Downloads 78,240 Downloads Last Week 39 Pricing License Model Free Limitations Not available Price Free.

Linux and macOS Installation Tutorial for the Microsoft Drivers for PHP for SQL Server. 8 minutes to read. Contributors. In this article The following instructions assume a clean environment and show how to install PHP 7.x, the Microsoft ODBC driver, Apache, and the Microsoft Drivers for PHP for SQL Server on Ubuntu 16.04, 18.04, and 18.10, RedHat 7, Debian 8 and 9, Suse 12 and 15, and macOS 10.12, 10.13, and 10.14. These instructions advise installing the drivers using PECL, but you can also download the prebuilt binaries from the Github project page and install them following the instructions in.

For an explanation of extension loading and why we do not add the extensions to php.ini, see the section on. These instructions install PHP 7.3 by default.

Note that some supported Linux distros default to PHP 7.0 or earlier, which is not supported for the PHP drivers for SQL Server - please see the notes at the beginning of each section to install PHP 7.1 or 7.2 instead. Contents of this page:. Installing the drivers on Ubuntu 16.04, 18.04, and 18.10.

Note To install PHP 7.1 or 7.2, replace 7.3 with 7.1 or 7.2 in the following commands. Install PHP sudo su add-apt-repository ppa:ondrej/php -y apt-get update apt-get install php7.3 php7.3-dev php7.3-xml -y -allow-unauthenticated Step 2. Install prerequisites Install the ODBC driver for Ubuntu by following the instructions on the. Install the PHP drivers for Microsoft SQL Server sudo pecl install sqlsrv sudo pecl install pdosqlsrv sudo su echo extension=pdosqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s. '`/30-pdosqlsrv.ini echo extension=sqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s. '`/20-sqlsrv.ini exit Step 4.

Install Apache and configure driver loading sudo su apt-get install libapache2-mod-php7.2 apache2 a2dismod mpmevent a2enmod mpmprefork a2enmod php7.3 echo 'extension=pdosqlsrv.so' /etc/php/7.3/apache2/conf.d/30-pdosqlsrv.ini echo 'extension=sqlsrv.so' /etc/php/7.3/apache2/conf.d/20-sqlsrv.ini exit Step 5. Restart Apache and test the sample script sudo service apache2 restart To test your installation, see at the end of this document. Installing the drivers on Red Hat 7.

Note To install PHP 7.1 or 7.2, replace remi-php73 with remi-php71 or remi-php72 respectively in the following commands. Install PHP sudo su wget wget rpm -Uvh remi-release-7.rpm epel-release-latest-7.noarch.rpm subscription-manager repos -enable=rhel-7-server-optional-rpms yum install yum-utils yum-config-manager -enable remi-php73 yum update yum install php php-pdo php-xml php-pear php-devel re2c gcc-c gcc Step 2. Install prerequisites Install the ODBC driver for Red Hat 7 by following the instructions on the. Compiling the PHP drivers with PECL with PHP 7.2 or 7.3 requires a more recent GCC than the default: sudo yum-config-manager -enable rhel-server-rhscl-7-rpms sudo yum install devtoolset-7 scl enable devtoolset-7 bash Step 3. Install the PHP drivers for Microsoft SQL Server sudo pecl install sqlsrv sudo pecl install pdosqlsrv sudo su echo extension=pdosqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s. '`/30-pdosqlsrv.ini echo extension=sqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s.

'`/20-sqlsrv.ini exit An issue in PECL may prevent correct installation of the latest version of the drivers even if you have upgraded GCC. To install, download the packages and compile manually (similar steps for pdosqlsrv): pecl download sqlsrv tar xvzf sqlsrv-5.6.0.tgz cd sqlsrv-5.6.0/ phpize./configure -with-php-config=/usr/bin/php-config make sudo make install You can alternatively download the prebuilt binaries from the, or install from the Remi repo: sudo yum install php-sqlsrv Step 4. Pc power supply backup.

Install Apache sudo yum install httpd SELinux is installed by default and runs in Enforcing mode. To allow Apache to connect to databases through SELinux, run the following command: sudo setsebool -P httpdcannetworkconnectdb 1 Step 5. Restart Apache and test the sample script sudo apachectl restart To test your installation, see at the end of this document. Installing the drivers on Debian 8 and 9. Note To install PHP 7.1 or 7.2, replace 7.3 in the following commands with 7.1 or 7.2. Install PHP sudo su apt-get install curl apt-transport-https wget -O /etc/apt/trusted.gpg.d/php.gpg echo 'deb $(lsbrelease -sc) main' /etc/apt/sources.list.d/php.list apt-get update apt-get install -y php7.3 php7.3-dev php7.3-xml Step 2. Install prerequisites Install the ODBC driver for Debian by following the instructions on the.

You may also need to generate the correct locale to get PHP output to display correctly in a browser. For example, for the enUS UTF-8 locale, run the following commands: sudo su sed -i 's/# enUS.UTF-8 UTF-8/enUS.UTF-8 UTF-8/g' /etc/locale.gen locale-gen Step 3.

Install the PHP drivers for Microsoft SQL Server sudo pecl install sqlsrv sudo pecl install pdosqlsrv sudo su echo extension=pdosqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s. '`/30-pdosqlsrv.ini echo extension=sqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s.

'`/20-sqlsrv.ini exit Step 4. Install Apache and configure driver loading sudo su apt-get install libapache2-mod-php7.3 apache2 a2dismod mpmevent a2enmod mpmprefork a2enmod php7.3 echo 'extension=pdosqlsrv.so' /etc/php/7.3/apache2/conf.d/30-pdosqlsrv.ini echo 'extension=sqlsrv.so' /etc/php/7.3/apache2/conf.d/20-sqlsrv.ini Step 5. Restart Apache and test the sample script sudo service apache2 restart To test your installation, see at the end of this document. Installing the drivers on Suse 12 and 15.

Note In the following instructions, replace with your version of Suse - if you are using Suse Enterprise Linux 15, it will be SLE15 or SLE15SP1, and similarly for other versions. Not all versions of PHP are available for all versions of Suse Linux - please refer to to see which versions of Suse have the default version PHP available, or to to see which other versions of PHP are available for which versions of Suse. Note Packages for PHP 7.3 are not available for Suse 12. To install PHP 7.1, replace the repository URL below with the following URL: To install PHP 7.2, replace the repository URL below with the following URL: Step 1. Install PHP sudo su zypper -n ar -f zypper -gpg-auto-import-keys refresh zypper -n install php7 php7-pear php7-devel php7-openssl Step 2.

Install prerequisites Install the ODBC driver for Suse by following the instructions on the. Install the PHP drivers for Microsoft SQL Server. Note If you get an error message saying Connection to 'pecl.php.net:443' failed: Unable to find the socket transport 'ssl', edit the pecl script at /usr/bin/pecl and remove the -n switch in the last line. This switch prevents PECL from loading ini files when PHP is called, which prevents the OpenSSL extension from loading. Sudo pecl install sqlsrv sudo pecl install pdosqlsrv sudo su echo extension=pdosqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s. '`/pdosqlsrv.ini echo extension=sqlsrv.so `php -ini grep 'Scan for additional.ini files' sed -e 's.: s.

'`/sqlsrv.ini exit Step 4. Install Apache and configure driver loading sudo su zypper install apache2 apache2-modphp7 a2enmod php7 echo 'extension=sqlsrv.so' /etc/php7/apache2/php.ini echo 'extension=pdosqlsrv.so' /etc/php7/apache2/php.ini exit Step 5. Restart Apache and test the sample script sudo systemctl restart apache2 To test your installation, see at the end of this document.

Installing the drivers on macOS Sierra, High Sierra, and Mojave If you do not already have it, install brew as follows: /usr/bin/ruby -e '$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)'.