Page 1 of 1

mysql users (Server 2008) 1.7.7 [SOLVED]

PostPosted: 14. December 2011 05:51
by bprsk8r4272
just got a quick question are all the default mysql users needed or is just pma and root users needed just want to know if i can delete the other users

xampp version 1.7.7

thanks to anyone that replies

Re: mysql users

PostPosted: 14. December 2011 06:16
by Sharley
bprsk8r4272 wrote:xampp version 1.7.7
Could you please update your profile with this XAMPP Version please.
Direct link in here:
viewtopic.php?f=16&t=48626
Thanks :)


The default users are:
2 Any
1 pma
2 root

All are required at some stage and should really not be deleted as they are not in any way an issue for the smooth running of MySQL.

Have you any reason why you want to delete any of them?

Re: mysql users

PostPosted: 14. December 2011 06:22
by Altrea
In most cases, the Anonymous (ANY) users can be deleted without any risk.
You only need them if you have some really special applications that need to connect anonymously to databases.

btw: the ANY users just have access to the mysql test database. So for security reasons you don't need to delete that users.

Re: mysql users

PostPosted: 14. December 2011 06:27
by bprsk8r4272
i didnt update my profile yet cause im still using that version.
i plan to switch it to 1.7.7 on win server 2008 standard 32 bit and run it live thats why i was asking about the mysql users.
i deleted the any users and the root with no password and left the pma and root with a password plus a user i created is this ok?

Re: mysql users

PostPosted: 14. December 2011 22:43
by Sharley
Because your questions have been answered by Altrea and I this topic has been marked solved and closed.

You are strongly advised by the developers and this forum NOT to use XAMPP in a production environment.
Please read the readme_en.txt file found in the xampp installation folder.