Install MySQL 5 on Ubuntu | Step-by-Step Guide

Installing MySQL 5 Server on Ubuntu

The installation of the MySQL 5 Server on an Ubuntu system is a remarkably straightforward procedure. Its simplicity may even be surprising.

Begin by opening a terminal window. Then, execute the following command to initiate the installation:

sudo apt-get install mysql-server

Installing the PHP Module

If your system utilizes PHP, it’s also necessary to install the appropriate MySQL module for PHP 5. This enables PHP applications to interact with the MySQL database.

Use this command to install the required PHP module:

sudo apt-get install php5-mysql

Creating a New Database

Once the server is installed, you can create a new database using the mysqladmin command. This command allows for administrative tasks related to MySQL.

The syntax for creating a database is as follows:

mysqladmin create

As you can see, the process is exceptionally simple and user-friendly!