mysql安装教程

删除原生mariadb

rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64

yum remove mariadb-libs-5.5.56-2.el7.x86_64

rpm -e mariadb-libs-5.5.56-2.el7.x86_64

安装包

可以去官网下载

 mysql-community-libs-8.0.20-1.el7.x86_64.rpm
 mysql-community-client-8.0.20-1.el7.x86_64.rpm
 mysql-community-server-8.0.20-1.el7.x86_64.rpm

安装mysql

将rpm包放在/opt/app/mysql目录下，执行以下命令：

[root@t24nalagw01kf mysql]<20200601 18:28:34># rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm
warning: mysql-community-libs-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-8.0.20-1.el7################################# [100%]
[root@t24nalagw01kf mysql]<20200601 18:28:47># rpm -qa | grep  mysql-community-libs
mysql-community-libs-8.0.20-1.el7.x86_64
[root@t24nalagw01kf mysql]<20200601 18:28:52># rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm
warning: mysql-community-client-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-8.0.20-1.e################################# [100%]
[root@t24nalagw01kf mysql]<20200601 18:29:14># rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm
warning: mysql-community-server-8.0.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-8.0.20-1.e##################                ( 54%)
################################# [100%]
[root@t24nalagw01kf mysql]<20200601 18:31:15># 

启动mysqld

service start mysqld

查看初始密码

初始密码为：B1HT.kRa=yhn

[root@t24nalagw01kf log]<20200601 19:24:28># cat /var/log/mysqld.log
2020-06-01T10:57:58.630784Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.20) initializing of server in progress as process 99116
2020-06-01T10:57:58.645198Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-01T10:57:59.821083Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-06-01T10:58:02.690122Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: B1HT.kRa=yhn
2020-06-01T10:58:07.167606Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 99363
2020-06-01T10:58:07.183159Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-01T10:58:07.600339Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-06-01T10:58:07.762161Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-06-01T10:58:08.005741Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-06-01T10:58:08.041679Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.

登录mysql

mysql -u root -p

修改初始密码

ALTER USER root@localhost IDENTIFIED BY 'Qzmp123!@#';

新建用户

CREATE USER hammer@% IDENTIFIED BY 'Qzmp123!@#';
CREATE USER 'sampadm'@'localhost' IDENTIFIED BY 'Qzmp123!@#';
create database sampdb;
grant all on sampdb.* to 'sampadm'@'localhost';

新建数据库

CREATE DATABASE ham_message;

用户授权

 grant all privileges on ham_message.* to hammer@'%';

指令

\g 命令结束，go的意思。
\G 命令结束，垂直显示结果。
; 命令结束。

函数

now() user() version()

显示当前系统时间 登录用户 服务器版本

mysql> select now(), user(), version();
+---------------------+----------------+-----------+
| now()               | user()         | version() |
+---------------------+----------------+-----------+
| 2020-07-23 17:29:14 | root@localhost | 8.0.20    |
+---------------------+----------------+-----------+
1 row in set (0.00 sec)

database()

检索默认数据库

mysql> select database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

mysql> use sampdb;
Database changed
mysql> select database();
+------------+
| database() |
+------------+
| sampdb     |
+------------+
1 row in set (0.00 sec)

mysql -u sampadm -p sampdb
mysql> select database();
+------------+
| database() |
+------------+
| sampdb     |
+------------+
1 row in set (0.00 sec)

美史联盟表

prisident表

字段	约束	描述
姓名

describe 命令

describe student ‘sex’;

学生表

create table student( name varchar(20) not null, sex enum('F', 'M') not null, student_id int unsigned not null auto_increment, primary key (student_id) ) engine = InnoDB;

create table grade_event (
	date date not null,
    category enum('T', 'Q') not null,
    event_id int unsigned not null auto_increment,
    primary key(event_id)
) engine = InnoDB;