nicholas@beaumont:~/debian/svn/pkg-mysql/mysql-5.5/branches/wheezy$ mysql_setpermission -u root -p
#prompt="client> "
#read_buffer_size=100
#read_rnd_buffer_size=100
#max_allowed_packet=4096
Option p is ambiguous (password, port)
Password for user root to connect to MySQL: 
######################################################################
## Welcome to the permission setter 1.4 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do:
  1. Set password for an existing user.
  2. Create a database + user privilege for that database
     and host combination (user can only do SELECT)
  3. Create/append user privilege for an existing database
     and host combination (user can only do SELECT)
  4. Create/append broader user privileges for an existing
     database and host combination
     (user can do SELECT,INSERT,UPDATE,DELETE)
  5. Create/append quite extended user privileges for an
     existing database and host combination (user can do
     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
     LOCK TABLES,CREATE TEMPORARY TABLES)
  6. Create/append full privileges for an existing database
     and host combination (user has FULL privilege)
  7. Remove all privileges for for an existing database and
     host combination.
     (user will have all permission fields set to N)
  0. exit this program

Make your choice [1,2,3,4,5,6,7,0]: 2


Which database would you like to add: blah
The new database blah will be created

What username is to be created: www-data
Username = www-data
Would you like to set a password for www-data [y/n]: y
What password do you want to specify for www-data: 
Type the password again: 
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: %
Would you like to add another host [yes/no]: no
Okay we keep it with this ...
The following host(s) will be used: %.
######################################################################

That was it ... here is an overview of what you gave to me:
The database name	: blah
The username 		: www-data
The host(s)		: %
######################################################################

Are you pretty sure you would like to implement this [yes/no]: yes
Okay ... let's go then ...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-data@"%" IDENTIFIED BY 'blah123'' at line 1 at /usr/bin/mysql_setpermission line 267, <STDIN> line 10.