The exclusive promotional activities on JCOP J3H145 card and Feitian R301 Smartcard Reader are in full swing. Please check this page for details.

Mysql under Linux forgot password solution

Smartcard solutions

Moderator: product

youyou
Posts: 55
Joined: Fri Jul 06, 2018 3:42 am
Points :382
Contact:

Mysql under Linux forgot password solution

Post by youyou » Mon Apr 08, 2019 11:27 pm

>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

youyou
Posts: 55
Joined: Fri Jul 06, 2018 3:42 am
Points :382
Contact:

Re: Mysql under Linux forgot password solution

Post by youyou » Mon Apr 08, 2019 11:27 pm

mysql> use mysql;
Database changed
mysql> select User from user; #Here is the query user command
+-----------+
| User |
+-----------+
| ******* |
| mysql.sys |
| root |
+-----------+
3 rows in set (0.00 sec)

youyou
Posts: 55
Joined: Fri Jul 06, 2018 3:42 am
Points :382
Contact:

Re: Mysql under Linux forgot password solution

Post by youyou » Mon Apr 08, 2019 11:28 pm

mysql> update user set password=password("*******") where user="*******"; #Change the password and report an error (I succeeded with this version)
ERROR 1054 (42S22): Unknown column 'password' in 'field list' :cry:
mysql> update mysql.user set authentication_string=password('*******') where user='*******'; #Password changed successfully :D
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

youyou
Posts: 55
Joined: Fri Jul 06, 2018 3:42 am
Points :382
Contact:

Re: Mysql under Linux forgot password solution

Post by youyou » Mon Apr 08, 2019 11:29 pm

mysql> flush privileges; #Effective immediately
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

n>mysql -u ******* -p #Login successfully as this user. :) :) :)
Enter password: ********
…………………………

Post Reply Previous topicNext topic

Who is online

Users browsing this forum: No registered users and 1 guest

JavaCard OS : Disclaimer