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