MySQL

找到镜像：

http://mirrors.163.com/mysql/Downloads/MySQL-8.0/

http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

解压：
tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

解压出来的文件：
mysql-community-common-8.0.19-1.el7.x86_64.rpm
mysql-community-libs-8.0.19-1.el7.x86_64.rpm
mysql-community-client-8.0.19-1.el7.x86_64.rpm
mysql-community-server-8.0.19-1.el7.x86_64.rpm

查询依赖是否安装：
yum list installed | grep openssl
yum list installed | grep libaio
yum list installed | grep perl

设置宽松模式：
setenforce=0

永久启用宽松模式：
vim /etc/selinux/config
更改： SELINUX=disabled

卸载mariadb:
yum remove mariadb-libs

安装依赖顺序：
common -> libs -> client -> server

rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm

查看安装：
yum list installed | grep mysql

启动服务：
service mysqld start

查找默认密码：
grep password /var/log/mysqld.log

登录mysql：
mysql -uroot -p密码

重置密码：
alter user user() identified by ‘密码’

更改root用户的Host：
update mysql.user set Host=’%’ where user=’root’

刷新：
flush privileges

登录：
mysql -h192.168.1.2 -uroot -p

安装Navicat Premium:

打开端口3306：
firewall-cmd —add-ports=3306/tcp —permanent
firewall-cmd —reload

select * from mysql.comppnent
uninstall component ‘…’

alter user ‘root’@’%’ identified with mysql_native_password by ‘root’

\q
\g: select * from mysql.users\G
\G
\s

! : 执行shell命令

help contents;

select user();
select database();

create database if not exists study charset utf8;
show databases;

create schema study1;

show create schema study1;

desc table名;

show create table course\G;

快速复制表结构：
create table course3 like course;

查看结构：
desc

查看创建sql：
show create

show privileges;

grant select on study.* tp ‘aaa’@’%’

grant all on…;

revoke all on … from ‘aaa’;

基础概念