Edel Grace

Programmer, Developer, Enthusiast

TIL: How to Add a MySQL User

Jan 3, 2017 | Comments

CREATE USER 'user'@'server' IDENTIFIED BY 'PASSWORD';
GRANT PRIVILEGES ON database.table TO 'user'@'server';

I recently bought a VPS from Ramnode and started tinkering on it. I needed to create a database for my fanlistings. Back when I was on shared hosting, I would use cPanel and phpMyAdmin to do all that. This is admittedly another TIL that I didn’t learn today but, rather, relearned today because the information slipped my mind. Maybe I need to rename this little segment to “TIRL.”

About

A photo of me

My name is Edel Grace Altares. My programming interests include full stack development and back end development. My languages of choice are Python and Java. Outside of programming I enjoy crocheting, video games, cats, historical fiction, and reading.

Categories

Archives

Blogroll