MX on Linux: Difference between revisions

MX on Linux (view source)

Revision as of 07:33, 31 August 2020

851 bytes added , 07:33, 31 August 2020

m

→‎Installing PHPMyAdmin

Sfws

5,838

edits

@@ Line 309: / Line 309: @@
 The message when the process sucessfully completes is "Thanks for using MariDB".
-== Installing PHPMyAdmin ==
+== Installing Adminer, PhpLiteAdmin, or PhpMyAdmin ==
-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>.
+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>.
-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:
+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 '''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 PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''.
+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
@@ Line 320: / Line 324: @@
-You can view any index.php or PHPMyADmin 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).
+You can view any index.php or PHPMyAdmin 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).