mysqldump备份数据库
E:\environments\mysql-8.0.32-winx64\bin\mysqldump.exe --skip-lock-tables --routines --add-drop-table --disable-keys --extended-insert -u root --host=43.143.9.251 --port=7013 jackusers
mysql授权
mysql version为8之下 root’@'% 授权
grant all privileges on *.* to 'root'@'%' identified by ".";
flush privileges;
mysql version为8及之上
root’@'% 授权
- 创建root@%用户 ****** 为mysql密码
create user 'root'@'%' identified by '******';
- 赋予权限: grant 权限列表 on 数据库 to ‘用户名’@’访问主机’ ;(修改权限时在后面加with grant option)
grant all privileges on *.* to 'root'@'%' with grant option;
3.数据库直接对表修改权限后记得执行下 flush privileges;
刷新下权限列表,不然修改会不生效