MySQL安装随笔

$ wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
# 运行以下命令更新YUM源
$ rpm -Uvh https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
# 运行以下命令安装MySQL
$ yum -y install mysql-community-server
# 运行以下命令查看MySQL版本号
$ mysql -V

# 启动MySQL服务
$ systemctl start mysqld
# 设置MySQL服务开机自启动
$ systemctl enable mysqld
# 运行以下命令查看/var/log/mysqld.log文件，获取并记录root用户的初始密码
$ grep 'temporary password' /var/log/mysqld.log

$ cat /var/log/mysqld.log | grep password
A temporary password is generated for root@localhost: Qvqs0Pb&widu

$ mysql -u root -p

$ ALTER USER USER() IDENTIFIED BY '新密码';

$ ALTER USER '用户登录名'@'localhost'
  IDENTIFIED WITH mysql_native_password
  BY '登录密码';

# 查看原有用户
$ use mysql;
$ select user,host from user;
# 查看用户权限
$ show grants for 'root'@'%';
# 新建用户
$ create user '用户登录名'@'%' identified by '用户密码';
# 授权用户（为了安全，仅授权查询权限）
$ GRANT select ON 数据库名.* TO '用户登录名'@'%';
# 撤销授权
$ REVOKE select ON 数据库名.* FROM '用户登录名'@'%' ;
# 刷新权限
$ flush privileges

$ show global variables like 'port';

$ create database test;
$ source /root/test.sql

systemctl restart mysqld

# 已跳过权限验证，可直接进入
$ mysql
$ use mysql
# 将密码置空
$ update user set authentication_string='' where user='root';
$ flush privileges;
# 删除skip-grant-tables，重启mysql
# 不用输密码即可进入
$ mysql -uroot -p
$ use mysql
# 修改新密码
$ alter user 'root'@'localhost' identified by 'new_password';
$ flush privileges;