Displaying 2 results from an estimated 2 matches for "yourpasswordhash".
2017 Aug 15
0
migrating 2.1 to 3.x, sql pass scheme, pass value?
...hat 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 'tes...
2017 Aug 14
3
migrating 2.1 to 3.x, sql pass scheme, pass value?
On Tue, August 15, 2017 8:54 am, Noel Butler wrote:
> On 15/08/2017 08:18, voytek at sbt.net.au wrote:
> Forget looking at dovecot at teh moment, your problem maybe mysql (I'd
> hope you meant mariadb but either way...)
>
> use command line mysql as vmail user from your dovecot machine to test
> password further BEFORE tinkering with dovecot.
>
> ~$ mysql -p -v vmail