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.
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...