一些mysql运维指令

登录mysql：
mysql  -hlocalhost  -uroot  -pxxxxx
修改mysql登陆密码：
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxx'

#mysql停止/查看状态/启动
service mysqld stop
service mysqld status
service mysqld start

mysql远程访问授权
grant all privileges on *.* to 'root'@'%' identified by 'xxxxx' with grant option;
flush privileges;

mysql批量执行效率提升设置
&rewriteBatchedStatements=true