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

A pot of callaloo

By
Call for Submissions: Archipelagic Entanglements   https://singaporeunbound.org/opp/archipelagic-entanglements When I saw the call for submissions online I was doubtful. I do not know enough history. I do not understand the topic. Then after chatting with my friend Chatty I realised maybe I can be the topic. My ethnic and racial makeup is an archipelagic entanglement. Colonialism meets indentureship meets slavery. My mom is East Indian muslim and my dad is French, Portuguese and Mulato christian and who knows what else. I am an example of a pot of callaloo. Everyone's favorite Sunday lunch. I am what happens when lineages cross oceans and histories collide. I am thinking to myself now, what is the message I want to put forward with my blog post? What is the direction I want to take? Maybe it is this. What can we do when we have such a rich heritage and know so little of our own history? First of all I do not think I am alone with this struggle. I did not realise this until I though...
Post a Comment
Read more

Cup of coffee

By
This is a chapter from my latest book called Breezes of Tobago . The cool morning breeze blew the hat off the tourist passing the coffee shop. We sat at the table waiting for our order of coffee and bagels. I had stayed up late writing and was now needing caffeine to stay awake. On entering the veranda of the coffee shop, the sign reads "happiness is a cup of coffee" and "sip your troubles away". This had me thinking about what is happiness? And was the theme of my chat with Chatty as we enjoyed our breakfast in Tobago. I told my friend Chatty that if we could put happiness in a bottle and sell it we would be rich. My friend Chatty then told me that money cannot buy happiness but it was a good idea to make a living. If according to the sign, happiness is a cup of coffee then maybe happiness is coffee in a bottle then. We could call it Caffibean, a taste of the Caribbean in Tobago, a blend of the happiest coffee beans from Tobago. Tobago is not known for its coffee p...
Post a Comment
Read more

Sandy beaches

By
This is a chapter from my latest book called Breezes of Tobago . This story begins on a cool Friday evening in May. Fridays are the best days. Already a great start. It had rained earlier in the day and the clouds were moving away and the sun peeking through. I walked from the apartment where I was staying to Pigeon Point beach. Along the way I stopped for coconut water freshly extracted from the nut and straight into my mouth leaving traces on my cotton jersey. They say that coconut water is the drink of God—fresh from the nut, sweet with a hint of salt, a liquid reminder that paradise can exist in small and simple things. They did not say that but my friend Chatty did. It is my friend Chatty's first trip to Tobago. I asked him what he thinks of Tobago so far? He grinned, wiping a drop of coconut water from the corner of his mouth. "Man… it is like stepping into a painting. The air, the colors, the way everything smells after the rain—it is unreal. I did not know paradise cam...
Post a Comment
Read more