How do I create a user to administer a MySQL database?
Author: Deron Eriksson
Description: This tutorial describes creating a user to administer a MySQL database.
Tutorial created using: Windows XP || MySQL 5.0.27
(Continued from page 1)
One way to check that the user has actually been created is to 'use' the 'mysql' databaseW and then view the current users in the 'user' table via a select statement.
Of course, a user can also be created via a 'CREATE USER' statement, if you'd like. You can then grant privileges to a database to this user.