[Discuss] mysql/mariadb

[jdm at moylan.us (dan moylan)]

john abreau writes:
> OK, I gave it a try and it didn't work.

> The following got it working. FYI, mysql --version shows

>     mysql  Ver 15.1 Distrib 10.1.21-MariaDB, for Linux (x86_64) using
> EditLine wrapper

> sudo systemctl stop mariadb
> sudo mysqld_safe &
> mysql -u root
>     set password for 'root'@'localhost' = password('EXAMPLE') ;
>     \q
> sudo kill $( sudo cat /var/run/mariadb/mariadb.pid )
> sudo systemctl start mariadb

thanks, did that and got in using mysql -u root -p
whooooeee!
then:

MariaDB [(none)]> grant all on *.* to moylan_moy identified by 'xxxxxxxxx';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show grants for moylan_moy;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for moylan_moy@%                                                                                            |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'moylan_moy'@'%' IDENTIFIED BY PASSWORD '*4C746C6A35DE6C965E5BD9B4040AA0D47D47E604' |
+--------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> quit
Bye
moylan ~[285] mysql -u moylan_moy -p
Enter password:
ERROR 1045 (28000): Access denied for user 'moylan_moy'@'localhost' (using password: YES)

tried it several times, no typos -- any thoughts?

ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[no html pls]