Termux

 Termux is a free and open-source emulator for Android which allows for running a Linux environment on an Android device. The link below is a YouTube tutorial on using Termux to support a MariaDB server with phpMyAdmin.

Termux phpMyAdmin

I am using Termux on my mobile and tablet to install and test MariaDB, Python, SQL, etc. in addition to my PC. So far I have been able to install Termux from Google Play Store, install MariaDB and phpMyAdmin and am able to use it with a browser to work on the database via the localhost. The following tutorial outline the steps I used. 

I was unable to install Termux on Bluestacks (Android simulator) in Win 11 on my laptop.

Step 1 - Install Termux on your mobile device from Google Play Store and > Open the application.



At the  - $ prompt enter: apt update && apt upgrade -y

Next enter - $ apt install php mariadb phpmyadmin -y

Your current working directory is the termux home directory. Go to the root directory/file system dir with "cd .." You should get: .../com.termux/files $ _

Type in: "cd usr/share" and your folder will now be: .../usr/share $ _

Type in: "ls" and you can see the phpmyadmin directory.



Type in: "cd phpmyadmin" and your folder will now be: .../usr/share/phpmyadmin $ _

Start the php server by typing: php -S localhost:8080 enter. You will be told that the web server at the localhost has started. 

Launch a browser and type in: localhost:8080 enter and you should get the phpmyadmin login screen. If you enter root and a password it will tell you that MariaDB is not running. Stope the web server with CTRL+C and clear

Type in: "mysqld --skip-grant-tables --general-log &" to start the mysql daemon program and server.

Move back to the phpmyadmin directory:  .../usr/share/phpmyadmin $ _ and start the php web server using the start php server command: php -S localhost:8080 enter. You will be told that the web server at the localhost has started. 

Launch a browser and enter: "localhost:8080" and the phpMyAdmin login screen will be displayed. Enter your username and password for your server to login.



To stop the server: "killall -9 mysqld"

Note: in phpmyadmin directory there is a php config file that you may need to change 'localhost' to '127.0.0.1' to connect from a browser. The file is config.inc.php






Comments

Post a Comment

Popular posts from this blog

LibreBase to MariaDB (MySQL) on Synology NAS Drive DS923+

Image
Step 1:  Install MariaDB and PHPMyAdmin in Synology NAS Drive Connect to your Synology NAS Dashboard. Select >  Package Center > MariaDB 10 > Install. Once the database is installed the next time you open Package Center it will show an Open button. Select > Open and note the Enabled TCP/IP connection Port. The default is 3306 but a different port number may be allocated such as 3308. Similarly install phpMyAdmin. If it is installed the button will show Open. To run phpMyAdmin you will need to launch it from your browser to Synology NAS Drive IP Address. The NAS IP Address is shown on the lower right hand corner of the Dashboard under System Health. e.g. LAN1   192.168.1.232 Step 2:  Access phpMyAdmin from your browser To access your phpMyAdmin you need to enter the IP Address of your NAS drive as shown in the Dashboard. You can now Import a csv table from your spreadsheet like the table shown below. You can edit and change records and fields with php...
Read more

CRUD - CodeIgnighter & Grocery-CRUD

This blog tutorial is created to help you create a browser based (cloud) database application using MariaDB with CodeIgniter together with the Grocery-CRUD plugin that you can easily test through your localhost server on your desktop, on your LAN or via internet through your ISP. Download and install XAMPP on Windows OS or Apache, MariaDB (MySQL) and PHP on Linux. Download and install CodeIgniter3 in /xampp/htdocs or /var/www/html/ in Ubuntu under your website folder name. Download and install Grocery-CRUD application folders by merging them with the CodeIgniter3 folders in your proposed website. Use phpAdmin to create the MariaDB database for your website. Edit /application/config/database.php to point to your database as required. Edit /application/config/config.php to point to your database as needed. You can follow the following online tutorials or read the user manuals online to customise your site to work with CRUD. https://www.grocerycrud.com/ https://www.groceryc...
Read more

Installing RaspberryPi Desktop on Acer AspireOne Intel Atom Laptop

Raspberry Pi Desktop on an Intel Atom N270 Acer One Laptop  I was recently given an Acer Aspire One laptop with Windows XP with 1 GB RAM and 160 GB hard drive with a 1024 by 600 pixel display. I thought it would be interesting to try and refurbish it with a RaspberryPi desktop for PC, which I downloaded from: Raspberry Pi Desktop for PC and Macdesktop/ The downloaded filename is 2021-01-11-raspios-buster-i386.iso which is a 32 bit OS that could be installed on the Aspire One. The Aspire One had a limited legacy BIOS that allowed booting from the USB ports but did not allow me to create a backup image using Clonezilla or Macrium Reflect. Perhaps it was the operator's fault. I gave up after spending a day trying. I used Rufus to enable the raspios iso to boot off my USB.  Installing Raspberry Pi Desktop You can run the Debian with Raspberry Pi Desktop from the live USB drive or use it to install as your computer's main operating system. You can follow the instructions from the f...
Read more