Professional Web Applications Themes

Users creating databases - MySQL

Two MySQL servers appear to be configured the same. One allows users to create new databases; the other doesn't (and neither should). On both servers, the mysql.User table shows only root as having the Create_priv column yet to Y. Any ideas on what settings I should look at? -- Christoph Burschka Math.-Techn. Assistent i.A. RWTH Aachen Rechen- und Kommunikationszentrum Dienstgebäude Seffenter Weg 23 52074 Aachen Tel: +49 (241) 80-20376 Fax: +49 (241) 80-29100...

  1. #1

    Default Users creating databases

    Two MySQL servers appear to be configured the same. One allows users to
    create new databases; the other doesn't (and neither should).

    On both servers, the mysql.User table shows only root as having the
    Create_priv column yet to Y.

    Any ideas on what settings I should look at?

    --
    Christoph Burschka
    Math.-Techn. Assistent i.A.

    RWTH Aachen
    Rechen- und Kommunikationszentrum
    Dienstgebäude Seffenter Weg 23
    52074 Aachen

    Tel: +49 (241) 80-20376
    Fax: +49 (241) 80-29100
    Christoph Guest

  2. #2

    Default Re: Users creating databases

    == Quote from Christoph Burschka (de)'s article 

    you also need to look at super_priv!
    --
    POST BY: lark with PHP News Reader
    lark Guest

  3. #3

    Default Re: Users creating databases

    lark schrieb: 
    >
    >
    > you also need to look at super_priv!
    > --
    > POST BY: lark with PHP News Reader[/ref]

    Thanks for your help!

    However, this didn't turn up anything different: Both Create_priv and
    Super_priv are only granted to the root user - on either server...

    --
    Christoph Burschka
    Math.-Techn. Assistent i.A.

    RWTH Aachen
    Rechen- und Kommunikationszentrum
    Dienstgebäude Seffenter Weg 23
    52074 Aachen

    Tel: +49 (241) 80-20376
    Fax: +49 (241) 80-29100
    Christoph Guest

Similar Threads

  1. privileges for creating databases
    By Dave in forum MySQL
    Replies: 4
    Last Post: December 18th, 09:27 AM
  2. Replies: 6
    Last Post: September 19th, 08:28 AM
  3. Any head-starts for creating databases?
    By RonSanSolo in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: June 26th, 02:06 PM
  4. Creating compressed databases
    By Rick Altman in forum FileMaker
    Replies: 0
    Last Post: July 18th, 11:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139