migrating 2.1 to 3.x, sql pass scheme, pass value?

voytek at sbt.net.au voytek at sbt.net.au
Tue Aug 15 14:45:16 EEST 2017


On Tue, August 15, 2017 9:31 pm, Ivan Warren wrote:
> 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]>
>>
> A bit OT but...
>
>
> It's either identified by 'YourPassword';
> or Identified by password 'YourPasswordHash';
>
>
> https://dev.mysql.com/doc/refman/5.7/en/create-user.html

Ivan, thanks!

syntax fixed, I'll try as root

MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by
'test1234';
ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for
table 'test'
MariaDB [test]> GRANT SELECT on test to 'test'@'127.0.0.1' identified by
password'*3D3B92F242033365AE5BC6A8E6FC3E1679F4140A';
ERROR 1142 (42000): GRANT command denied to user 'test'@'localhost' for
table 'test'





More information about the dovecot mailing list