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 'identified by 'heslo'' at line 1

[Sivanesh1992]

Hi All.

I am Create new mysql database for pcscf, scscf and icscf, populate databases and grant permissions to respective users identified by a password

I was followed below steps :

$ mysql
CREATE DATABASE pcscf;
CREATE DATABASE scscf;
CREATE DATABASE icscf;

In all of the below steps, when prompted for mysql root user password, leave it blank i.e. Press Enter

Note: while asking password i given enter only

$ cd /usr/local/src/kamailio/utils/kamctl/mysql
$ mysql -u root -p pcscf < standard-create.sql
$ mysql -u root -p pcscf < presence-create.sql
$ mysql -u root -p pcscf < ims_usrloc_pcscf-create.sql
$ mysql -u root -p pcscf < ims_dialog-create.sql

$ mysql -u root -p scscf < standard-create.sql
$ mysql -u root -p scscf < presence-create.sql
$ mysql -u root -p scscf < ims_usrloc_scscf-create.sql
$ mysql -u root -p scscf < ims_dialog-create.sql
$ mysql -u root -p scscf < ims_charging-create.sql

$ cd /usr/local/src/kamailio/misc/examples/ims/icscf
$ mysql -u root -p icscf < icscf.sql

but while giving grant i am getting below error:

mysql> grant delete,insert,select,update on pcscf.* to pcscf@localhost identified by 'heslo';
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 'identified by 'heslo'' at line 1

Please help me to resolve the issue . I am understand how to resolve

[Sivanesh1992]

.