1. I wake up in the morning , I found that the database on my server was hacked

The people who hacked my database asked me for money ,0.035 Bitcoin

I can qtmd,69 One year's student computer .... It's just a pity that the experimental data of my project

 

2. There is no way to restore the data without backup , You can only change the database password

2.1 Make a note of the changes docker In the container MySQL Password steps

*
get into docker container
docker exec -it ***** /bin/bash
*
get into mysql
mysql -u root -p
Then enter the password according to the prompt

*
Change Password
user mysql; update mysql.user set authentication_string=password('*******')
where user='root'; flush privileges;
*
sign out

*
sign out mysql exit

*
sign out docker ctrl+pq

*
restart docker container
docker ps docker restart ******
 

2.2 At this time, the password should be changed successfully , Just reconnecting

*
Changing the password is actually changing it mysql Fields in the table , stay MySQL5.7 After that, the password field becomes authentication_string

So change the password It's modification authentication_string

*
Remember to restart after modification docker container

 

3. The lesson of blood and tears

The database password is too simple to be hacked , Both of my server databases have been attacked

Never use it 123456 This code

And then there is , Remember to back up the database ...... Timely backup .....!!!!!!!!!!!!!!!!!!!!!

Change the password , My project has to be redeployed QAQ.... Gan

Technology
©2019-2020 Toolsou All rights reserved,
el-ui:select Get value c Language rose advertising code fio Use details Golang Array bisection , Array split , Array grouping Centos7 lower mysql8.0 To install and change the initial password ;Spark SQL- programming css Basics 2:flex Multi row layout with gaps python read , write in txt Text content rk3399_android7.1 debugging USB Summary of Bluetooth module python Dynamic programming for single source shortest path