Google Looker Studio: Setting up Public MariaDB on your PC and connecting it to Studio

 Preface

This blog will outline the key steps to setup XAMPP server, connect MySQL to Workbench, create tables, enter data, connect MySQL to Looker Studio, and host Looker Studio reports in XAMPP server webpage.

YouTube tutorial for above



Comments

Post a Comment

Popular posts from this blog

LibreBase to MariaDB (MySQL) on Synology NAS Drive DS923+

Image
Step 1:  Install MariaDB and PHPMyAdmin in Synology NAS Drive Connect to your Synology NAS Dashboard. Select >  Package Center > MariaDB 10 > Install. Once the database is installed the next time you open Package Center it will show an Open button. Select > Open and note the Enabled TCP/IP connection Port. The default is 3306 but a different port number may be allocated such as 3308. Similarly install phpMyAdmin. If it is installed the button will show Open. To run phpMyAdmin you will need to launch it from your browser to Synology NAS Drive IP Address. The NAS IP Address is shown on the lower right hand corner of the Dashboard under System Health. e.g. LAN1   192.168.1.232 Step 2:  Access phpMyAdmin from your browser To access your phpMyAdmin you need to enter the IP Address of your NAS drive as shown in the Dashboard. You can now Import a csv table from your spreadsheet like the table shown below. You can edit and change records and fields with php...
Read more

CRUD - CodeIgnighter & Grocery-CRUD

This blog tutorial is created to help you create a browser based (cloud) database application using MariaDB with CodeIgniter together with the Grocery-CRUD plugin that you can easily test through your localhost server on your desktop, on your LAN or via internet through your ISP. Download and install XAMPP on Windows OS or Apache, MariaDB (MySQL) and PHP on Linux. Download and install CodeIgniter3 in /xampp/htdocs or /var/www/html/ in Ubuntu under your website folder name. Download and install Grocery-CRUD application folders by merging them with the CodeIgniter3 folders in your proposed website. Use phpAdmin to create the MariaDB database for your website. Edit /application/config/database.php to point to your database as required. Edit /application/config/config.php to point to your database as needed. You can follow the following online tutorials or read the user manuals online to customise your site to work with CRUD. https://www.grocerycrud.com/ https://www.groceryc...
Read more

Installing RaspberryPi Desktop on Acer AspireOne Intel Atom Laptop

Raspberry Pi Desktop on an Intel Atom N270 Acer One Laptop  I was recently given an Acer Aspire One laptop with Windows XP with 1 GB RAM and 160 GB hard drive with a 1024 by 600 pixel display. I thought it would be interesting to try and refurbish it with a RaspberryPi desktop for PC, which I downloaded from: Raspberry Pi Desktop for PC and Macdesktop/ The downloaded filename is 2021-01-11-raspios-buster-i386.iso which is a 32 bit OS that could be installed on the Aspire One. The Aspire One had a limited legacy BIOS that allowed booting from the USB ports but did not allow me to create a backup image using Clonezilla or Macrium Reflect. Perhaps it was the operator's fault. I gave up after spending a day trying. I used Rufus to enable the raspios iso to boot off my USB.  Installing Raspberry Pi Desktop You can run the Debian with Raspberry Pi Desktop from the live USB drive or use it to install as your computer's main operating system. You can follow the instructions from the f...
Read more