[Discuss] mysql/mariadb

[jdm at moylan.us (dan moylan)]

john abreau writes:
> On Sun, Jun 25, 2017 at 3:53 PM, dan moylan <jdm at moylan.us> wrote:

>> running on an intel nuc pentium
>>
>> moylan ~[263] uname -a
>> Linux arcturus 4.11.6-201.fc25.x86_64 #1 SMP Tue Jun 20 20:21:11
>> UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>>
>> root ~[144] mysql -u root -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
>> (using password: YES)
>>
>> i've googled for this problem and found no solutions.  i may
>> remember incorrectly, but i don't believe this has been a
>> problem in the past.
>>
>> any suggestions as to how to set the root password and get
>> the mysql prompt?

> Here's what a google search turned up:

> https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password

went there .....

root mysql[792] mysql --version
mysql  Ver 15.1 Distrib 10.1.24-MariaDB, for Linux (x86_64) using readline 5.1

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxx';
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 'USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxxx'' at line 1

(ok -- can't see any typos, we try the alternative)

MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('xxxxxxxxxx') WHERE User = 'root' AND Host = 'localhost';
Query OK, 0 rows affected (0.08 sec)
Rows matched: 1  Changed: 0  Warnings: 0

(looks ok)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> quit
Bye

(now we kill it)

root ~[193] pseo mariadb
18731    27 Sl   11:20 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --skip-networking --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
root ~[194] kill 18737
root ~[195] pseo mariadb
[1]+  Done                    mysqld_safe --skip-grant-tables --skip-networking

(and restart)

root ~[196] systemctl start mariadb
root ~[197] mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root ~[198] mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

getting very discouraged.

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]