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 _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
