Linux服务器搭建mysql（centos7）

背景

操作系统：CentOS 7.6 64bit

安装

mysql官网下载https://dev.mysql.com/downloads/repo/yum/

下载后上传到服务器上

yum localinstall mysql80-community-release-el7-3.noarch.rpm

安装server

yum install mysql-community-server

开启mysql服务

service mysqld start

查看是否启动

ps -ef|grep mysql

修改密码

查看临时密码

grep 'temporary password' /var/log/mysqld.log

先用临时密码登录

mysql -uroot -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

刷新权限

flush privileges;

数据库操作

建立一个数据库

create database test; # 记得带上;
use test;

创建表

create table person(    
    name varchar(20) not null,
    age int,
    cardID varchar(30) not null,
    birthday date,
    primary key(cardID)
 );

插入数据

insert into person (name, age, cardID, birthday) value ('ljm',20,'123456789',now());
insert into person (name, age, cardID, birthday) value ('larmy',21,'1234567891',now());
insert into person (name, age, cardID, birthday) value ('armyliu',22,'1234567898',now());

查看数据

select * from person;
select name from person;
select name, age from person;
select name, age, cardID from person;
select name, age, cardID, birthday from person;

修改数据

update person set name="lljm" where name="ljm";

删除数据

delete from person where name="lljm";

删除表

drop table person;

删除数据库

drop database test;

LIKE语句

select name from person where name like '%ar%'

排序

select * from person order by age asc; #升序
select * from person order by age desc; #降序