make-Linux学习20201120（第21课完）

mysql数据库

mysql -u root -p
show databases；，查看数据库
set password = passwd(‘dukang’)；修改root用户密码；
exit，退出数据库；

mysql -u root -p，使用root用户登录数据库
create user dukang@localhost idenfied by ‘dukangpasswd’; 创建用户dukang
grant 授权
select查询
update修改
delete删除
insert插入

增加授权
mysql -u dukang -p
show databases;
grant select,update,delete,insert on mysql.* from dukang@localhost;
exit

取消授权
mysql -u root -p
revoke select,update,delete,insert on mysql.* from dukang@localhost;
exit

创建表单、修改表单，查询表单
create database dukangdatabase;
show databases
use dukangdatabase;
show tables;
create table mybook(name char(15),price int,pages int);
describe mybook;
select * mybook;
insert into mybook(name,price,pages) valuse(‘dukangbook’,‘60’,‘501’)
slect * from mybook;
update mybook set price=50;
delete from mybook;
select * from mybook where price>50;
select * from mybook where price<60;
select * from mybook where price!=60;
select name,price from mybook;

数据库备份
mysqldump -u root -p dukangdatabase > dukangdatabase.dump

user dukangdatabase;
show tables;
select * from mybook;
drop mybook
show tables;

数据库恢复
mysqldump -u root -p dukangdatabase < dukangdatabase.dump

LNMP Linux Niginx mysql php
LAMP linux apache mysql php

mysql == mariadb

【源代码安装】
1、下载和解压
wget
tar

2、编译
./config
./configue

3、生成
make

4、安装
make install

5、清理
make clean

6、卸载
make uninstall

user/local/myslq 程序文件夹
usr/local/mysql/var 数据库文件夹

已学完