john abreau writes: > On Sun, Jun 25, 2017 at 3:53 PM, dan moylan <[email protected]> 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) [email protected] www.moylan.us [no html pls] _______________________________________________ Discuss mailing list [email protected] http://lists.blu.org/mailman/listinfo/discuss
