Random Stuff

Random notes and thoughts that may or may not be of use to someone.

Thursday, January 08, 2015

MySQL - create database and user quickly

I'm not a MySQL fan. I don't use it enough to remember some basic things.

mysql> create database mydb;
mysql> create user 'myuser'@'localhost' IDENTIFIED BY '*******';

mysql> grant all privileges on mydb.* to 'myuser'@'localhost';
Posted by Sybrand at Thursday, January 08, 2015
Labels: mysql, programming

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Sybrand
View my complete profile

Blog Archive

  • ►  2018 (1)
    • ►  April (1)
  • ►  2017 (1)
    • ►  March (1)
  • ▼  2015 (3)
    • ►  February (1)
    • ▼  January (2)
      • MySQL - create database and user quickly
      • Things about python that I constantly forget (hate)
  • ►  2014 (6)
    • ►  October (1)
    • ►  August (1)
    • ►  July (2)
    • ►  April (1)
    • ►  March (1)
  • ►  2010 (3)
    • ►  June (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2009 (10)
    • ►  December (5)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  February (1)
  • ►  2008 (3)
    • ►  September (1)
    • ►  August (1)
    • ►  May (1)
  • ►  2007 (11)
    • ►  October (1)
    • ►  September (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (6)
  • ►  2006 (3)
    • ►  December (3)
  • ►  2005 (6)
    • ►  November (2)
    • ►  October (1)
    • ►  September (1)
    • ►  June (1)
    • ►  January (1)
  • ►  2004 (1)
    • ►  August (1)

Friends

  • Carli
  • Johan Jordaan
  • Olivia Pig
  • Timothy Twelves
Simple theme. Powered by Blogger.