mysqldump

8373c169ded54a2da593c35aed9a0c85b7c83daac385bfc4ae41f504cad7f5c25585cb8c407504220580d16cec36f1a13202728b7a7959f14d1b9f2ff12a7221ee23173d1adec6b5e075babea40bde0f254b9ca427c2a9e567cf69ad8ca13a0832cae4358787a3c941f987364af17193263d0a5f1cf109da0b5fa53fe1e21c751403105ab046028fa2b10d37e1a7f315154dc01dc179364af37f8a160071fe947bfe36aedf56a61c33a46b9098fe48740d98536fc4056b895886b2efd835fedb4624df9041fe63618bd0f2ba424bf451ff7f34dfe6ccd5915143987dba8c530c412e2a1dbc2dea185c8c7e490f4b7e8b583cc68ed1021dfd9 ...

1.创建一个用于备份数据库的用户mysql> create user 'backup'@'localhost' identified by '123';   2.添加权限2.1 添加 SELECT 权限根据报错，backup用户缺少select权限 [root@private_server ~]# mysqldump -ubackup -p123 -B wordpress > wordpress.sqlmysqldump: Got error: 1044: "Access denied for user 'backup'@'localhost' to database 'wordpress'" when selecting the database 给backup用户添加select权限 mysql> GRANT SELECT ON *.* TO 'backup'@'localhost& ...