MySQL关闭与启动命令总结

MySQL关闭与启动

#正常关闭MySQL
mysqladmin -uroot -p -h127.0.0.1 shutdown
#启动MySQL
mysql_dir/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
#MySQL重置密码,先关闭MySQL再进行
vi /etc/my.cnf
#添加下面内容
[mysqld]
skip_grant_tables=1
#启动MySQL
mysql
#更改密码
use mysql; 
update user set password = PASSWORD('password123') where user = 'root'; 
flush privileges;
 #启动MySQL
mysqld --defaults-file=/etc/my.cnf --user=mysql &
mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
service mysql start # systemctl start mysqld
/etc/init.d/mysq start
mysqld_multi start
#多实例
net start mysql  #Windows
#关闭MySQL
mysqladmin -uroot -plhr -S /tmp/mysql3306.sock shutdown #版本对应
service mysql stop # systemctl stop mysqld
/etc/init.d/mysql stop
mysqld_multi stop  #多实例
net stop mysql  #Windows
mysql> shutdown;# above MySQL 5.7.9
#杀死MySQL
killall mysqld
killall -9 mysqld
pkill -9 mysqld

5.7后password字段改为authentication_string。还可使用update user root@localhost identified by ‘Aa123456’; flush privileges;