Installation of mysql server

1. First thing let’s upgrade the packages:

   sudo apt-get update
   sudo apt-get -y upgrade

2. Install mysql and dependencies

   sudo apt-get install mysql-server

3. Go to /etc/mysql/mysql/conf.d/mysqld.cnf

   Set bind-address = 0.0.0.0

4. Access mysql using mysql -u root -p enter the password

5. Create the database collaboration.

   mysql> create database collaboration;
 
   mysql> exit;

6. Provide permissions to remote nodes or external users -

   Execute the following commands .

   mysql -u root -p

   mysql> use collaboration;

   mysql> GRANT ALL ON *.* TO edx@'10.129.26.148' IDENTIFIED BY 'edx123'

   mysql> flush privileges;

   mysql> GRANT ALL ON *.* TO edx@'10.129.26.188' IDENTIFIED BY 'edx123'  

   mysql> flush privileges;

7. Go to /etc/mysql/my.cnf of above two vms and give the following information.

    [client]

    host=10.129.26.120(ip of mysql server)

    port=3306

    database = collaboration

    user = edx

    password = edx123

    default-character-set = utf8