登录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