Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Mysql Dafault Users

Posted on 2009-02-10
3
Medium Priority
?
243 Views
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
0
Comment
Question by:CMDAI
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 2000 total points
ID: 23608176
Please check here for possible default user created during the installation..

http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html

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 orelse..safe to remove
0
 
LVL 1

Author Comment

by:CMDAI
ID: 23608228
Thank you
pma_YKy2asd
and
Horde
are the only two i need to keep
0
 
LVL 26

Expert Comment

by:Umesh
ID: 23608231
You are welcome.

Thanks,
Umesh
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 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