Problem installing Nconf to use with Nagios - MySQL Problem
Hello,
I was following the installation manual that's on the official website, but cant proceed because i can't do this:
$> mysql -u root -p
Enter password:
mysql> CREATE DATABASE DBNAME;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON DBNAME.* TO 'DB_USER'@'localhost' IDENTIFIED BY 'DB_PASS';
when I try:
grant select, insert, update, delete, create, drop, alter on nconf.* to admin@localhost identified by 12345; i get:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '12345' at line 1
what's the problem?
|