This wont work in mysql workbench, it has to be done via putty command line!
-- DROP DATABASE IF EXISTS `marksLongDatabaseName` ;
-- GRANT ALL ON *.* TO 'MarkyEdwards'@'localhost' ;
-- make sure we have a name to delete!
DROP USER IF EXISTS 'MarkyEdwards'@'localhost' ;
CREATE USER 'MarkyEdwards'@'localhost' IDENTIFIED BY 'tjoQWlgiIOSzp8';
FLUSH PRIVILEGES ;
GRANT ALL ON `marksLongDatabaseName`.* TO 'MarkyEdwards'@'localhost' \
IDENTIFIED BY 'tjoQWlgiIOSzp8' \
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
# DROP DATABASE `marksLongDatabaseName` ;
CREATE DATABASE IF NOT EXISTS `marksLongDatabaseName` ;
GRANT ALL PRIVILEGES ON `marksLongDatabaseName`.* TO 'MarkyEdwards'@'localhost' ;
# mariadb --host=localhost --user=MarkyEdwards --password=tjoQWlgiIOSzp8 marksLongDatabaseName ;