Damilola Amushan – Junior back-end developer.

I began my coding journey in late 2023 when I first started out as a full-stack web developer first receiving training in the front-end track and subsequently in the back-end track.

During the period of my training, I encountered numerous challenges that I had to overcome. One that stands out however, was a database connection failure which I call the “the big problem.”

To solve my big problem, the first thing I did was to check for any typographical errors in my code, as even mistakes as little as a typo can affect the result of your code. But after a review of my written code, I had identified zero typos moving me to the next attempt at a solution, server inspection.

I opened the terminal on my IDE to see if my server was up and running. After checking, I discovered that my server was indeed up and running. As a final server check, I decided to kill the server and restart it using the command php artisan serve. However even after doing so, the database connection still failed.

At this point, I started to fear that much bigger steps would need to be taken in order for this big problem to be solved. This realisation led me to check if I had exceeded my database limits, a suggestion I was received from ChatGPT. I went ahead to run the suggested code netstat -aon ,which displayed all listening established ports. I saw that I had not exceeded the database limit leading me to yet another dead end.

Now, I was beginning to get annoyed. Turning to chatGPT yet again, I received another suggestion I could try, configuring firewall settings. I learned that a firewall setting might be preventing my database from successfully connecting. Putting my annoyance aside, I tried again, this time going to my firewall settings and allowing inbound traffic from the specific port I was attempting to connect my database with. Here’s a rundown of how I did it:

I opened the Windows Defender Firewall, clicked on advanced settings in the sidebar and then selected inbound rules.
On the right, I selected new rule.
I then selected the rule type which was port and then clicked next.
I chose TCP and then entered the specific port number 3306, clicking next afterwards.
I selected all three options as I wanted the rule to apply for Domain, Public and Private.
I finished by naming the rule “MySQL Inbound Rule”
At last I had hit the jackpot. I established a successful connection and the big problem had been solved.

The big problem had taught me quite a lot. Not only did I learn more about coding, but I also learned a bit about myself. It taught me to develop more patience and problem-solving skills which would be useful throughout my coding career.

A friend of mine informed me of a way to develop as a back-end developer. He made mention of an internship program known as HNG Internships and suggested that I enroll. I gave it some thought and decided that it would be a brilliant opportunity to sharpen my skill especially since it was free. I visited their website and began the enrollment procedure. Along the way, I found out that there was an option to get HNG Premium which was an opportunity to participate in the internship as a premium member. Going through the additional perks, such as CV reviews, mock interviews and access to the latest job openings, I decided it was a good deal and seeing as it attracted a fair price, I went for it. I am now awaiting its start in January of 2025.

I hope this program will help me sharpen my coding skill, efficiency and speed. I also hope to become a better problem solver by the end of the internship. One important goal I have is to improve my teamwork skills. I have little knowledge on working in teams and I would want to have a taste of team work involving people from my track and other tech-related tracks like, design, analysis and front-end development.

I hope you enjoyed this read and found some helpful tips for dealing with database connection problems. Feel free to visit the HNG website using the embedded links. Take care!