MySQL启动和关闭、配置、用户管理
一、MySQL启动和关闭、配置、用户管理
# 进入mysql后台
mysql -u root -p
# 退出mysql后台
mysql > \q;
1、MySQL启动、关闭和查看运行状态:
# 启动
[root@yinminbo yinminbo]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
# 关闭
[root@yinminbo yinminbo]# service mysqld stop
Redirecting to /bin/systemctl stop mysqld.service
# 重启
[root@yinminbo yinminbo]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
# 查看状态
[root@yinminbo yinminbo]# service mysqld status
2、MySQL配置
# 进入MySQL
mysql -u root -p
# 查看MySql系统配置
cat /etc/my.cnf
3、MySQL root用户配置
# 查看root临时密码(temporary passwd)
grep 'temporary password' /var/log/mysqld.log
# 修改更改密码之后才能执行其他密码,否则会一直报提醒
ERROR 1820 (