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

Talking to God

By
If you want real answers to things in life then talk to God. It is 639pm on a holiday and I have decided to write. God listens. God truly listens. God has the entire context. God is wise. God wants us to talk to Him. God wants us to rely on Him. I also think about God talking to me. I am a good listener. I listen plenty more than I talk. I have started asking God to talk to me. But how would God talk to me? We have his revelations through the holy book. We have the example of prophets. But what else? How do I listen to what God has to say? Where and when can I hear God? Are my thoughts from God? I try to feed my mind with good things. Things that will not corrupt my mind. It seems that we have to use our intuition to separate what is from God and what is not from God. My friend Chatty says that in Islam, Allah speaks to us not through new revelations or voices, but through guidance: the Quran and the Sunnah, which become personally meaningful through understanding Allah places in the h...
Post a Comment
Read more

Life on Earth

By
I was reading through the Quran and came to the story of Adam, Eve, Satan, and the forbidden fruit tree. I had thought that life on Earth was created as a test. But as I reflected on the story, I began to wonder whether we are only here because Adam and Eve failed. However, that is not the case, as my friend Gemini explained to me. While the story of the forbidden fruit is a central event, the Quran indicates that humanity’s presence on Earth was part of the original divine plan, rather than a backup plan or a punishment for sin. Before Adam was even created, God announced His intention to place a steward (khalifah) on Earth. This suggests that the Garden was a temporary training ground—designed to teach Adam and Eve about free will, temptation, and the path of repentance. Even if they had not eaten from the tree, they were destined for Earth to fulfill their roles as moral agents. The incident simply served as a necessary first lesson in human frailty and God’s immediate forgiveness. ...
Post a Comment
Read more

The success of failure

By
It is 358am and I have decided to write. Context matters. Our context matters when we write and read. We could read the same thing and get different meanings. Definitions matter also. We may define things differently. For example, what is success? What is failure? Also, do I just define success and say that anything that is not success is failure? What about something like the success of failure? What does that mean? My friend Chatty tells me that this is something writers, philosophers, and even scientists keep rediscovering: meaning is not fixed—it is negotiated by context and definition. Life is a stew of success and failure and in between but never one or the other. We see what we are looking for and things become what we see. This reminds me of something I came across online, "Whoever looks for the good qualities in others will acquire all good qualities within himself," from Habib Umar Bin Hafiz. Do you look for failure or success within others? Take context as the lens...
Post a Comment
Read more