mysql密码配置和备份

mysql密码配置和备份

密码配置

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 
flush privileges;

开放访问

use mysql;
update user set host="%" where user='root';
flush privileges;

数据库备份

mysqldump -h127.0.0.1 -uroot  -p123456 <database_name> --tables <table_names>  > backup.sql

数据库恢复

mysql -uroot -p --one-database <database_name> < backup.sql

查看和赋予权限

show grants for root;
GRANT <privileges> ON <what>  TO <user> [IDENTIFIED BY "<password>"]  [WITH GRANT OPTION];

docker快速安装
docker run --name mysql -v /mysql:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest