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