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
and the user does exist, so why is this happening to me?
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
Code:
#! /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?