I am using sql adminstrator to create users.
When creating users in this way i note all the users have access to the information_schema database.
Is there a reason for this or a better way to create new users?

===========================

"INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains"

============================

TIA

You can try using PHPMyAdmin

That's how I create users when needed. Seems to give you a little more flexability than the administrator. (Althought the administrator comes in handy for other items)

PHPMyAdmin can sometimes be tricky to setup. But for security, I would limit access to it from your server only.

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

[FTA]
"Each MySQL user has the right to access these tables, but can see only the rows in the tables that correspond to objects for which the user has the proper access privileges. In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA.ROUTINES table), users who have insufficient privileges will see NULL."