Reset expired root MySQL password

MySQL – “Your password has expired. To log in you must change it using a client that supports expired passwords”

What a hugely frustrating problem, to one day try to connect to your local MySQL instance only to find the password expired. I guess if it wasn’t my local instance it may not be such a bad thing from a security perspective but anyway…

After trying a number of things this one worked for me on Windows 7, MySQL version 5.7.

(1) Shutdown the MySQL service instance (Windows -> Run then type services.msc, right-click MySQL57 and stop)

(2) Open the  “MySQL 5.7 Command Line Client” (Windows -> Run then type MySQL, it will appear in the list)

(3) You will be prompted for a password, enter the old root password.

(4) In the MySQL console:

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> SET PASSWORD FOR root@’localhost’ = PASSWORD(‘root1’);
Query OK, 0 rows affected, 1 warning (0.00 sec)

(5) Restart the MySQL service and that should be that.



Angular2 Interfacing with External JS E.g. PouchDB


This blog demonstrates how to interface Angular2 TypeScript with JavaScript.

PouchDB is used as an example JavaScript library.

How to setup a PouchDB in JavaScript

How to setup PouchDB in general is simple as explained here:

Add PouchDB to index.html

<script src=""></script>

This one line of code sets up a database called “dbName”;

var db = new PouchDB('dbname');

