Book Image

Magento 2 Cookbook

Book Image

Magento 2 Cookbook

Overview of this book

Magento 2 is an open source e-commerce platform that has all the functionality to function from small to large online stores. It is preferred by developers and merchants due to its new architecture, which makes it possible to extend the functionalities with plugins, a lot of which are now created by the community. This merchant and developer guide is packed with recipes that cover all aspects of Magento 2. The recipes start with simple how-to’s then delve into more advanced topics as the book progresses. We start with the basics of setting up a Magento 2 project on Apache or Nginx. Next, you will learn about basics including system tools and caching to get your Magento 2 system ready for the real work. We move on to simple tasks such as managing your store and catalog configuration. When you are familiar with this, we cover more complex features such as module and extension development. Then we will jump to the final part: advanced Magento 2 extensions. By the end of this book, you’ll be competent with all the development phases of Magento 2 and its most common elements.
Table of Contents (16 chapters)
Magento 2 Cookbook
Credits
Foreword
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Installing MySQL


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.

Tip

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.

Getting ready

For this recipe, you will need a preinstalled Apache or NGINX and PHP-FPM or HHVM setup. No other prerequisites are required.

How to do it...

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.

  1. We will now install MySQL using the official vendor package. Run the following command from your root or home directory:

    wget http://dev.mysql.com/get/mysql-apt-config_0.5.3-1_all.deb
    
  2. To download the rest of the latest MySQL package, we first install the 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:

  3. Now, we will update our Ubuntu system using the latest MySQL packages:

    apt-get update && apt-get -y install mysql-server
    
  4. During installation, it will ask you several questions. The first one will be to choose a new password for the MySQL root user. Always make sure to create a new dedicated user only for a database; using root is just an example and not advised on production.

  5. Once every MySQL package is installed, we can check whether everything is in order by running the following command on the shell:

    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)
    

How it works…

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.

There's more…

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