centos下：mysql一些指令+mysql首次修改密码+mysql忘记密码修改

1.操作

1.1查看mysql运行状态

systemctl status mysqld

1.2停止mysql

    systemctl stop mysqld

 1.3启动mysql

    systemctl start mysqld

  1.4重启mysql

    systemctl restart mysqld  

  1.5开启mysql开机自启动

    systemctl enable mysqld

   1.6关闭mysql开机自启动

    systemctl disable mysqld

2.查看具体的报错日志

2.1只看ERROR的

cat /var/log/mysqld.log | grep ERROR

3.mysql首次修改密码

3.1查看默认密码

grep "password" /var/log/mysqld.log

3.2进入到mysql里面

mysql -uroot -p

3.3设置密码强度和长度的限制

    set global validate_password_policy=LOW;

    set global validate_password_length=17;

3.4修改密码

alter user 'root'@'localhost' identified by '0123456789_123456';

4.mysql忘记密码修改

4.1修改 /etc/my.conf

新增 skip_grant_tables

vim  /etc/my.conf

4.2重启一下mysql

    systemctl restart mysqld  

4.3进入到mysql里面

mysql -uroot -p

不用输入密码 直接回车

4.4 修改密码

    use mysql;

    update user set authentication_string= password("root") where user='root';

4.5去除 skip_grant_tables

重启    systemctl restart mysqld