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

voytek at sbt.net.au
2017-08-15T11:25:08Z

On Tue, August 15, 2017 8:03 pm, Sami Ketola wrote:
>

>> On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote:
>>
>>
>> how do I generate hashed string from my password ?
>
> use this sql command:
>
> GRANT SELECT ON vmail TO ?vmail?@?127.0.0.1? IDENTIFIED BY
> PASSWORD(?yourpassword?);
>
>
> or if you just want to see the hash:
>
> SELECT PASSWORD(?yourpassword?);

Sami, thanks

I'm running in circles here.. I thought it worked once, but, couldn't
repeat it after

OK, I've made user 'test' with pw 'test1234'

using keyborad to enter test1234 I get:

# mysql  -u test -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1377
Server version: 10.1.19-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the
current input
statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]>

NOW:

MariaDB [(none)]> SELECT PASSWORD('test1234');
+-------------------------------------------+
| PASSWORD('test1234')                      |
+-------------------------------------------+
| *3D3B92F242033365AE5BC6A8E6FC3E1679F4140A |
+-------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> quit

copied '*3D3B92F242033365AE5BC6A8E6FC3E1679F4140A' to buffer

paste from buffer below, fail

# mysql  -u test -p
Enter password:
ERROR 1045 (28000): Access denied for user 'test'@'localhost'
(using
password: YES)

HMMM, maybe Putty copy/paste is screwed up...? ...?
tried shift/insert, still fails ?

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]>