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

Page: < 1 2

(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.

checking that user has been created

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.

creating user via 'CREATE USER' and granting privileges
Page: < 1 2