Do You Want to Learn Marketing or Coding? Do You Want to Learn Marketing or Coding?

SSH Create MYSQL Database, UserName, and Password

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

I always forget the syntax so this is a quick post to remind myself how to create a mysql database, username, and password on a Linux Machine.


create database databasename;
create user 'username'@'%' identified by 'password';
grant all on username.* to 'databasename'@'%';
grant usage on *.* to 'databasename'@'%';
flush privileges;

I Really Need

Reviewing nerdy stuff is expensive.

Consider clicking on this ad & buying that item you REALLY wanted from Amazon.

It helps a ton!

Leave Your Thoughts