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.

cant delete mysql user

Discussion in 'General Discussion' started by mamady, Aug 8, 2002.

  1. mamady

    mamady Member

    Joined:
    Jun 15, 2002
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    I have one domain which when mysql users are created, they cannot be deleted (via phpmyadmin). When a user is granted permission to a database, and the user is then deleted, it simply APPEARS deleted, but i can still see the mysql user in the root WHM section to 'change passwords for mysql users'.

    When the database is deleted, and a database of the same name is created again, the old user automatically reappears with permissions already granted. (this wouldnt really be a problem, but scripts trying to use mysql under this domain are not working correctly)

    Very weird and confusing... but what i really need to know is... how do i manually delete mysql users? Anybody come across this before? If so, how did you fix it?
     
  2. bert

    bert Well-Known Member

    Joined:
    Aug 21, 2001
    Messages:
    602
    Likes Received:
    0
    Trophy Points:
    16
    We have the same problem here. It has been like that for weeks now.
     
  3. MarlboroMan

    MarlboroMan Well-Known Member

    Joined:
    Dec 7, 2001
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    To delete a mysql user's privledges....
    # mysql
    & REVOKE ALL
    ON [dbname].*
    From [username];

    Additional info on GRANT and REVOKE syntax can be found at mysql's website.....
    http://www.mysql.com/doc/en/GRANT.html
     
  4. mamady

    mamady Member

    Joined:
    Jun 15, 2002
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    thanks... i actually did a search and found that the user does not exist. It must be a cpanel/WHM problem.

    here are the commands to see if your user exists:
    root@server# mysql
    mysql&use mysql;
    mysql&select * from user where user='database_user';



    Any ideas on how to fix this problem?
     
  5. bert

    bert Well-Known Member

    Joined:
    Aug 21, 2001
    Messages:
    602
    Likes Received:
    0
    Trophy Points:
    16
    Quite weird. I know-how and can create dbs, users, etc via the command line, however i was referring to Cpanel. The Cpanel mysql screen is the one that has a problem removing users from databases. It has been like that for months now I believe.
     
  6. mamady

    mamady Member

    Joined:
    Jun 15, 2002
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    on restarting mysql, this is what i

    get: mysql started ok Aug 11 05:19:35 alpha kernel: grsec: setreuid(ruid=0/euid=0) by (mysqlwrap:1716) UID(32004) EUID(0), parent (cpanel:10689) UID(32004) EUID(32004)

    What does that mean? Is the kernel having problems?
     
Loading...

Share This Page