Cumulus Wiki

MX on Linux: Difference between revisions

Page Discussion

MX on Linux (view source)

Revision as of 07:33, 31 August 2020

851 bytes added ,  31 August 2020
m
→‎Installing PHPMyAdmin
The message when the process sucessfully completes is "Thanks for using MariDB".
 
== Installing PHPMyAdminAdminer, PhpLiteAdmin, or PhpMyAdmin ==
 
Cumulus MX includes two SQLite databases, one is the [[Weather Diary]], the other's use is not documented (see [[Cumulusmx.db]]). You might want to install phpLiteAdmin (the significant part of that name is in the middle) to read those SQLite databases using <tt>sudo apt install phpliteadmin</tt>.
PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps one that works using a drill down approach. However, let me assume that you are happy to use PHPMyAdmin and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>.▼
 
▲ExportMySQL.exe and CumulusMX.exe (see [[Cumulus_MX#Executables]] for details) both create SQL for updating tables in a MySQL database, such as the one our MariaDB software package we have installed can create; so maybe we want to install a package that lets us back up and manipulate tables in this database. PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps one'''adminer''' that works using a drill down approach. However, let me assume that you are happy to use PHPMyAdmin and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>. (Alternatively install a drill down package with <tt>sudo apt install adminer</tt> and I leave you to work out the commands needed after that).
The installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. We need to add the mysqli module to our php install, to restart apache, and to move the phpadmin to the server web root so it can be seen in our browser:▼
 
▲The PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. We need to add the mysqli module to our php install, to restart apache, and to move the phpadmin to the server web root so it can be seen in our browser:
 
Finally, we need to add the mysqli module to our php install, to restart apache, and to copy the phpadmin installation to the server web root as our new copy can be seen in our browser and used there:
 
<pre>sudo phpenmod mysqli
 
 
You can view any index.php or PHPMyADminPHPMyAdmin web page in your browser by prefixing the address with your Pi URL e.g. '''http://192.168.1.xy/phpmyadmin''' where x and y are digits you look up as mentioned before where FTP of MX distribution was described. In this case you will see a PHP MyAdmin log on page where you type username and password (as you may not have added any other user yet, the user will be root).
Sfws
5,838

edits

Retrieved from "https://www.cumuluswiki.org/a/Special:MobileDiff/7136"