Creating a new mysql login
I have to do this every 6 months or so and always have to look it up. So this is as much a note for me as it is for anyone else reading this.
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@'localhost’ IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@'%’ IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
(note: I’m sure I originally copied this from somewhere)