Date: 11/23/07 (Java Web)    Keywords: mysql, sql

In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table. I learned few things about GRANT the hard way. MySQL allows you to create users associated with a particular host name [...]

Source: http://blog.taragana.com/index.php/archive/mysql-creating-users-granting-access-simplified/