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

God opens doors

By
It is 1203am and I have decided to write. Saturday I spent the night coding. I was trying to get a FastAPI app up and running, all from my budget Android phone. The test cases were written to use Puppeteer. I ended up using Replit for that. Coding is more challenging when using a mobile phone. Not impossible but more challenging. I hardly blog about technology and coding anymore but the love is still there. I still have a dream of creating my own coding and youtube studio with a nice desk setup. That is nice but what should I make this blog post about? What do I want to write about? What should I write about? I love creating presentations. That is something I could do to revive my youtube channel. I love Maths too. I have this feeling that I could solve one of those longstanding Maths problems that seems impossible. Sometimes, like right now, I feel like abandoning my blog post. It is going nowhere. Maybe I should get up and go wash the wares. I wish God could tell me what to write abo...
Post a Comment
Read more

Mundane

By
It is 123am and I have decided to write. I have this new idea for a book called Mundane. It would be me writing about the ordinary. We chase the extraordinary but there is beauty in the ordinary. There is beauty in the simple. There is beauty in the everyday. What about God? We often think about God in grand terms. But what if God is simple too? What if God is mundane? What if we look for God in the everyday moments? I sit in this dark room with the air conditioning on. The fan is also on. The curtain is down but I imagine the moonlight shining on the grass outside. The cats are probably sleeping. I wonder if anyone else in the neighbourhood is awake at this hour? Is there another writer around who is also writing about the mundane? The fan breeze helps the air conditioning cool me down. These nights are warm otherwise. A mosquito flies across my screen. Hello friend or foe. I cannot quite decide which one. If I had a swatter you would be gone. I check my notifications and there is an ...
Post a Comment
Read more

How do we fix this world?

By
It is 4:39 pm and I have decided to write. It is a peaceful and quiet day. I am thinking about God, and how this life is a test. There is so much happening in this world that could make us sad. But we do not have to remain in that sadness when we put our trust in God. God wants good for us. God wants us to experience peace, and even happiness, despite what surrounds us. How do we fix this world? My friend Chatty suggests that maybe a better question is: What kind of person do I choose to be in this world? Because when enough people answer that question well, that is how real change begins. I want to be the kind of person that God is pleased with. Someone guided by God, not by ego. Someone who chooses patience over anger, humility over pride, and sincerity over appearances. I am doing reasonably well, but I am not perfect. And maybe perfection is not the goal. Growth is. Awareness is. Returning to what is right, again and again, is. I want to grow, and I will keep adjusting myself when ...
Post a Comment
Read more