Let’s Talk Tech Episode 2 – Installing a MySQL Database Server to Debian

Hello, everyone! Welcome to Episode 2 of Let’s Talk Tech with Deep Core Data. Today we’re going to be continuing our web server installation on Debian 8.2. In this video we’ll be setting up MySQL Community Server 5.7. As before, we will be providing written instructions along with the video, so that everyone can follow along.

In our last video, we installed Debian 8.2 on a fresh virtual machine. Now, before we can install MySQL Community Server 5.7., a user account needs to be enabled to run the installation. To do do this, begin by logging in to Debian and take the following steps:

Step 1: Log in to the root user by typing “su -”, hitting enter, and then entering in the root user’s password.

Step 2:  Superuser do, or sudo, is a utility for UNIX- and Linux-based systems that provides an efficient way to give specific users permission to use specific system commands at the root level of the system.  This is the first app a user should install after rooting, if the rooting method didn’t do it already. “Rooting” allows a user to establish total control over the device, but Superuser is the app that provides the button for that control. To install sudo, type “apt-get install sudo”, and then hit enter.

Step 3: Once the installation is finished, add a user with full administrative privileges by typing “nano /etc/sudoers”, then hitting enter. Scroll down to User privilege specification, and add the username, then type in ALL=(ALL:ALL) ALL, and hit enter.

Step 4: Log out of the root user by typing exit and hitting enter.

Next, we need to download and install the package information from MySQL. The MySQL downloads page for Debian provides a link to the apt repository, however, for the convenience of our readers, we have it listed below. To begin the MySQL download and installation, take the following steps:

Step 1: Using the wget utility, download the package information by typing in “wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb,” and then hit enter.

Step 2: Import the package information using the Debian package utility by typing “sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb”. This will import the repository package information. Enter the user password, and then hit enter.

Step 3: Select what version of MySQL to be installed, then scroll down to Apply and hit enter.

Step 4: Update apt-get by typing “sudo apt-get update”, and then hitting enter.

Step 5: Run the installation process by typing “sudo apt-get install mysql-server”, and hitting enter.

Step 6: Select a password for the root user of the MySQL database, hit enter, then confirm it by entering it a second time.

After doing any installation, it is always important to confirm that the application is functioning properly, and the best way to test functionality is to run the program.

Step 1: Initialize MySQL by typing in “mysql -u root -p”, hit enter, then enter in the root user’s password.

Step 2: Upon a successful login, ensure that the four default databases, information_schema, mysql, performance_schema, and sys have been properly installed by typing “show databases;”, and then hitting enter.  On a successful install, the databases should then be listed in a box beneath the text prompt.

Once it’s been confirmed that the installation was successful, we can then proceed with installing the web app we want to run on this server, which we will cover next week in our video about loading MediaWiki onto a server.

Thanks for watching Let’s Talk Tech with Deep Core Data. Is there a system you would like to see covered by Deep Core Data? Is there something you feel would improve our video walk-throughs? Are you having trouble getting your server running? Let us know by leaving a comment below, or reach out to us on our Facebook, Twitter, or Google+ page.