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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MySQL Temporary Tables

  • 18-07-2009 5:58pm
    #1
    Monotype
    Registered Users, Registered Users 2 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

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


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


  • #3
    forbairt
    Registered Users, Registered Users 2 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


  • #4
    forbairt
    Registered Users, Registered Users 2 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


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


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


  • #6
    forbairt
    Registered Users, Registered Users 2 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
  • #7
    mneylon
    Registered Users, Registered Users 2 Posts: 7,740 ✭✭✭mneylon


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

    Blog | Tweets



  • #8
    forbairt
    Registered Users, Registered Users 2 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


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


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


Advertisement