[cobalt-developers] MySQL Guru sought

["Gavin Nelmes-Crocker" <cobalt@xxxxxxxxxxxxxxxx>]

Hi

I am trying to finish a new phpMyAdmin package using http authentication.
All is done but for one thing.  As it is a pkg and therefore for non techies
I don't want to have them SSH in to setup MySQL.  I need to execute the
following:

GRANT USAGE ON mysql.* TO 'cobaltworld'@'localhost' IDENTIFIED BY 'gavin';
GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv,
Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
Process_priv, File_priv,Grant_priv,Ref$
GRANT SELECT ON mysql.db TO 'cobaltworld'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON
mysql.tables_priv TO 'cobaltworld'@'localhost';

Some of the long line may have been truncated but you get the drift.  This
works at the command line with mysql -u root and then the password then
pasting the lines in, now I just need to know how to do this as a script and
we are away.  I've tried a couple of ways I thought might work from the
MySQL site but no luck

Anyone out there know the answer?

Regards

Gavin