system qq( ssh example.com "
         mysql -e 'GRANT ALL ON $rbase.* TO \'$dbUser\'\@\'localhost\' IDENTIFIED BY \'$dbPass\';'
         ");

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 '123456' at line 1

ssh example.com 'mysql -e "GRANT ALL ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';"'

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 'password' at line 1

     my $args = qq(  
         CREATE DATABASE IF NOT EXISTS $base;
         GRANT ALL ON $base.* TO '$OWNER'\@'localhost';
         GRANT ALL ON $base.* TO '$dbUser'\@'localhost' IDENTIFIED BY '$dbPass';
         );
 
     system qq(mysql -e "$args");

     # Preparing SQL
     use File::Temp qw(tempfile); 
 
     my ( $handle, $tmpfilename ) = tempfile( "jsXXXXXX", 
         DIR => $wich,
         SUFFIX => '.sql' ); # Даёшь временный файл с SQL

     print $handle "CREATE DATABASE IF NOT EXISTS $rbase;";
     print $handle "GRANT ALL ON $rbase.* TO '$user'\@'localhost' IDENTIFIED     BY '$dbPass';";
     close $handle or die "Can't close $handle: $!\n";

     system qq( ssh example.com " 
         cd /home/$user/data/www/$where; 
         pwd; 
         chown -R $user:$user *; 
         mysql < $tmpfilename;   # Создаём базу и пользователя
         mysql $rbase < $dump;   # Дамп в базу 
         rm $dump; 
         rm $tmpfilename; 
         ");