show plugins;

-- +-------------------------------+----------+--------------------+---------+---------+

-- | Name                          | Status   | Type               | Library | License |

-- +-------------------------------+----------+--------------------+---------+---------+

-- | binlog                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

-- | mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |

-- | mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |

-- | ...

create user 'someone'@'localhost' identified via 'mysql_native_password' by 'foo';

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

create user 'someone'@'localhost' identified via 'mysql_native_password' as 'foo';

-- ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

select password("foo");

-- +-------------------------------------------+

-- | password("foo")                           |

-- +-------------------------------------------+

-- | *F3A2A51A9B0F2BE2468926B4132313728C250DBF |

-- +-------------------------------------------+

create user 'someone'@'localhost' identified via 'mysql_native_password' as password('foo');

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

create user 'someone'@'localhost';

set password for 'someone'@'localhost' = password("foo");

select user,host,password,authentication_string,plugin from mysql.user where user = "someone";

-- +---------+-----------+----------+-------------------------------------------+-----------------------+

-- | user    | host      | password | authentication_string                     | plugin                |

-- +---------+-----------+----------+-------------------------------------------+-----------------------+

-- | someone | localhost |          | *F3A2A51A9B0F2BE2468926B4132313728C250DBF | mysql_native_password |

-- +---------+-----------+----------+-------------------------------------------+-----------------------+