> the other one gives syntax error:
>
> MariaDB [(none)]> GRANT SELECT on test to 'test'@'127.0.0.1' identified
> by pasword('test1234'); ERROR 1046 (3D000): No database selected
> MariaDB [(none)]> use test;
> Database changed
> MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by
> pasword('test1234'); ERROR 1064 (42000): You have an error in your SQL
> syntax; check the manual that corresponds to your MariaDB server version
> for the right syntax to use near 'pasword('test1234')' at line 1 MariaDB
> [test]>
>
OOPS, type, single 's' in password, but, still error:
MariaDB [(none)]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by
password('test1234');
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by
password('test1234');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to
use near '('test1234')' at line 1
MariaDB [test]>
