MySQL is open source database. For more about this database see on next: MySQL database
In this process we will install mysql server on mysql1 machine (IP address is 192.168.0.2) and do basic setup, such as adding database, and add privileges to user someuser to database testiranje identified by password pillow. Let's start!
In install process you should define and root password. In this case I will use qwerty as root password. Next we can check that mysql is running on our system
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
As we can see it is listening on port 3306 (this is default port for mysql). If you want to mysql start on boot process we will do next:
Now we can connect on mysql server, and add database testiranje.
Enter password: here you put your root password
mysql> create database testiranje;
mysql> grant all privileges on testiranje.* to someuser identified by 'pillow';
mysql> flush privileges;
Now user can change all content on database testiranje.