Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mysql_QA | ROOT137 BLOG #2

Open
imwang77 opened this issue May 21, 2020 · 1 comment
Open

Mysql_QA | ROOT137 BLOG #2

imwang77 opened this issue May 21, 2020 · 1 comment
Labels
6e39e6a7fbe6904ae636bd0bc6b4acf6 Gitalk

Comments

@imwang77
Copy link
Owner

https://root137.github.io/2020/05/21/Mysql_QA/

mysqldump 导出导入会重置密码？ 是否会重置密码取决于在导出导入的时候是否包括mysql库中的user表，而下面的语句导出所有的数据库，再导入的时候又没有排除的话，在下次数据库重启后相同用户的密码就会发生变化 12345导出所有的库mysqldump -u uname -p passwd --all-databases > mysqldate.sql导入数据文件mysql -u u
@imwang77
Copy link
Owner Author

good job

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
6e39e6a7fbe6904ae636bd0bc6b4acf6 Gitalk
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@imwang77