29Jun/100
How to add a new MySQL Database and apply user privileges via the command line
mysql> CREATE DATABASE supercooldatabasename;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON supercooldatabasename.* TO 'supercoolusername'@'localhost'
-> IDENTIFIED BY 'supercoolpassword' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Calendar
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| « Jul | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
Tags
Archive
Login / RSS
TV Shows
- Thu, 17 May May 17, 2012The Mentalist - The Crimson Hat (4x24) […]
- Mon, 14 May May 14, 2012House - Holding On (8x21) […]
- Fri, 11 May May 11, 2012Fringe - Brave New World (2) (4x22) […]
- Thu, 10 May May 10, 2012The Mentalist - Red Rover, Red Rover (4x23) […]
- Mon, 07 May May 7, 2012House - Post Mortem (8x20) […]
- Fri, 04 May May 4, 2012Fringe - Brave New World (1) (4x21) […]
- Thu, 03 May May 3, 2012The Mentalist - So Long, and Thanks for All the Red Snapper (4x22) […]
- Mon, 30 Apr April 30, 2012House - The C Word (8x19) […]
- Fri, 27 Apr April 27, 2012Fringe - Worlds Apart (4x20) […]
- Thu, 26 Apr April 26, 2012The Mentalist - Ruby Slippers (4x21) […]
- Mon, 23 Apr April 23, 2012House - Body and Soul (8x18) […]
- Fri, 20 Apr April 20, 2012Fringe - Letters of Transit (4x19) […]
- Mon, 16 Apr April 16, 2012House - We Need the Eggs (8x17) […]
- Fri, 13 Apr April 13, 2012Fringe - The Consultant (4x18) […]
- Mon, 09 Apr April 9, 2012House - Gut Check (8x16) […]
- Fri, 06 Apr April 6, 2012Fringe - Everything in Its Right Place (4x17) […]
- Thu, 05 Apr April 5, 2012The Mentalist - Something Rotten in Redmund (4x20)Jersey Shore - Goodbye, Adios and Ciao (5x14) […]
- Mon, 02 Apr April 2, 2012House - Blowing the Whistle (8x15) […]