常用的一些 MYSQL 命令

1

systemctl restart mysqld

1

mysql -u root

1

mysql -u root -p

1
2
3
4

USE mysql;
SELECT user, host FROM user;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

1

mysqldump -uroot -proot --all-databases >/tmp/all.sql