Welcome to VK6KFK - Linux Tips

Linux Command Line & System Tips

MySQL Commands

Posted on: 30/08/2026 11:56

This will show you your tables with in your database

Terminal Window

sudo mysql -u root -p -e "USE \`your_database\`; SELECT * FROM \`your_table\`;"

Adding new column to your table

Terminal Window

sudo mysql -u root -p -e "USE \`your_database\`; ALTER TABLE \`your_table\` ADD COLUMN \`mmd_id\` VARCHAR(255) DEFAULT NULL AFTER \`new_column\`;"

Clear a table with in your database

Terminal Window

mysql -u root -p -e "USE \`your_database\`; TRUNCATE TABLE your_table;"

To verify that the database table has been completely cleared out before you do the fresh re-upload

Terminal Window

mysql -u root -p -e "USE \`your_database\`; SELECT COUNT(*) AS Total_Rows FROM your_table;"

+------------+
| Total_Rows |
+------------+
|          0 |
+------------+

Install MySQL and Adminer on Ubunto Server 26.04

Posted on: 30/08/2026 11:58

check for updates first

Terminal Window

sudo apt update

Install MySQL

Terminal Window

sudo apt install mysql-server

Check that it is running

Terminal Window

sudo systemctl status MySQL

result should be like so

Terminal Window

● mysql.service - MySQL Community Server
     Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: enabled)
     Active: active (running) since Sat 2026-08-29 12:02:37 AWST; 39s ago
 Invocation: ee2fadabf80b4264b81b315b4e5a8043
    Process: 68880 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
   Main PID: 68889 (mysqld)
     Status: "Server is operational"
      Tasks: 37 (limit: 13416)
     Memory: 479.7M (peak: 479.7M)
        CPU: 1.086s
     CGroup: /system.slice/mysql.service
             └─68889 /usr/sbin/mysqld

Aug 29 12:02:36 smegbase systemd[1]: Starting mysql.service - MySQL Community Server...
Aug 29 12:02:37 smegbase systemd[1]: Started mysql.service - MySQL Community Server.

Setting up your password

Terminal Window

sudo MySQL

Run command once logged into mysql

Terminal Window

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'your_password';

then

Terminal Window

FLUSH PRIVILEGES;

then

Terminal Window

exit

Installing adminer

Terminal Window

sudo mkdir -p /var/www/html/adminer

then download file

Terminal Window

sudo wget "https://github.com/vrana/adminer/releases/download/v6.0.1/adminer-6.0.1-mysql.php" -O /var/www/html/adminer/index.php

set permissons

Terminal Window

sudo chown -R www-data:www-data /var/www/html/adminer

Open your browser and type in http://your_ip/adminer/
We are going to create a configuration file for Adminer to stop out side users

Terminal Window

sudo nano /etc/apache2/conf-available/adminer.conf

paste into that file

Terminal Window

<Directory /var/www/html/adminer>
    Options FollowSymLinks
    AllowOverride None
    
    # Block everyone by default, then allow local connections
    Require local
    Require ip 192.168.0.0/16
    Require ip 10.0.0.0/8
    Require ip 172.16.0.0/12
</Directory>

Run this command to activate the new security profile

Terminal Window

sudo a2enconf adminer

Then reload Apache

Terminal Window

sudo systemctl reload apache2

1 2 3