Recent changes to 1686: (ok 4.5) Warn about "Any user" potential problem

#1686 (ok 4.5) Warn about "Any user" potential problem

2015-07-10T10:50:27.742000Z

summary: Warn about "Any user" potential problem --> (ok 4.5) Warn about "Any user" potential problem
status: open --> resolved
Priority: Normal --> Low

#1686 Warn about "Any user" potential problem

2015-07-10T10:47:40.376000Z

summary: User != identity (identities on Host % cannot connect) --> Warn about "Any user" potential problem
assigned_to: Madhura Jayaratne
Group: 4.4.6 --> Next_release

#1686 User != identity (identities on Host % cannot connect)

2015-07-10T10:46:28.092000Z

Ticket moved from /p/phpmyadmin/bugs/4973/

#4973 User != identity (identities on Host % cannot connect)

2015-07-08T14:19:20.383000Z

"User accounts" was accepted for the tab name, and we should also update some of the other terminology on that page to match.

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T21:52:10.500000Z

Thanks Marc (I had found it, but I admit that would probably not have been the case if it wasn't for my MediaWiki experience).

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T21:45:06.780000Z

See http://wiki.phpmyadmin.net/pma/Category:Meetings for IRC meeting's time and place. You're welcome to attend.

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T21:41:43.387000Z

Thank you Marc. IRC is a good idea; I will try to attend.

Account names

Also, the manual page you linked ( http://dev.mysql.com/doc/refman/5.7/en/account-names.html ) makes me realize MySQL uses the term "account name" to designate an "account identifier". I had never heard of this term, so I do not think users would understand it. However, I would still suggest using it, since the point of the terminological changes I recommend is of course to use the best terminology, but more importantly to ensure that users realize MySQL uses unorthodox access control.

I think it would be ideal to put a new "Account name" cell in the table header, over both "User" and "Host" cells, so users understand that Host is basically as important as User. Unfortunately, HTML tables have limitations, and as far as I know it will not be possible to make such an advanced header cleanly (i.e. without giving up thead), so I do not think this suggestion should be implemented at this point.

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T12:32:35.301000Z

To sum up this bug ticket, there are two issues involved:
- terminology clarification (now "users" versus "accounts")
- warning on the impact of an anonymous user

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T12:28:00.751000Z

assigned_to: Marc Delisle --> nobody

#4973 User != identity (identities on Host % cannot connect)

2015-07-02T12:27:44.394000Z

Terminology will be discussed at our IRC team meeting next week:
http://wiki.phpmyadmin.net/pma/2015-07_Meeting#Terminology:_Users_vs_Accounts