Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file; /etc/mysql/my.cnf Find the following line; bind-address = 127.0.0.1 Comment it out, and change it to the following; #bind-address = 127.0.0.1 bind-address = 0.0.0.0 You then need to restart the MySQL service using the...
Rate this blog entry:
Continue reading
39 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
119 Hits
0 Comments

Server Side Events with MySQL and PHP

​I wanted to build an application that would display a 'real time' feed of data on my web page.I had access to a MySQL database that contained a 'transactions' table, this table received numerous events every second. I needed to display the transactions in real time (or close enough). Not only did I need to display the live data, but I also wa...
Rate this blog entry:
Continue reading
205 Hits
0 Comments

Omeka Install & Setup LAMP

Having worked with Omeka the past few days I'll explain how to set it up on a LAMP stack. Firstly, what is Omeka? Well, taken from their website;Omeka.net is web-publishing platform that allows anyone with an account to create or collaborate on a website to display collections and build digital exhibitions. No technical skills or special server req...
Rate this blog entry:
Continue reading
1276 Hits
0 Comments

MySQL Replication Resync

Instructions on how to resync a MySQL slave/master replication.

 

Rate this blog entry:
Continue reading
635 Hits
0 Comments