To save you some reading effort:
@ Anyone have the procedure that can post it here?
-----
Login to the OCUM6.0 https://<server_ip_or_name>
Administration ->Manage Users ->Add User -> Type=Database User Give username and password :

@Also, connecting to the WFA 1.2 database - got schema / credentials?
----
I think you mean WFA 2.1, correct? WFA provides a a built-in Read Only user to see the WFA Data schema tables and Data.
localhost
Login: wfa
Password: Wfa123
By default Remote login is disabled.
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.