trouble with mysql
Arnar Thorarinsson
art at caa.is
Fri Aug 27 17:07:01 CEST 2004
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
More information about the Users
mailing list