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