Passwords for root (localhost and

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

Passwords for root (localhost and

Postby Lk@zz » 28. November 2008 15:24


I have XAMPP 1.6.8. After installation, in MySQL database I have two root users (for host: localhost and I set password for MySQL by
http://localhost/security/xamppsecurity.php After this, user root for localhost has password, but user root for still hasn't got password (I try change it by:, but it doesn't work). I'd like to ask: why one user root has password and second root doesn't have? Does XAMPP use only localhost and doesn't use (so why there is host for

Thanks awfully for help.
Posts: 1
Joined: 28. November 2008 15:01

Postby Sharley » 30. November 2008 05:40

localhost is the same as - the local loop back address, only accessible on your own PC not from anywhere else.

So the same super user root and it's password you set in the security pages is used for both.

So if you go to:
You are asked for
Username root
Password rootpassword

If you go to
You are asked for
Username root
Password rootpassword

In my XAMPP installation I do have a host with root and No password but I just followed what I typed above and could not access phpMyAdmin from without I use the root user and it's password - so even though the MySQL database and the phpMyAdmin Privileges both say No password under host for root user, you simply can't access with without using root with a rootpassword if you have set one for localhost (same as in the security pages.
User avatar
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 57 guests