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.