Mysql Cheatsheet

mysql的学习笔记总结

安装

https://www.jianshu.com/p/7cccdaa2d177

vi /etc/yum.repos.d/mysql-community.repo

[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

yum install mysql-server

常用命令

create database robot_flow_cluster character set utf8mb4;
create user 'robot_prd'@'%' identified by 'xxx';
grant all on robot_flow_cluster.* to 'robot_prd'@'%';
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');

注意root@%与root@localhost是两个用户

• 显示所有用户

  SELECT User, Host, Password FROM mysql.user;

FAQ

1. root 密码复位

   systemctl stop mysqld
   mysqld --user=mysql --explicit_defaults_for_timestamp=1 --skip-grant-tables
   
   # 再开一窗口
   mysql -uroot
   

改密码

FLUSH PRIVILEGES
alter user 'root'@'localhost' identified by '';
FLUSH PRIVILEGES

再重启数据库

kill '<mysqld>的进程'
systemctl start mysqld