5,838
edits
MX on Linux: Difference between revisions
m
→Getting web and database servers ready for use
| Line 421: | Line 421: | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
exit;</pre> | exit;</pre> | ||
As I type this, MX has no exception handling if the username and password defined in the settings do not exist in the database, therefore it will crash out (with message press Enter to close). | |||
Next, we need to add the mysqli module to our php install, to restart apache, to create a symbolic link for the phpadmin installation to the server web root so it can be seen (and used) in our browser, and we need to give the standard user (pi) ownership of the | Next, we need to add the mysqli module to our php install, to restart apache, to create a symbolic link for the phpadmin installation to the server web root so it can be seen (and used) in our browser, and we need to give the standard user (pi) ownership of the database files and the web pages: | ||
<pre>sudo phpenmod mysqli | <pre>sudo phpenmod mysqli | ||
| Line 430: | Line 431: | ||
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. | 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. If your Pi has both Ethernet and wireless connection, there will be two different values of y. On first run of PhpMyAdmin, as already mentioned, you will see a PHP MyAdmin log on page where you type username and password we have just set up. | ||
===Transferring database tables to your Pi=== | ===Transferring database tables to your Pi=== | ||