# ERROR 1064 (42000) at line 1

**URL:** <https://forums.percona.com/t/error-1064-42000-at-line-1/16704>\
**Category:** Uncategorized\
**Created:** [July 22, 2022, 3:46pm UTC](https://forums.percona.com/t/error-1064-42000-at-line-1/16704 "2022-07-22T15:46:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sunil\_Kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sunil_kumar/32/7044_2.png) [@Sunil\_Kumar](https://forums.percona.com/u/Sunil_Kumar)\
**Post date:** [July 22, 2022, 3:46pm UTC](https://forums.percona.com/t/error-1064-42000-at-line-1/16704/1 "2022-07-22T15:46:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Sunil\_Kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sunil_kumar/32/7044_2.png) [@Sunil\_Kumar](https://forums.percona.com/u/Sunil_Kumar)\
**Post date:** [August 12, 2022, 12:54am UTC](https://forums.percona.com/t/error-1064-42000-at-line-1/16704/2 "2022-08-12T00:54:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [September 1, 2022, 7:13am UTC](https://forums.percona.com/t/error-1064-42000-at-line-1/16704/3 "2022-09-01T07:13:49Z")

</div>

> [@Sunil\_Kumar](#):
>
> ERROR 1064 (42000)

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.