The recommended database client for database novices is MySQL. Being a light database, MySQL is easy to use and configure. Also, distributions such as Debian-based Linux Mint already have packages ready to be installed from the default repository. In this post, let me demonstrate how I installed MySQL:

Steps taken to install MySQL in Linux Mint:

1. Download MySQL client:
bash> apt-get install mysql-client

2. Download MySQL server:
bash> apt-get install mysql-server
Note: During installation of mysql-server, you will prompted to enter the root password. It is recommended to set it up.

3. Test if installation is successful using the following commands:
bash> /usr/bin/mysqladmin version
bash> /usr/bin/mysqladmin variables
Note: You should see an output showing details regarding mysql

4. Upon installation of mysql, a database named ‘test’ is already created by default. Test connection by connecting to the database
bash> mysql -u test
You can now connect to the database

5. You can add user accounts using the following commands:
bash> mysql -u root -p                   —–> (log in as root first)
mysql> GRANT USAGE ON test.* TO user@localhost
-> IDENTIFIED BY ‘test’;
This creates an account named ‘user’ with the password ‘test’ on the database named test and all the tables (denoted by *).

Additional Options:
You can also grant priveleges to user accounts:
mysql> GRANT SELECT ON test.* TO user@localhost
This gives the account ‘user’ read priveleges (SELECT Statement) to the database ‘test’ with password ‘pwd’.
If you want the user full control over the database, you can also do:
mysql> GRANT ALL ON test.* TO user@localhost