trouble with mysql

[Arnar Thorarinsson]

OK I'm trying to create a database for nagios,creating a user called
nagios and giving it the privileges needed but always getting :
ERROR 1045: Access denied for user: 'nagios at localhost' (Using password:
YES)

tried doing FLUSH PRIVILEGES after these statement( should not have to
though since using GRANT command )

echo "create database nagios" | mysql -u root -p 
cat create_mysql | mysql -u root -p -D nagios
echo "GRANT LOCK TABLES ON nagios.* TO nagios@'%' IDENTIFIED BY
'nag04';" | mysql -u root -p 
echo "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON nagios.* TO
nagios@'%';" | mysql -u root -p 

Ok Perhaps I'm just blind but what is wrong with these statements! 

MySQL version: 4.0.20-standard-log

-- 
Regards
Arnar Thorarinsson

Software Programmer / System Administrator
Systems Department, Air Traffic Services
Phone : +354 569 4289
------------------------------------------
Icelandic Civil Aviation Administration
Reykjavik Airport
IS 121 Reykjavik
Iceland
http://www.caa.is
------------------------------------------



-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null