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)
[email protected]
www.moylan.us
[no html pls]
_______________________________________________
Discuss mailing list
[email protected]
http://lists.blu.org/mailman/listinfo/discuss
