Web Tutorials :: Go to previous category Database Go to next category :: Go to previous tutorial 4. How do I create a user to administer a MySQL database? Go to next tutorial
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

 
Web Tutorials :: Go to previous category Database Go to next category :: Go to previous tutorial 4. How do I create a user to administer a MySQL database? Go to next tutorial