Setting up a database server to use with my nodejs server on Android in Termux

Following from my blog post on nodejs on android I now wanted to install a database server so I could develop a simple CRUD web app and doing it all on Android.

MariaDB is a free and open source fork of MySQL and is what is available under Termux, which I already have installed and working. The following are the commands I used to install MariaDB.

$ apt update && apt upgrade
$ apt install mariadb

Next I started the server using

$ mysqld

What I learnt from doing this is that I can no longer run commands in the Termux session and what I should have done was run it in the background as follows. I could have also started a new Termux session.

$ mysqld_safe -u root &

But now I get the following error, "mysqld_safe A mysqld process already exists". I found out how to handle this as follows

$ killall mysqld mysqld_safe

This may take a few seconds and I can verify that no mysql processes are still running using the following command

$ ps aux | grep mysqld

Next I wanted to create a database and a table and add some rows and query that table

$ mysql -u root

I got the following error, "ERROR 1698 (28000): Access denied for user 'root'@'localhost'". This bug report comment explains in detail what was happening, not a bug really. I needed to use the second account to login.

I cannot use tsu because my device is not rooted, "/data/data/com.termux/files/usr/bin/tsu: 144: exec: : Permission denied" and I did not make note of the second all priveleges account after install. I just reinstalled termux and mariadb because reinstalling mariadb was not displaying the second account info like the first time. Guessing I needed to do a clean install which I think requires tsu. Later learnt that the account was the same as my Termux account and I could figure this out using the whoami command.

I was now able to login and create my table and add some rows.

MariaDB in Termux


In a future blog post I will create a nodejs web app to connect to the database and display the rows.

Comments

Post a Comment

Popular posts from this blog

Who makes the best cheesecake?

This is a chapter from my fourth book called When hunger yearns It's three in the morning and all through the house is quiet and not a creature is stirring, not even a mouse. I bet a mouse's favorite dessert is cheesecake and so is mine. So it's in the wee hours of the morning and I am thinking about cheesecake and specifically who makes the best cheesecake? I suspect it would be some recipe handed down from generation to generation. Probably someone's grandma from the town where cheesecake originated from. I read that even though we may think that cheesecake originated in New York that it actually goes further back to over four thousand years on the Greek island of Samos. The Greeks there created the earliest known cheesecake. No wonder I think that the cafe in my village that sells Samosas makes the best cheesecake. Is there a connection between Samos in Greece and Samosas? There is not much written about this on the internet but I did find one blog post that tried t...
Read more

Can a single, flickering candle illuminate a vast, ancient library enough to find the book you seek?

This is a chapter from my fourth book called When hunger yearns I asked my friend Gemini to give me 5 random words and form a question with those words. After some back and forth I settled on this question. I have so many questions. How many books are in this library? How long will the candle last? What book am I looking for? Why am I looking for this book? Do I need a ladder to get to the top shelves? Are the books stored in alphabetical order? Am I alone? Is there a librarian? How much time am I allowed in the library? Is there light outside the library? How am I going to read the book after the candle goes out? If there is light outside the library then I could possibly grab books in the dark and carry them outside even when the candle goes out. Am I allowed to create small bonfires with the books I do not want? Would that be worth it? Would the means justify the end? Maybe there are some books with multiple copies and I could create the bonfires with the extra copies. Or maybe crea...
Read more

Book Review - The measure of a man - a spiritual autobiography

It took two days to complete reading this book. My review is really from my notes as I read the book. I read with an open mind and I set out to absorb as much as I could. I love that he acknowledged his wife for her love and support at the beginning of the book. The book had me questioning my own values and virtues. I felt his humility from the get go. I got a sense of calming and authenticity from his words. He had me thinking about how much of our being is influenced by our environment and nurturing during our formative years. He was not afraid to take chances from small and that inner child remains with us through adulthood. He had a good memory. Most of my younger days are a blur to me. Letting go has been a coping mechanism of mines for a long time. Letting go has affected my ability to hold on to memories and feel attachment. I reminded myself of the wanting to be grounded. To be appreciative of where we come from. To be rooted in sensibility and understanding. Racism is horrible...
Read more

My notes from the book "Sick to fit"

My notes from this book. If you are interested in what I noted then give the book a read. Free on Amazon Kindle - https://a.co/2bTlDVF Fun and scientific Life changer Josh's story Eating, moving and thinking right I think my genetics and mental illness and meds makes it much harder to lose weight and get fit Hope is important Free on Amazon app NAQ - naturally attainable quantities Community is important Eating to deal with problems Pragmatism and self-love More than a fitness journey, its a lifestyle journey Avoid burn out One step at a time Don't fall into the perfectionist trap Learn from failure Overconfidence Positive feedback loop Results matter - it is the feedback we have Beware of plateaus Look for results that cannot be measured like happiness and curiosity If when then plan Unconscious vows and character decisions NAQs answer the question, "does this question make sense" The downside of living in our comfort zone Find your community You are what you eat We ...
Read more

Focus on solutions and ways we can help

While surfing the internet this morning I started thinking about problem solving and particularly in Trinidad and Tobago. If I wanted to see a list of all the problems affecting persons in this country where do I go? If I wanted to volunteer solutions to these problems where do I go? There are problems that have existed for years. Seems like everyone knows the solutions. Seems like everyone is an expert. Then there is bureaucracy. Then there are competing interests. Then there is finite resources. I find the older generation is often resistant to change and change is often needed as solutions to problems. The older generation thinks about working hard while the younger generation thinks about working smart. We need to develop a good problem solving culture in this country and I think technology can help. We can develop an open forum platform where persons can share problems and then persons can offer solutions. Problems and solutions can be voted on. The platform can be incentivised to...
Read more