安装MySQL

1、下载MySQL
#>wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
下载到指定位置后，就可以执行安装了

2、下载并安装MySQL
#>yum -y install mysql80-community-release-el7-3.noarch.rpm
#>yum -y install mysql-community-server

3、启动MySQL
#>systemctl start mysqld.service

4、查看MySQL服务
#>systemctl status mysqld.service
查看MySQL是不是开机自启，可以执行命令查看开机自启列表
#>systemctl list-unit-files|grep enabled

5、找出root用户的初始密码
#>grep “password” /var/log/mysqld.log

6、修改root初始密码
通过终端命令修改：
#>mysqladmin -u root -p password “新密码”; 回车
#>Enter password: 【输入原密码】
通过登录MySQL修改：
#>mysql -u root -p; 回车
#>【输入原密码】
mysql>use mysql;
mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘XXXXX’;
mysql> flush privileges;
mysql> exit;

7、新建用户
#>mysql -u root -p
#>【输入密码】
8.0之前
mysql> insert into mysql.user(Host,User,Password) values(“%”,“userA”,password(“XXXXX”));
8.0之后
mysql> create user ‘userA’@‘%’ identified by ‘XXXXX’;
用户授权
mysql> grant all privileges on . to ‘user A’@‘%’;
mysql> flush privileges;
如果想指定部分权限
mysql>grant select,update on testDB.* to user A@localhost identified by ‘XXXXX’;
如果想指定对所有数据库拥有select,delete,update,create,drop 权限
mysql>grant select,delete,update,create,drop on . to ‘userA’@‘%’ identified by ‘XXXXX’;
@“%” 表示对所有非本地主机授权，不包括localhost，如果想对localhost授权则
mysql>grant all privileges on testDB.* to user A@localhost identified by ‘XXXXX’;

8、删除用户
mysql>drop database testDB; //删除用户的数据库
删除账户及权限：
mysql>drop user 用户名@‘%’;
mysql>drop user 用户名@ localhost;

9、修改指定用户密码
mysql>update mysql.user set password=password(‘新密码’) where User=“test” and Host=“localhost”;
mysql>flush privileges;

10、 列出所有数据库
mysql>show database;

11、切换数据库
mysql>use ‘数据库名’;

12、列出所有表
mysql>show tables;