Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month at the Massachusetts Institute of Technology, in Building E51.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql/mariadb



Check the section on Recovering the password
https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords



On 6/26/17, 12:21 PM, "Discuss on behalf of dan moylan"
<discuss-bounces+joe=polcari.com at blu.org on behalf of jdm at moylan.us> wrote:

>
>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]
>_______________________________________________
>Discuss mailing list
>Discuss at blu.org
>http://lists.blu.org/mailman/listinfo/discuss





BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org