Example of phpMyAdmin to show DB table contents - compare with EXCEL query

Hi folks

PhpMyadmin can very quickly show contents for example of a database table etc.

You can get the same info from Windows via Msquery (in Excel --get data) . But for Windows you will need to install an OBDC connector for MariaDB / MySQL -- OK not really an issue and also in EXCEL enable "Legacy data sources - MsQuery -- at least from Office 2021 and onwards).

Using PhpMyAdmin




Using EXCEL




Ok a lot prettier but if you just want quickly to see data / manipulate it then logon to the host containing the database (assuming Linux) and with your browser logon to phpMyAdmin.


You can install Hedisql on Windows too which also gives decent outputs .




so 3 ways to show data in MySQL / MariaDB databases. Manipulation OK too -- although much more fiddly uploading EXCEL data to a MariaDB / MySQL database.

Note - for remote MariaDB access you need to change one line in the MariaDB config file my.cnf. Usually in Linux in the /etc directory -- on Windows -- No idea but same file if using MariaDB / MySQL on Windows.

Set the bind address to the following. bind-address = 0.0.0.0


Now Beer and "Footy" time. Eng Premier league not blocked here for SAT Afternoon matches.

Cheers

jimbo