James Sessford • Sunday March 8th, 2020ubuntu reminders
I always forget how to do some MySQL operations, especially the more modern ways to add users. I'm listing them here in hopes of either cementing the information because I've written it down or finding my own blog post when I have to search again :)
Depening on what environment you're working in, you could be accessing MySQL in a multitude of different ways. I'm currently using DBeaver & MyCLI on my Ubuntu laptop & HeidiSQL at work.
CREATE DATABASE mydatabase;
CREATE USER 'mydatabaseuser'@'%' IDENTIFIED WITH mysql_native_password BY 'mydatabasepassword';
GRANT ALL ON mydatabase.* to 'mydatabaseuser'@'%'; FLUSH PRIVILEGES;
mycli -u mydatabaseuser -p mydatabase
I'll probably update this post with more MySQL things I remember that I forget as time goes on!