MySQL :: MySQL 5.1 Reference Manual :: 6.3.2 Adding User Accounts

To set up the custom accounts without GRANT, use INSERT statements as follows to modify the grant tables directly: shell> mysql --user=root mysql mysql> INSERT INTO user (Host,User,Password)-> VALUES('localhost','custom',PASSWORD ...

dev.mysql.com