<img src="media/blogs/digital-ocean.png" alt="Digital Ocean logo" width="230" height="230">
1. Login to Digital Ocean account
2. Create a project
3. Create a new droplet
Create a new key pair and add to the droplet key section.
When droplet creation finishes then reset the password for root. It is mandatory.
4. Login using the console . I prefer to login using ssh.
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
<pre class="language-java"><code> ssh -i [filekey] root@ipaddress</code></pre>
&nbsp; &nbsp; &nbsp; &nbsp; 5.&nbsp;&nbsp;&nbsp;&nbsp; Before doing anything run update command:
<pre class="language-markup"><code>sudo apt update</code></pre>
&nbsp;
&nbsp;
<hr>
<h3 dir="ltr">Installing MySQL</h3>
1. After update command run command below
<pre class="language-markup"><code>sudo apt install mysql-server </code></pre>
&nbsp; &nbsp;Press Y if prompted and it will install mysql on the machine
2. Start the mysql server by running the command
<pre class="language-markup"><code>sudo systemctl start mysql.service </code></pre>
3. Check the status all fine or not.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
<pre class="language-markup"><code>sudo systemctl status mysql.service</code></pre>
This is show Active(running) status
&nbsp;
4. Now it's time to configure mysql
5. Alter the root user password&nbsp; first
<pre class="language-markup"><code>sudo mysql

ALTER USER &lsquo;root&rsquo;@&rsquo;localhost&rsquo; IDENTIFIED WITH mysql_native_passowrd BY &lsquo;password&rsquo;</code></pre>
  
6.&nbsp; Type exit.
7. &nbsp;&nbsp;&nbsp;Now Login with root user&nbsp;&nbsp; &nbsp; &nbsp;
<pre class="language-markup"><code>sudo mysql -u root -p </code></pre>
8.&nbsp; Now run mysql secure script
<pre class="language-markup"><code>sudo mysql_secure_installation </code></pre>
Provide the answer of prompted questions
9. Creating a dedicated user so that we can access this user outside the machine also.
<pre class="language-markup"><code>CREATE USER 'username'@'host' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO &lsquo;user&rsquo;@'host&rsquo;;

FLUSH PRIVILEGES;

exit</code></pre>
&nbsp;
10. Restart the mysql server so that changes reflect.
<pre class="language-markup"><code>sudo systemctl restart mysql.service</code></pre>
11. Finally done with mysql installation and now we can use mysql.
<hr>
<h3>Let's Connect mysql to our local workbench</h3>
1. First , convert public key to pem
<pre class="language-markup"><code>ssh-keygen -p -m PEM -f [yourpublickey]</code></pre>
Type this command to convert , make sure to&nbsp; backup the key first.
2. Open the workbench and add a new connection.
3.&nbsp; For Connection Name, enter any name you&rsquo;d like that helps you identify the connection you&rsquo;re making later.&nbsp;
4. Change the Connection Method to Standard TCP/IP over SSH.
5. For SSH Hostname, enter your droplet IP address. If your server accepts SSH connections on a different port, enter the IP address, followed by a colon and port number.
6. For SSH Username(root), enter the username you use to log into the server via SSH.
7. For SSH Password, enter the password you use for your SSH user. If you use public keys instead of passwords, select an SSH key for authentication.
8. For MySQL Hostname and MySQL Server Port, use the default values.
<pre class="language-markup"><code>HostName: 127.0.0.1
Port: 3306</code></pre>
9. For Username, enter the MySQL username.
10. For Passwords, you can either enter the password or leave it blank. If you do not store the MySQL password in MySQL Workbench, a prompt will request the password each time you attempt to connect to the database.
11. Choose Test Connection to ensure your settings are correct.
12. Choose OK to create the connection.
Create your database using mysql work now.
<hr>
<h3 dir="ltr">Lets install Java and Deploy Spring boot</h3>
1.On you droplet console type command:
<pre class="language-markup"><code>sudo apt install openjdk-11-jre-headless

sudo apt install openjdk-11-jdk-headless</code></pre>
I am installing java 11&nbsp;
Important: Using above command java 11 get installed but javac is not.
There is no need to install javac because we are going to just run application not compile or build but if you want you can install
2. Build your spring boot application with prod profile and server config details in your properties files.
3. Upload this jar to droplet machine folder using FileZilla in our case we created new folder with projects
4. Now Create two script with following commands.
start.sh
<pre class="language-markup"><code>#!/bin/bash

nohup java -jar /projects/blog-app-apis-0.0.1-SNAPSHOT.jar --spring.profiles.active=prod &gt; /projects/log.txt 2&gt;&amp;1 &amp;

echo $! &gt; /projects/pid.file</code></pre>
stop.sh
<pre class="language-markup"><code>kill $(cat /projects/pid.file)</code></pre>
Important : Change your folders path and filename accordingly.
5. Run start script&nbsp;
<pre class="language-markup"><code>sudo ./start.sh</code></pre>
Congratulation project is now running on you given port in project config file.
You can now test it on&nbsp;
http://ip-adress:portnumber
&nbsp;

Deploying Spring Boot with Mysql on DigitalOcean droplet

Deploying Spring Boot with Mysql on DigitalOcean droplet

Help Others, Please Share