-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Magento 2 Cookbook
By :

Throughout the following recipes, we will install the latest MySQL 5.7.x version on Apache and NGINX. The current MySQL version is a milestone in the open source world. Its new performance and scalability features will be a great benefit for every Magento website. This recipe will show you how to do it.
MySQL 5.7 is an extremely exciting new version of the world's most popular open source database, which is two times faster than MySQL 5.6 while also improving usability, manageability, and security.
For this recipe, you will need a preinstalled Apache or NGINX and PHP-FPM or HHVM setup. No other prerequisites are required.
Before we can install the latest MySQL version, we need to download the software in our local system. The official MySQL APT repository provides you with a simple and convenient way to install and update MySQL products. Always use the latest software package using apt-get
.
wget http://dev.mysql.com/get/mysql-apt-config_0.5.3-1_all.deb
mysql-apt-config
package. Run the following command:dpkg -i mysql-apt-config_0.5.3-1_all.deb
During installation, it will ask which MySQL product you wish to configure. Select Server:
Next, it will ask which Server version you wish to receive. Select mysql-5.7:
In the next screen, click on Apply:
apt-get update && apt-get -y install mysql-server
root
is just an example and not advised on production.mysql --version
The output of this command is as follows:
root@mage2cookbook:~# mysql --version mysql Ver 14.14 Distrib 5.7.9, for Linux (x86_64)
Let's recap and find out what we did throughout this recipe. In steps 1 through 3, we download the official MySQL package and use a graphical interface to install the latest version. The whole process is pretty straightforward. Remember to use a dedicated user that has all the privileges instead of the root user.
If you want to check whether MySQL is running fine, use one of the following commands:
service mysql status netstat -anp | grep mysql
After the MySQL server installation is finished, you can log in on the shell using the following command:
mysql -u root -p
Change the font size
Change margin width
Change background colour