Simple as that, now it’s possible to call db.put(),''') db.addDocs()  etc.

Diving Straight into TypeScript and PouchDB

Add PouchDB to your application

As with a traditional JavaScript application, add the script to index.html

<script src=""></script>


As per the example service below,

  • Declare the PouchDB variable. This is the JavaScript variable name. This imports the JavaScript object into the TypeScript domain.
    • The name PouchDB must match the JavaScript object name.
    • This allows an instance to be new’ed up with new PouchDB(“dbname”);
  • Create an instance vrariable to work with.
  • Initialise the instance variable in the constructor.
  • Then add relevant functions….


Note that list and save both return PouchDB promises.

Get Stuff

Use the service as so


Note how the getStuff function receives a PouchDB promise from the service. This of course has nothing to do with Angular2 or TypeScrtipt, it’s simply that all operations in PouchDB are asynchronous.

Add Stuff

Adding a new “Stuff” item looks like this



Keeping things succinct, interfacing external JavaScript libraries from Angular2 TypeScript has been demonstrated using PouchDB as an example.

It’s a matter of:

  • Including the relevant JavaScript library
  • Declaring the JavaScript object within TypeScript
  • Then it’s ready to use.

Comments always welcome…

Deploying a NinjaFramework Application on OpenShift

Deploy a fat jar to OpenShift… Hmmmmm

A NinjaFramework application is built and deployed as a fat jar by default. Given this fact, I popped this question on StackOverflow. I figured that one would need to be some kind of Maven guru in order to build some kind of configuration to deploy it on OpenShift. Not so as it turns out. The guys at NinjaFramework have once again come up trumps. It turns out the process is effortless. This blog describes the steps involved from beginning to end. This process uses Netbeans.

Continue reading

JQuery-Mobile with AngularJS and Angular-Route (ngRoute)


The following details how JQuery-Mobile and AngularJS can play together seamlessly. Angular-Route (ngRoute) is used for navigation. A simple Angular directive invokes JQuery-Mobile styling and enhancements as each page is loaded. This includes pages loaded via  ng-include

A working example is available here as a Plunker

Continue reading

JSON Web Token (JWT) with CORS Stateless REST Service with Facebook Authentication


This blog will demonstrate how to authenticate a REST(ish) service with Facebook authentication, using a JSON Web Token (JWT).

This blog is follows on from previous blogs:

  1. Cross-Origin-Resource-Sharing (CORS) is detailed here
  2. Creating the REST Service and HTML5 Client is detailed here
  3. Adding authentication using Facebook is detailed here (but does not use JWT)

The previous blogs led up to situation where the user is able to authenticate with Facebook thus receiving a Facebook authentication token. Authentication with Facebook results in a request being sent to our REST service. The intent of that request is to authenticate with our Rest service. The request contains the Facebook authentication token and the users Facebook email address (from their Facebook profile). The Rest Service will receive the Facebook authentication token from the client, it then invokes Facebook itself using RestFB to retrieve the users profile. The email address received from the client is now compared with the email address taken from the Facebook profile just retrieved via RestFB.

  • If the email addresses match, the user is authentic. (Now the REST service generates a token for the client which identifies that client. Any time the client wants to invoke the service, it supplies that token).
  • If the email addresses do not match, the client supplied a valid Facebook authentication token but for a different account; reject this user.
  • If the profile cannot be retrieved, the client may have supplied an invalid Facebook authentication token; reject this user.

If the email addresses match, the user is authentic. At this point in the previous blog, the server just responds to the client with an email address, i.e. the matched email address. The client stores this and passes it to the service in a request-header on each request. Our REST service will use this each time to extract the user from persistence.

There are a couple of problems with this approach.

  1. The email address in transit is exposed unless HTTPS is used. HTTPS should be used so this is not such a big issue.
  2. The email address alone may not be sufficient information. Date/Time issued or Date/Time expires may be of use so that the token can be expired after a defined idle period.
  3. Data other than the email address may be required, i.e. a bunch of key-value pairs.

This blog will take the existing application created here and enhance it use a JWT token.

A Maven project and HTML5 client are available for download at the bottom of this blog.

Continue reading

Spring 4 Web MVC with AngularJS


The project downloadable below is an answer to a question repeated in this blog (Spring 3 MVC – Adding Objects to a List element on the fly at form submit – (Generic method))

“How can I submit nested lists of objects?”

The answer is AJAX and JSON.

A very good approach to this is with AngularJS and Spring as demonstrated here.

When the page loads it makes an AJAX call to the server to fetch the model.

The model is bound on the page using AngularJS.

The controls (buttons and input fields) on the page allow the model to be edited.

The model can then be sent to the server via AJAX where it can be persisted. The updated model is returned to the client where it is again bound using angularJS.

The application looks like this



This is a Maven project so just navigate to it using your IDE, open it and run it.





CORS Stateless REST Service with Facebook Authentication


This blog will demonstrate one way to enable authentication with Facebook on a Stateless CORS enabled REST service.

The CORS REST service will be created using the Ninja Framework.

Facebook authentication is via the Facebook JavaScript API.

RestFB is used to consolidate the authentication with the REST Service.

This blog is follows on from previous blogs:

  1. CORS Cross-Origin-Resource-Sharing is detailed here
  2. Creating the REST Service and HTML5 Client is detailed here

This blog focuses on adding authentication using Facebook to the application.

The HTML5 application and NinjaFramework Maven application are available for download at the bottom of this page.

Continue reading

Spring 4 Web MVC – JSON Handling


This blog demonstrates how to process JSON using Spring 4 Web MVC.

The JavaScript AJAX call is described in terms of request headers and request data formatting.

Spring uses Jackson for JSON parsing. Jackson is configured to ignore extra JSON properties that do not match properties of the bean being populated at the @Controller request end-point method.

This blog demonstrates populating complex objects n levels deep thus overcoming some difficulties encountered as per many of the comments in this blog.

Unlike Spring 3 MVC – Adding Objects to a List element on the fly at form submit – (Generic method) a generic JavaScript library is not provided. Populating JSON objects is easily achieved with JavaScript. For that reason, the difficulties of the HTML form implementation described (and partially solved) in that blog do not arise in the first place. Therefore it is hugely favorable to use JSON over conventional HTML forms for complex objects (and in general).

This demonstration conforms to a useful and popular design pattern. Specifically, the form is submitted asynchronously, the response is handled by the client JavaScript.

This provides for:

  • A far better user experience as there is no page load. Feedback is immediate.
  • Ease of development
  • Ease of validation handling
  • Support for complex forms
  • Code portability (think HTML5 clients and single page applications)

Continue reading

AngularJS – Radio Buttons – Three Scenarios


This post will detail how to AngularJS can enhance the usage and functionality of Radio Buttons.

Three scenarios are covered.

  1. Each radio button represents an object. For example, there may be a radio button for each element of an array. When one of the radio buttons is selected, a variable is assigned the corresponding array element. So, a variable called $scope.selectedPerson can be automatically assigned to the selected ‘person’ in an array of ‘person’ objects.
  2. Similar to ‘1’ except instead of selecting a complete object, it’s possible to select just a property of an object. E.g. instead of $scope.selectedPerson, the variable can be $scope.selectedPersonName. This is a simple elaboration on the first scenario purely for emphasis.
  3. This scenario is considerably different. Take elements being added to an array dynamically through a UI, the user adding the elements needs to assign one of them as the default element. This is achieved by setting a property (isDefault = true for example) in the array element object. The other array elements have their isDefault property set to false. Unlike the previous two examples, an external variable is not being set, the elements of the array themselves are being manipulated.

Continue reading

AngularJS – isolate scope – ‘&’ (function reference)


This blog demonstrates how to pass a reference to a function to an angular directive/template.

The way in which the child directive/template calls the parent is also demonstrated.

The example is available as a working JSFiddle here.

This tutorial details creating directive/templates in general (without an isolated scope).

This tutorial demonstrates passing values by value to angular directives/templates (@).

This tutorial demonstrates passing values by reference to angular directives/templates (=).

Continue reading

CORS Stateless REST Service with detached HTML5 client


This blog will detail in precise steps how to create a stateless REST service that is consumed by a HTML5 client on another domain. The HTML5 client could easily be a Cordova or Phonegap app.

The HTML5 client is simple and basic just for demonstration purposes. It shows the characteristics necessary for Cross-Origin-Resource-Sharing (CORS) communication.

The REST service is also simple. It demonstrates how to enable CORS on the server application.

While both Client and Server projects are proliferated throughout this blog, the completed artifacts are available for download at the bottom of this page.

Related Posts

Authenticating a REST Service using Facebook authentication

Adding JSON Web Token (JWT) enhancements to “Authenticating a REST Service using Facebook authentication”

Continue reading

AngularJS – isolate scope – ‘=’ (pass by reference)


This blog will explore the concept of passing object to angularJS directives / templates using by reference.
When an object is passed by reference both the parent (controller or parent directive) and the child directive/template have access to the object. The relationship is bidirectional.

This tutorial details creating directive/templates in general (without an isolated scope).
This tutorial demonstrates passing values by value to angular directives/templates (@).

Continue reading

AngularJS – isolate scope – ‘@’ (pass by value)


Objects can be passed into an angularJS directive in any one of the following ways:
By value using ‘@’
By reference using ‘=’
As a reference to a function in the parent controller using ‘&’

The next few blogs will detail each of these techniques.

This blog will detail the ‘@’ (by value technique).
For detail on creating an angularJS template via a directive please see this blog

Continue reading

Spring 4 Web MVC – Hello World using Annotation and Java configuration with Netbeans

This blog will go through the steps required to setup a basic Spring 4 MVC web application using Netbeans and Maven. The Spring 4 project will be configured using annotations and plain Java rather than XML.

It is a step by step guide to getting up and running quickly. There are plenty alternative methods to doing this but this one is simple, lightweight and to the point. A maven project is available for download at the end of this blog.

Continue reading

Rounding a number up to it’s nearest order of ten

I’m hopeless at math, this is just for future reference as it really bugged me. How to round a number up to it’s upper order of 10. Not a simple as it may seem.


800 -> 1000
125 -> 1000
80 -> 100
43 -> 100
8 -> 10
9 -> 10
0.8 -> 1
0.23 -> 1
.08 -> 0.1
(consider -> to be “goes-to” or “rounds-up-to”)


The solution Continue reading

Using templates with AngularJs

The purpose of this blog is to demonstrate how to use templates in AngularJS. A fully worked example is provided via jsFiddle. The example is simple and easy to follow. A detailed but succinct explanation of the code is provided.

The template is “complex html” that we’ll want to reuse. The directive will allow this complex html to be delivered anywhere without code duplication. This obviously has advantages in terms of code reuse and maintainability.

Continue reading

AngularJS – Permitting AngularJS templates in IE8

So, you’ve got something like this:

But you find that in IE8 the directive that populates the <mytemplate/> element is not working at all in IE8. IE8 will not initialise the controller and hence your $scope is null.

Continue reading