mysql运维常用操作

# 查看mysql运行状态
systemctl status mysqld.service

# 重启mysql
systemctl restart mysqld.service

# 登录
mysql -u root -p

# 备份（全量）
mysqldump -u root -p -A > /utxt/soft/all.sql

# 备份恢复
mysql -u root -p < all.sql

-- 创建用户
create user '{userName}'@'{host}' identified by '{password}';

-- 分配库的权限给用户
grant all on {database}.* to '{userName}'@'{host}';

-- 设置网络访问权限
update mysql.user set host='%' where user='{database}';

-- 刷新权限
flush privileges;

-- 查询
select host,user,grant_priv,super_priv from mysql.user;