Mysql Dafault Users

Posted on 2009-02-10
Last Modified: 2012-05-06
Im Running Lunix , Plesk ,MYSQL
I want to delete all unknown users in our MySQL Database

I dont know what are these:
Any      %      --       USAGE      No      
Uplink      %      
guest      %      
horde      localhost      
pma_YKy2asd       localhost      

Which of this accounts are not necessary?
or not Default so to say
Question by:CMDAI
    LVL 26

    Accepted Solution

    Please check here for possible default user created during the installation..

    Coming to these users,,,

    >>Any      %      --       USAGE      No      

    User "Any" can connect from anywhere "%" and user has READ only permission to server ( You can safely remove this)

    >>Uplink      %      

    User "Uplink" can connect from anywhere "%" and user has "seems to have some privileges " ( You can safely remove this)

    >>guest      %      

    User "guest" can connect from anywhere "%" and user has "seems to have some privileges  ( You can safely remove this)

    >>horde      localhost      

    User "horde" can connect from only "localhost" and user has "seems to have some privileges

    >>pma_YKy2asd       localhost

    User "pma_YKy2asd" can connect from only "localhost" and I belivethis is phpmyadmin's user account..check whether if you are using phpmyadmin to remove
    LVL 1

    Author Comment

    Thank you
    are the only two i need to keep
    LVL 26

    Expert Comment

    You are welcome.


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now