Installing WordPress on a FreeNAS Jail
After creating a basic jail do this: Step 1 Configue the the Jail to Use SSH https://www.ixsystems.com/documentation/freenas/11.2-U6/jails.html#accessing-a-jail-using-ssh Step...
How to Change Authentication Method in MySQL
First, to check what is being used run this, SELECT user, authentication_string, plugin, host FROM mysql.user; If the...
MySQL create user
Every time I have to setup users in MySQL I seem to have problems. I was setting up...
Getting PHP to talk to MySql
If you are trying to get PHP, Apache and MySQL to work together one of the steps you...
Foreign Keys
I’ve been looking at foreign key constraints today. I’ve managed to set a FK constraint in an Oracle...
PostgreSQL
I did some digging and found out that Postgres is actually PostgreSQL an open source database. Much like...
Another Job
I happened to have a quick look at the jobs available at the Bureau of Meteorology yesterday. They...
Creating a user and set password mysql
I’ve had a few problems creating users, assigning passwords and granting access to uses in MySQL. Below is...
Call external script from mysql
To run a script from within mysql simply to the following mysql> source d:/my documents/run.sql; Where d:/my documents/run.sql...