Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MySQL Temporary Tables

Options
  • 18-07-2009 6:58pm
    #1
    Monotype
    Registered Users Posts: 6,710 ✭✭✭


    I'm a bit rusty on SQL, but I think that I haven't got the permissions to create temporary tables in a MySQL5 database I created (and can't grant that permission to myself).
    • Can I grant this permission to my user or
    • Do I ask you guys to do it for me or
    • Can it not be done or
    • Do you not allow it for some reason?


    This is on minimus linux hosting, by the way.
    Thanks.


Comments

  • Options
    #2
    zreba
    Registered Users Posts: 170 ✭✭zreba


    ask hosing company, you need to have special privileges to create temp tables


  • Options
    #3
    forbairt
    Registered Users Posts: 3,594 ✭✭✭forbairt


    Had a similar issue in the past unfortunately

    Its not currently available on the shared hosting option

    Its not possible to set individual permissions for users ( was response I had before )

    Thankfully I can do it all on my VPS with them just not on the shared hosting


  • Options
    #4
    forbairt
    Registered Users Posts: 3,594 ✭✭✭forbairt


    zreba wrote: »
    ask hosing company, you need to have special privileges to create temp tables

    technically this is the hosting company :D


  • Options
    #5
    Monotype
    Registered Users Posts: 6,710 ✭✭✭Monotype


    :( Aw, that's a bit crappy. Thanks for letting me know, forbairt.


  • Options
    #6
    forbairt
    Registered Users Posts: 3,594 ✭✭✭forbairt


    Looks like the control panel will be getting an upgrade tonight ? :)

    http://www.blacknightstatus.com/2009/07/cpblacknightcom-major-upgrades.html
    The ability to create temporary tables in MySQL should now be available to all users.


  • Advertisement
  • Options
    #7
    mneylon
    Registered Users Posts: 7,739 ✭✭✭mneylon


    The latest upgrade, as usual, will address a lot of the issues that people have brought to us :)

    Blog | Tweets



  • Options
    #8
    forbairt
    Registered Users Posts: 3,594 ✭✭✭forbairt


    blacknight wrote: »
    The latest upgrade, as usual, will address a lot of the issues that people have brought to us :)

    Just read the
    several 100 bugs in various different sections of our CP have been fixed.

    bit :D


  • Options
    #9
    Monotype
    Registered Users Posts: 6,710 ✭✭✭Monotype


    What really? That's fantastic! - Highly efficient too! Thanks.:D


Advertisement