Skip to main content

Installing mysql and phpmyadmin on termux

Image
By

ChatGPT prompt - Guide me through installing mysql and phpmyadmin on termux

Because official MySQL packages are not maintained for Termux, the easiest and most stable setup is MariaDB (drop-in MySQL replacement)

Set the root password
Create an admin user for phpmyadmin

\e for long queries in editor

;

At first I got the following error trying to log into phpmyadmin

mysqli::real_connect(): (HY000/2002): No such file or directory

Turns out phpMyAdmin is trying to use “localhost socket” instead of TCP

vim phpmyadmin/config.inc.php

change

$cfg['Servers'][$i]['host'] = 'localhost';

to

$cfg['Servers'][$i]['host'] = '127.0.0.1';

Restart everything. This forces TCP instead of socket.

Now that I have a beautiful LAMP stack setup I could try to install wordpress locally on termux.
Labels:

Comments

Post a Comment

Popular posts from this blog

Drums of freedom

By
It is 401am and I have decided to write. This Saturday, Trinidad and Tobago observes African Emancipation Day. It is a day to celebrate the journey to freedom and to honor those who sacrificed so much so that we could enjoy the freedoms we have today. Yet the journey is not over. As we celebrate how far we have come, let us also ask God to open our minds and hearts to the struggles that continue. Freedom is never something we should take for granted. Every day, we witness powerful interests around the world attempting to stifle freedom in pursuit of their own agendas and self-aggrandizement. Too often, they seek to divide in order to conquer. May we resist division with wisdom, courage, and compassion. May unity triumph over hatred, truth over deception, and love over fear. As we remember the past, may we also commit ourselves to protecting the freedoms of the present and building a more just future for generations to come. Happy African Emancipation Day. May God continue to guide us o...
Post a Comment
Read more

Positive vibration

By
It was 422pm and I decided to write. There was a peace in my heart that could only come from God. But what should I write about? "God, give me a sign. God, give me direction. Place a topic on my heart. Open my eyes and my ears to Your leading." The next morning, I woke up with a positive vibration. My heart felt light, and my mind was clear. It got me thinking. Sometimes, we simply need to clear our minds of negativity. We need to stop feeding fear, doubt, and discouragement, and instead make room for hope, faith, and positive possibilities. We need to reset our minds, renew our spirits, and re-energize our hearts. Then, we can return stronger to face whatever challenges lie ahead. If something is within our control, let us do our best to improve it. If it is beyond our control, let it go and let God. Life will always have difficulties, but we have a choice in how we respond to them. We can choose to see opportunities where others see obstacles. We can find lessons in our set...
Post a Comment
Read more

Foundation of my belief

By
It is 159am and I have decided to write. Some people say that science does not point to an afterlife, heaven or the existence of God. I feel bad because I cannot give them the evidence that they want. I can point them to the Quran and Islamic teachings. The Quran is a miracle and there are signs in that which we can research. Otherwise, there are philosophical and theological arguments. Maybe, you cannot use the science that we have for something (the afterlife) that is outside the realm of science. Also, science is not complete and may never be complete. Scientific knowledge is expanding and sometimes changing, so are we going to wait on science to tell us that there is a God and afterlife? Belief does not need evidence. Faith does not need evidence. At least not the evidence that some are looking for. So what is the foundation of my faith? For some people theology does not fully explain this life so they look to the science we have. For me, science alone does not explain this life, s...
Post a Comment
Read more