linux、mysql日常工作备忘录
Mysql
==mysql8远程授权访问========================================== use mysql; mysql8不再允许直接对root用户授权远程访问，需要新建一个用户。 CREATE USER 'root'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; mysql8数据备份============================================ mysqldump -u your_username -p your_password your_database > backup_file.sql mysqldump -u your_use