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

Coffee and a prayer

By
It is 245am and I have decided to write. I have no topic and no idea what to write. I am thankful for another day. I see the beauty that surrounds us. I choose to be happy. We are in the last ten nights of Ramadan. Tonight is the 23rd night. It could possibly be the night of power. I wonder if it will rain. Maybe it rained when I was sleeping. I got up and bathed and drank a strong cup of coffee. Today is also Friday the 13th. I keep thinking. Life is beautiful. Life is simple. No need to complicate things. No need to be extravagant. Believe in God. Trust in God. Be guided by God. Imagine we can pray for anything. We can ask God for anything. God is always listening. God wants to hear from us. Maybe I can turn this blog post into a prayer. My God I pray that everyone gets their prayers answered. I pray that everyone gets what they need. I pray that you light our path towards you. Guide us with what you intend for us. Keep us close to you. Soften our hearts. Keep us balanced, consistent...
Post a Comment
Read more

Belief is a part of life

By
I watched this video and I quite like it as a good starting point for this blog post https://youtu.be/t44PFI_V4LE We cannot know everything. We do not have the capacity to know everything. I make plans for tomorrow because I believe there is a tomorrow not because I know that there is a tomorrow. We cannot decide today to say we will only act on things that we know for sure. This would be impractical. As my friend Chatty puts it, to live life, we must believe in things that cannot always be proven with certainty. For example, we believe that the future exists, that our actions matter, and that other people can be trusted. We also tend to believe life has meaning and that things can improve. These beliefs help us make decisions, keep hope, and move forward. Given that belief is a part of life, it is reasonable to have people believe in a God and a particular religion. My point is this. Life cannot happen without belief because we cannot know everything (unless we are God like). Belief i...
Post a Comment
Read more

God of direction

By
It is 323am and I have decided to write. I am thinking that I am a bucket of paint. A beautiful shade of blue. That God uses to paint the sky. How could I turn this into something worth writing about? My friend Chatty tells me that I could develop the idea by exploring the metaphor of myself as a bucket of blue paint and God as the painter using it to color the sky. The meaning comes from reflecting on what it feels like to be "used"—losing some of myself while helping create something beautiful. The paint may not see the whole picture and might fear being emptied, but its purpose is fulfilled when it becomes part of the sky. The piece can reflect on purpose, trust, surrender, and the idea that giving of yourself is how beauty is created. It is now 423am and I cannot think of a way to continue this writing. The sky is silent is what comes to my mind. How do I ask the sky to speak to me? I look through my window and I see patches of clouds against a dark sky. Maybe the night s...
Post a Comment
Read more