The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Privilege tables have changed in MySQL 4.0.2

Discussion in 'General Discussion' started by Rhode, Apr 19, 2003.

  1. Rhode

    Rhode Member

    Joined:
    Feb 10, 2003
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Does anyone know the command to grant CREATE TEMPORARY TABLES privilege to a MySQL user?

    I tried:
    GRANT CREATE TEMPORARY TABLES,LOCK TABLES ON *.* to ...

    but it is not working.

    Thank you!
     
  2. Juanra

    Juanra Well-Known Member

    Joined:
    Sep 22, 2001
    Messages:
    777
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Spain
    Make sure you do a FLUSH PRIVILEGES query as well.
     
Loading...

Share This Page