How to install and configure a database server in Ubuntu?

@noemy.bosco 

To install and configure a database server in Ubuntu, you can follow these steps:

1. Install the database server: The most common database servers for Ubuntu are MySQL and PostgreSQL. You can install them using the apt package manager by running the following commands:

For MySQL:

1
2

sudo apt-get update
sudo apt-get install mysql-server

For PostgreSQL:

1
2

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib

1. Secure the database server: After the installation, it is important to secure the database server to prevent unauthorized access. For MySQL, you can run the following command to secure the installation:

1

sudo mysql_secure_installation

For PostgreSQL, you can edit the pg_hba.conf file to set the authentication rules.

1. Configure the database server: You can configure the database server to suit your needs by editing the configuration files. For MySQL, the configuration file is located at /etc/mysql/mysql.conf.d/mysqld.cnf, and for PostgreSQL, it is located at /etc/postgresql/<version>/main/postgresql.conf.
2. Create databases and users: Once the server is installed and configured, you can create databases and users to access them. For MySQL, you can use the mysql command-line tool to create databases and users. For PostgreSQL, you can use the createdb and createuser commands.
3. Test the database server: Finally, you can test the database server by connecting to it and running queries. For MySQL, you can use the mysql command-line tool, and for PostgreSQL, you can use the psql command-line tool.

That's it! You should now have a working database server installed and configured on your Ubuntu machine.

@noemy.bosco 

Additionally, if you want to install other database servers like MongoDB, you can follow the steps below:

Install MongoDB:

1. Add MongoDB repository key

1

wget -qO - https://www.mongodb.org/static/pgp/server-4.2.asc | sudo apt-key add -

1. Add the MongoDB repository to the sources list

1

echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/4.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-4.2.list

1. Update the package list and install MongoDB

1
2

sudo apt-get update
sudo apt-get install -y mongodb-org

1. Start and enable MongoDB service

1
2

sudo systemctl start mongod
sudo systemctl enable mongod

Configure MongoDB:

1. Configure MongoDB by editing the configuration file located at /etc/mongod.conf. You can set options like bindIp to specify which IP addresses the MongoDB server will listen on, port number, etc.
2. Secure MongoDB if required. Set up user authentication, enable access control, and configure other security settings as needed.
3. Restart MongoDB after making any changes to the configuration file.
4. Test the MongoDB server by connecting to it using the MongoDB shell. You can run commands to create databases, collections, insert data, and perform queries.

By following these steps, you can install and configure MongoDB in Ubuntu alongside MySQL and PostgreSQL as database server options.