1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to delete Mysql user?

Discussion in 'MySQL' started by Hitul, Mar 28, 2007.

0
  1. #1
    Hi. How to delete mysql user using query? Please tell me. Thanks in advance.
     
    Hitul, Mar 28, 2007 IP
  2. ThreeGuineaWatch

    ThreeGuineaWatch Well-Known Member

    Messages:
    1,489
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    140
    #2
    I'd recommend looking in the manual, my friend. Be aware you can very quickly make a mess of things in mysql if you are unclear how things work.

    Here...

    DELETE FROM user where user='username';
FLUSH PRIVILEGES;
    Code (markup):
    replace 'username' with the username of the user you wish to delete. Also, you have to run this as the root user or some other account that has appropriate privileges on the grant tables.
     
    ThreeGuineaWatch, Mar 28, 2007 IP
  3. Hitul

    Hitul Peon

    Messages:
    76
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks.........:)
     
    Hitul, Mar 28, 2007 IP