mysql users (Server 2008) 1.7.7 [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql users (Server 2008) 1.7.7 [SOLVED]

Postby bprsk8r4272 » 14. December 2011 05:51

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
bprsk8r4272
 
Posts: 22
Joined: 29. December 2010 00:20
Location: Rochester, Ny
Operating System: Windows 10 Pro 64-bit

Re: mysql users

Postby Sharley » 14. December 2011 06:16

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?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: mysql users

Postby Altrea » 14. December 2011 06:22

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql users

Postby bprsk8r4272 » 14. December 2011 06:27

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?
Last edited by Sharley on 14. December 2011 07:18, edited 1 time in total.
Reason: Additional off topic question deleted, start a new topic. Only one issue per topic - please see the how to post forum announcement for info.
bprsk8r4272
 
Posts: 22
Joined: 29. December 2010 00:20
Location: Rochester, Ny
Operating System: Windows 10 Pro 64-bit

Re: mysql users

Postby Sharley » 14. December 2011 22:43

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 172 guests