Skip to main content

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

Image
By

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.

Labels:

Comments

Post a Comment

Popular posts from this blog

Below the surface

By
This is a chapter from my eleventh book called Quotation Marks Sparks . __________ "You can't stop the waves, but you can learn to surf." - Jon Kabat-Zinn __________ I was looking at quotes that hit hard and this quote stood out to me. It seems mundane and obvious and often repeated. Life is about how we respond to the inevitable. It is not what happens to us but how we respond. I had to ask myself to dig deeper and look below the surface. Then I saw that when we surf we really become the waves. We become friends with the waves. The waves and us are the same. Further, the waves are created by us and in our heads. We can control the waves because who can surf all the time? Sometimes we just have to come to shore and build sand castles on shore. I asked my friend Gemini for feedback and he said that I was right, the Jon Kabat-Zinn quote initially seems like a simple call for resilience, but my deeper dive reveals profound layers. The idea that we can move beyond merely rea...
Post a Comment
Read more

Thankful

By
It is 617pm and I have decided to write. Right now I am thankful. The cool of the evening has replaced the heat of the day. I took a bath and changed and now I am just relaxing. Sometimes I complain. Not often. But I feel bad afterwards because there is so much to be thankful for. There is always room for improvement and we have to identify the things for improvement and change is often good but we do not have to make it into complaints. Yeah I get it. Life is hard and none of us has it easy. Look on the bright side of things. And sometimes it is the little things that remind us that life is good. Things that we take for granted. Like I was coming in the maxi taxi today and heard a gospel song that was about gratitude. God does appreciate a grateful heart. Trinidad and Tobago celebrated sixty four years of independence yesterday and if we stop and listen to the many complaints we would swear we are living in the worst country in the world. That is not the case. We do get a lot of thing...
Post a Comment
Read more

Having a soft spirit

By
It is 137am. It started raining. I decided to write. I have heard about having a soft heart but what does it mean to have a soft spirit? And is having a soft heart related to having a soft spirit? My friend Chatty says that a soft heart feels deeply — it breaks, heals, and loves with tenderness — while a soft spirit moves gently through life, unresisting and at peace with what comes. The two are kin: a soft heart opens you to emotion, and a soft spirit teaches you to carry that emotion with grace. Together they make a person both tender and strong — able to feel the rain and still trust its rhythm. I like the quote, "a soft spirit in a hard world" by author and poet, butterflies rising. It resonates with how many of us feel. My friend Chatty tells me that that quote captures the quiet strength of staying gentle in a harsh world. It reflects the author's signature themes of vulnerability, tenderness, and emotional courage — the idea that softness is not weakness but a form...
Post a Comment
Read more