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
9 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
17 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
137 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
143 Hits
0 Comments

Phoca Download Empty Categories

Phoca Download is am amazing free document repository for Joomla. However I found one feature lacking, when a category was empty (contained no files), there was no obvious message to the visitor - there was simply the category name and a blank page.I always thought there should be a message 'Oops - nothing here!', or similar.To save you some time, ...
Rate this blog entry:
Continue reading
594 Hits
0 Comments

Chrome “disable developer mode extensions” pop up

This is how to get rid of that popup appearing every time you create your own local extension in Chrome.Create a .bat file and name it `DevWarningPatch.bat`. Save this to the desktop.Add the contents below to the bat file.Make sure to close Chrome and end all chrome.exe processes. Rightclick the batch file and run it as administrator: it will find ...
Rate this blog entry:
Continue reading
13169 Hits
0 Comments