Book Image

Ubuntu Server Essentials

By : Abdelmonam Kouka
Book Image

Ubuntu Server Essentials

By: Abdelmonam Kouka

Overview of this book

Ubuntu is a Debian-based Linux operating system built on top of the Debian architecture. It is used to make operating systems for multiple platforms, including phones, desktops, TVs and mobiles. It has made some serious progress in the realms of efficiency and user friendliness. With evolving technology trends, demands on software have changed, with more and more skilled users. Over the past few years, services such as Facebook, Twitter, and push notifications on smartphones mean that users are used to being up to date with everything that happens all the time. With SignalR, the applications stay connected and will generate notifications when something happens either from the system or by other users. This provides new opportunities for the system administrators, to enter this new and exciting world of real-time application development. This is a concise and a cost-friendly guide, packed with up-to-date essentials on Ubuntu Server fundamentals. It will guide you through deploying and configuring Ubuntu servers in your office environments. You’ll start by installing Ubuntu Server, then move to the most useful aspect —the command-line interface inside it. You’ll extend your knowledge by learning how to administrate and configure Ubuntu Server. You will also see how to deploy services on Ubuntu Server and find out how to secure it. You’ll get to grips with the virtualization and cloud computing facilities provided by Ubuntu, and finally, you’ll gain some very useful tips.
Table of Contents (13 chapters)

Setting up a database server


Databases are also one of most used services that every system administrator deals with every day. With the Ubuntu Server, installing and managing databases is quite simple. We previously saw how to install a MySQL database within a LAMP server. In this section, we will see how to do that as a separate action. We will also see how to install and manage another commonly used Open Source database server named Postgres.

The MySQL server

It is easy to install the MySQL database on Ubuntu, just run the following command:

sudo apt-get install mysql-server

You will be asked to enter the root password. You can leave it empty, but I recommend that you set one, and a good one (a strong password) is better.

For customization tasks, you can find the MySQL main configuration files under /etc/mysql/.

Ubuntu includes the mysqladmin tool to help you with MySQL administration. You can think of it as the apache2ctl program in that it accepts certain commands on the command line and...