ERROR 1064 (42000) at line 1

1

Hi,

I am new and trying all possibilities to migrate from MariaDB to percona. But stuck as a script not working on percona.

Part of shell script -

mysql -u root -p$MYSQLROOTPASS -v -e “create database $DBNAME;grant all on $DBNAME.* to $DBUSER@localhost identified by ‘$DBPASS’”

Error -

grant all on opendb.* to opendb@localhost identified by ‘FhzTwJE6DfE=’

ERROR 1064 (42000) at line 1: 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 ‘FhzTwJE6DfE=’’ at line 1

Please help.

2

Anyone? No one reverted. I request the admin /moderator or someone from support team to review and revert

3

Typically ERROR 1064 (42000) occurs due to syntax error. Syntax error could be due to typo and also at times coping from some apps to command prompt.