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

Hobby project - Store and view exchange rates

By
The next step in my project was to test out being able store and display the rates in a database. I decided to use nodejs and supabase for this. Everything worked beautifully. Only hickup was the following error due to my package.json not being correct. SyntaxError: Cannot use import statement outside a module Added this to package.json   "type": "module" This works beautifully. Right now I am just testing fragments of what could be part of a bigger system to see what is possible and what works and how easy to code on a mobile. There is no fully functioning integrated end to end system just yet. This is also what I tested. A serverless append-only database using GitHub + Actions + Pages. That’s basically a lightweight backend system. This was the ChatGPT prompt I used. Guide me through each step. This is what I want. A manually run github actions that adds to docs/data.json with the current date and time. docs/index.html displays all the entries in data.json. Make s...
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

Today

By
It is 213pm and I have decided to write. God is good. Obviously. God is beautiful. God made me smile. God is what we think of God. We are what we think. Better to think good things. What are some good thoughts? The rain brings joy to the plants. Time dances. The birds sing beautifully. I am happy. A cup of love to warm the soul. Peace and quiet on a Friday afternoon. The light rests gently on everything. Think of all the good things. Think of one good thing. What is the most beautiful thought? God is here and I am here and that is enough. I can do all things through God. The most beautiful thought is one of contentment. I appreciate the now. I appreciate the moment. I am grateful to be where I am. It is no coincidence that God and gratitude both begin with the letter g. If I combine God and gratitude I get Goditude. I also notice that the word guide is contained in the word gratitude. Let gratitude be our guide. If I remove guide from Goditude, I am left with dot. Goditude is a dot wit...
Post a Comment
Read more