1.问题描述

  • MySQL版本号：MySQL Server 8.3
  • MySQL持久化到处数据库结构及数据
mysqldump: Got error: 1049: Unknown database 'root' when selecting the datab

mysqldump: Got error: 1049: Unknown database ‘root‘ when selecting the datab_MySQL

2.问题解决

  • cmd 切换本地路径
cd /d D:\Program Files\MySQL\MySQL Server 8.3\bin
  • 执行数据库备份命令
mysqldump -uroot -p --default-character-set=utf8 news>D:\桌面\newsoais.sql

mysqldump: Got error: 1049: Unknown database ‘root‘ when selecting the datab_mysql_02