Anyone can connect with any username but no password
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
phpMyAdmin |
Fix Released
|
Undecided
|
Unassigned | ||
phpmyadmin (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Binary package hint: phpmyadmin
The mysql project, as stated in http://
Two anonymous-user accounts are created, each with an empty username. The anonymous accounts have no password, so anyone can use them to connect to the MySQL server.
On Unix, both anonymous accounts are for connections from the local host. Connections must be made from the local host by specifying a hostname of localhost for one of the accounts, or the actual hostname or IP number for the other. These accounts have all privileges for the test database and for other databases with names that start with test_.
So, the mysql-server is secure, because it accept anonymous account login from localhost only but phpmyadmin is acting as proxy to mysql server so anyone can access the test database.
At least, I have found many real world servers running phpmyadmin at /phpmyadmin and I can access the account. A person from #ubuntu-th also can access the test database, which the host(also on #ubuntu-th) had installed Simple Machines Forum into and he can export smf_user from it.
Steps to reproduce:
1. Go to any phpmyadmin instance.
2. Type anything (but not existing user) into the username.
3. Login (don't enter anything as password)
Suggestions:
1. Remove the anonymous account when phpmyadmin is installed, and show notice message to the user. (preferred in the same way as "Please restart any running Firefoxes" message as it isn't blocking dpkg)
2. Disable this account login via phpmyadmin.
3. Inform user when install phpmyadmin of this bug.
I don't think this bug should fix in mysql because the localhost restriction is just fine.
description: | updated |
description: | updated |
Same here on Intrepid.