Thanks for that. I must admit that I became very used to the "manual" setup in PowerStore1 & 2.
That threat still talks about the need to have create view enabled and this is my stumbling block. I've looked at numerous references to check my syntax like w3schools.com and ntchosting. What worked for you?
SQL query: DocumentationEdit
GRANT SELECT ON databasename TO username@'localhost' IDENTIFIED BY 'abcd';
MySQL said: Documentation
#1045 - Access denied for user 'username'@'localhost' (using password: YES)