script to execute mysql command

[dagoat10]

I have been trying and trying and trying, i have no idea was is wrong.

I wrote this script to grant a privilege on a table in a mysql database and it keeps saying no grant defined for user test1 at host localhost

#! /bin/bash

mysql -u root -p <<EOFMYSQL
use mysql
Grant create on Fantasy_Football_2010.* to test1@localhost;
show grants for test1@localhost;
EOFMYSQL

and the user does exist, so why is this happening to me?

 

[dagoat10]

is there anything i can do or should i come up with an alternative

 

[towerbase]

Perhaps there should be a semicolon after

use mysql

I would guess that mysql would treat

use mysql
Grant create on Fantasy_Football_2010.* to test1@localhost;

as one command and obviously fail.
Perhaps your code should look like

#! /bin/bash

mysql -u root -p <<EOFMYSQL
use mysql[b];[/b]
Grant create on Fantasy_Football_2010.* to test1@localhost;
show grants for test1@localhost;
EOFMYSQL

But I'm only guessing

Andrew
Hampshire, UK